| Author |
Topic |
|
jassie
Constraint Violating Yak Guru
332 Posts |
 Posted - 2013-10-10 : 22:06:42
|
| 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? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-10-11 : 01:22:27
|
| 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------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
jassie
Constraint Violating Yak Guru
332 Posts |
Posted - 2013-10-11 : 09:28:04
|
| 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? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-10-11 : 13:54:11
|
| extra reports to follow the main reportwhat does that mean?one below other in a page?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
jassie
Constraint Violating Yak Guru
332 Posts |
Posted - 2013-10-11 : 21:49:05
|
| This would be a totally separate report. It would not be an embedded report within the main report. It would be a separate report like a drill though report is. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-10-12 : 05:59:44
|
| For that you can use jump to report functionality available within Navigation Action of textbox. you can also define and pass parameters through it------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
jassie
Constraint Violating Yak Guru
332 Posts |
Posted - 2013-10-12 : 11:44:01
|
| 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. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-10-12 : 13:57:28
|
| not subreports. I was suggesting to use different rdl files and using jump to report functionality from master to navigate to child------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
jassie
Constraint Violating Yak Guru
332 Posts |
Posted - 2013-10-12 : 23:58:13
|
| Thanks! |
|
|
|
|
ssrs 2008 r2 generate extra reports