Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Sub Report Calculations

Status
Not open for further replies.

plextor

IS-IT--Management
Jan 7, 2003
34
US
Is it possible to use the values returned by a sub report to calculate values returned from the main report. If so, how?

Thanks,
Brian
 
If you create them as shared variables in the subreport, you can also declare them and then reference them in calculations in the main report, although the calculation formula must be placed in a section of the main report somewhere below the one containing the subreport.

-LB
 
I'm not familar with Shared Variables. How do i go about setting that up?

Thanks again,
Brian
 
Plextor

In your sub report (obviously change to suit your needs)

WhilePrintingRecords;
Shared NumberVar YourVariableName := Whatever

Then in your main report

WhilePrintingRecords;
Shared NumberVar YourVariableName
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top