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 |
|
raaj
Posting Yak Master
129 Posts |
 Posted - 2010-05-27 : 02:30:08
|
| Hi Guys,I am facing a probs when creating Cascading Parameters based on the values....Lets say I am having a parameter1 named Country and it has only two values USA and UK.(in the drop down)Now, what I want is :When the users select the value USA, another parameter2 box should be enabled displaying Generate Report.When the users select the value UK, that another parameter2 box should be disabled.Is this possible in SSRS 2005???Thanks,Raaj. |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-05-27 : 02:34:54
|
The result would be:USA -> Generate ReportUK -> Don't generate ReportSo why do you need that?
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
mrm23
Posting Yak Master
198 Posts |
Posted - 2010-05-27 : 02:40:47
|
| do you means the options once selected must be disabled for the second time? |
|
|
|
raaj
Posting Yak Master
129 Posts |
Posted - 2010-05-27 : 02:52:33
|
| I will be clear this time....When I select the Parameter1 value USA, then Parameter2 box should be enabled displaying Generate report.When I select the Parameter1 value UK, then Parameter2 box shold be disabled.So based on the value in the parameter dropdown box, I want the second parameter to be enabled and disabled. |
|
|
|
|
|
|
Cascading Parameters in SSRS 2005