Subreports and Parameters

[strom99]

I have a report that shows a product #. I have 4 subreports that show other information regarding the product id on the main report. Is it possible for the user to be able to click the product ID and then prompt them to select a subreport and pass that product Id to the subreport. Right now I have for text fields at each detail section of the report that use the following to get to the subreport, but it clutters up the report. Thank you.

"

http://servername/folder/report.rpt...prompt0="+{pr_rpt_das007a;1.good_svc_id}

 

[chris777]

I would link the sub-reports by productid and then based on the sub-report the select (which is hard coded into your parameter definition) supress the non-selected subreports.

Caution: supressing a subreport prevents it from running so if you need any values from that report they will not show up.