Interaction of SQL Designer Query with Parameter and Subreports

[asmetana]

I have a report with ~40 subreports in it. To speed processing, I am using a query created with SQL Designer. If I run the query without a parameter (explicitly setting the where criteria), save the query and data, and then run the report, the report works great. This requires a multistep process to generate the final report.

If instead I use a parameter with the query, the report prompts for the parameter (as expected), but each and every subreport also prompt for the parameter.

Is there a way to get the main report to prompt for the parameter, run the query, and then get all of the subreports to use the results of the first query?

 

[csm2]

Try linking subreports to main report by the parameter