In a ssrs 2008 r2 report, I want to always run a main report. However I want to add parameters to the main report when it is executed so that 'related' reports are executed. When the reports are executed, I would like the following to occur: 1. The user will select which reports that are to be executed by using parameters that are supplied to the SSRS 2008 report. 2. What reports should be executed will be based upon what the user selections. 3. The order of the reports will be setup to run in a predefined order. 4. The reports will run in a sequential order. One report will not run until the first report is completed. 5. The report output will be attached to the main report in a seqnetial order.
Can you tell me how to accomplish the goals I have listed above using SSRS 2008 r2? Also if all goals are not possibly for what I listed above, can you tell me how to complete the tasks that are possible?
Sounds like what you need is a ssrs report with multiple subreport inside as per your sequence. Check the value for parameters and based on them you can make subreport visible or not to call and render the child reports. The order of execution of reports cannot be controlled until you define a work flow in either sql server agent or using SSIS. in Subreport method will execute all reports simultaneously and then load them into master
I would like the extra reports to follow the main report. I do not want the reports embedded in the main report. To would I use subreports, drill through reports, and /or data regions? How would I setup this code?
Will 'report functionality available within Navigation Action of textbox' work for a subreport? From what I have read about subreports, that only workls when the report is embedded within the 'main report.