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
 Development Tools
 Reporting Services Development
 Report Action - go to report

Author  Topic 

iqmcl
Starting Member

8 Posts

Posted - 2010-08-10 : 06:12:26
Hi,

I have a report with two groups, one hidden and can be toggled by the parent.

This works fine, but on one of my columns, I want the user to be able to click on the value, pass some paramters into a second report to get more detail on the value.

If the user has toggled the second group, then I want to pass two params into the second report, the value of the 1st and 2nd group, however if the user is looking at just the top level i.e. they haven't expanded the second level, then i only want to pass one parameter into the second report.

I can see there is an "OMIT" expression when setting up the parameters on the action of the textbox, but not sure how to configure the behaviour I am looking for.

Help!

Cheers

Chris

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-08-10 : 14:52:20
didnt understand why you need to pass second group param even when you're drilling from first level. can you explain?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -