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

Subreport - formula from Main report

Status
Not open for further replies.

AntonioPerera

Vendor
Jan 29, 2006
91
AU
I have a report which I now want to incorporate into another main report as a subreport.

The report has uses parameters YEAR and PERIOD.

The YEAR parameter is linked to a field in the database and I can use selection criteria but the PERIOD is used in a formula field.

How can I get a formula from my main report into the subreport formula field to substitute the PERIOD ?
 
Just create a parameter in main report called period with same data type as sub report.

Then when linking link main report param to sub report param, using box in lower left hand side, open drop down and scroll to PERIOD parameter.

Ian
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top