Babette,
Another important point when using shared variables in subreports. Your shared variable is not evaluated until the section AFTER the section where the subreport is. In other words, if you have a subreport in the Group Footer A section, and then put a formula with your shared variable in the Main report in that same section, you're not going to get the right value in your formula. It will show the PREVIOUS value that was put into that variable.
To see the variable accurately, you would need to either create a Group Footer B section, or else use it further down in the report. (ie. in the Report Footer).
Also, you need to have the variable declared as shared in each formula that you use the variable in.
Troy Funte
Liberty Electronics
Another important point when using shared variables in subreports. Your shared variable is not evaluated until the section AFTER the section where the subreport is. In other words, if you have a subreport in the Group Footer A section, and then put a formula with your shared variable in the Main report in that same section, you're not going to get the right value in your formula. It will show the PREVIOUS value that was put into that variable.
To see the variable accurately, you would need to either create a Group Footer B section, or else use it further down in the report. (ie. in the Report Footer).
Also, you need to have the variable declared as shared in each formula that you use the variable in.
Troy Funte
Liberty Electronics
----- Original Message -----
From: Adam Ellis
To: vantage@yahoogroups.com
Sent: Wednesday, November 13, 2002 11:19 AM
Subject: Re: [Vantage] Crystal - Sum from Sub_report
Babette,
What you are looking for is a shared variable. For example, lets say on
the main report you want to share SumOfNumberX - you create a formula
and drop it on the report:
Shared NumberVar MyVariable := SumOfNumberX;
Now, when you go into the subreport, this value is available (lets say
you want to increment it by SumOfNumberY):
Shared NumberVar MyVariable := MyVariable + SumOfNumberY;
Now, on the report footer you can access this value by recalling the
variable:
Shared NumberVar MyVariable;
Note, using variables in Crystal is highly dependent on where you drop
them. Dropped on the header will get evaluated once while on the Detail
will get evaluated for each record. Let me know if you need any help -
this is what I do for a living.
--
Good luck,
Adam Ellis
Senior Consultant - SaberLogic, LLC
Ph: (330) 335-6442
Mobile: (330) 697-3883
Babette Welch wrote:
>There is so much talent about Crystal her, it seems the place to ask this.
>]
>Crystal 8.0
>Vantage 5.1
>Running a report summarizing labor & material on jobs
> Material is a sub-report
> Material cost sums on the sub report and prints in a group-footer on the main report
>
>I need to totals all of those sums from the sub-report into the report footer of the main report.
>
>Any ideas how to do that?
>
>BW
>
>=============================================
>Babette Welch
>MIS Director
>Argonics
>1110 Wright
>Marquette MI 49855
>906.226.9747 ext 235
>906.228.0951 fax
>
>
>
>
>[Non-text portions of this message have been removed]
>
>
>
>Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
>(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
>(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
>(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]