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.
| Author |
Topic |
|
ZMike
Posting Yak Master
110 Posts |
 Posted - 2012-03-30 : 11:07:17
|
| I have the following scenario.I have a drill down report that I use the "Jump to Report" based on State. So when the main report comes up it has 5 states. When they click on one of the states it brings up all the info based on that 1 state.However I made a go back button, that when going back to the summary report I want to pass all 5 states back in. I have only been successful making the one that they're in pass back over to the main reportAny suggestions would be great. I've tried = SPLIT(Parameters!State.Value,",")= Parameters!State.Value= Parameters!SiteID.IsMultiValue (0)= "WI" OR "IL" OR "IN" OR "MN" OR "IA" |
|
|
ZMike
Posting Yak Master
110 Posts |
Posted - 2012-03-30 : 11:42:23
|
| I figured it out. I just made a parameter called HiddenState and defaulted it to a query string of everything I needed that doesnt attach itself to any of the other data pulls. And I hid the parameter so the users don't see it and it works great. |
 |
|
|
|
|
|
Going from Single Value to passing Multi