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

Use Parameters to Call Same Subreport Multiple Times

Status
Not open for further replies.

WPrinkey

Programmer
Jun 25, 2004
8
US
I have a report which is going to contain several different types of charts, which I will need to create as subreports. I am placing these charts in the REPORT FOOTER sections of the report (one report footer per row of charts).The report will include 3 pie charts.

As I started to generate the subreport for the first pie chart, I noticed that the 3 pie charts are all formatted the same with the exception of the title and the selection formula. Originally, I was going to create a separate subreport for each of the 3 pie charts. My preference would be to use the 1 subreport and to add a new parameter to determine Chart 1, 2 or 3.

Am I able to pass a hardcoded parameter link to the subreport for each individual instance? I can not see how to do that. I have thought about doing a formula that could possible be changed in each report footer, but I have 2 pie charts within one footer.

If I am not able to do this as a hardcoded parameter, I suppose I can add some dummy field to my SQL for the main report and pass different values that way.
I am using CR8.5.
 
If you place the parameter in the sub report, when you run the main report, the sub report parameter prompt will come up for the user. I don't think you really need to pass it from the main report to the sub report.
MrBill
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top