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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Using Data from subreports in Formulas

Status
Not open for further replies.

harrySCOTT

Technical User
Feb 10, 2003
6
US
Is it possible to use data from a subreport in a formula in the Main Report?

 
Yes, with a shared variable. However... caveat here... the subreport must appear physically within the report BEFORE you use the shared variable in the main report.

Lisa
 
You can use the data from the sub-report as Lisa mentioned however the subreport must be executed (built) but can be supressed and not displayed.
 
Is the shared variable the same as the field that links the sub to the main?
 
No, check out the help sections on shared variable. They should give you a start on what all you need to do.

Lisa
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top