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 |
|
DanielS
Starting Member
32 Posts |
 Posted - 2013-07-09 : 23:11:57
|
| If I have 2 parameters, can I select only 1 of the 2 parameters while the other one defaults to all.eg if I hav P1 and P2, I make a choice from P1 then all P2s are automatically selected, similarly if I make a choice from P2 then all P1s are automatically selected. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-07-10 : 03:16:32
|
| you can. you need to set default value as All for the parameters in parameter property tab.Also in query behind write logic to bypass filtering for parameter when All is selected as the value.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
AAKG GROUP
Starting Member
3 Posts |
Posted - 2013-08-06 : 17:22:43
|
| unspammed |
|
|
|
|
|
|
SSRS parameters