SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 ssrs 2008 r2 generate extra reports
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jassie
Constraint Violating Yak Guru

312 Posts

Posted - 10/10/2013 :  22:06:42  Show Profile  Reply with Quote
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

India
52325 Posts

Posted - 10/11/2013 :  01:22:27  Show Profile  Reply with Quote
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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

jassie
Constraint Violating Yak Guru

312 Posts

Posted - 10/11/2013 :  09:28:04  Show Profile  Reply with Quote
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?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 10/11/2013 :  13:54:11  Show Profile  Reply with Quote
extra reports to follow the main report
what does that mean?
one below other in a page?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

jassie
Constraint Violating Yak Guru

312 Posts

Posted - 10/11/2013 :  21:49:05  Show Profile  Reply with Quote
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.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 10/12/2013 :  05:59:44  Show Profile  Reply with Quote
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 MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

jassie
Constraint Violating Yak Guru

312 Posts

Posted - 10/12/2013 :  11:44:01  Show Profile  Reply with Quote
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.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52325 Posts

Posted - 10/12/2013 :  13:57:28  Show Profile  Reply with Quote
not subreports. I was suggesting to use different rdl files and using jump to report functionality from master to navigate to child

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page

jassie
Constraint Violating Yak Guru

312 Posts

Posted - 10/12/2013 :  23:58:13  Show Profile  Reply with Quote
Thanks!
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000