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!

Parameter Fields and Subreports

Status
Not open for further replies.

MrTBC

Technical User
Nov 19, 2003
610
US
Crystal 8.5 Progress Database
I have a main report that prompts for two parameters (Period and Year) and contains six subreports. I want to be able to refer to parameters in each of the subreports in formulas, but don't want to use them directly to select data in the subreports.
As it stands I am being prompted to enter the parameters for each subreport and the main report when refreshing it.

I only want to be asked for them once.

How can I achieve this please?
 
You need to link your subreports to the main report. Link the parameters from the main report to parameters in the subreport. Since you don't want to use the parameters as selection criteria, leave the 'Select data in subreport based on field' checkbox unchecked.
 
Thanks. I did that but it was still happening. Then realised I was refering to the parameters from the main report rather than the subreport in my formulas.
Working now!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top