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!

Usin Subreport Value in Main Report Formula

Status
Not open for further replies.

crystalhelp1

Technical User
Aug 21, 2010
19
US
I have a report that pulls in a number value from a subreport. Is it possible to use the subreport value in my main report?
 
Yes, if you create a formula in the subreport footer that shares the value:

whileprintingrecords;
shared numbervar x := <your sub value here>;

Then in the main report, in a section below the one containing the subreport, e.g., in GHb if the sub is in GHa, use a formula like this:

whileprintingrecords;
shared numbervar x;
x * {main.qty} //sample calculation

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top