Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Run a different report

Author  Topic 

Ken Blum
Constraint Violating Yak Guru

383 Posts

Posted - 2013-05-27 : 11:57:22
Let's say I have 2 RDL's. One named Report1.rdl and another named Promo.rdl. Based on the results from a query in Report1 I want to automatically run Promo.rdl. How can I do this?

Ken Blum
Constraint Violating Yak Guru

383 Posts

Posted - 2013-05-27 : 13:37:03
For now I just created an Action on a text box that runs the Promo. Wondering if there is a way to automatically run the Action.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-05-27 : 13:48:48
why not include both detail in same report and then conditionaly hide the second part based on first report results? I hope second report is not parameter driven

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

Ken Blum
Constraint Violating Yak Guru

383 Posts

Posted - 2013-05-29 : 08:08:23
The reports are different sizes. I am also considering this methodology to run different reports based on a condition. For instance I may want to run a corporate report for a corporate customer and an independant report for a non-corporate customer.
Go to Top of Page
   

- Advertisement -