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 |
|
shilpash
Posting Yak Master
103 Posts |
 Posted - 2012-05-08 : 17:21:44
|
| I have a ssrs parameter lets say @q.It takes values 1,2,3,4,5,6.So how do i group into two under drop down list @q.If it takes 1,2,3 named it as '123' in drop down list. and if it takes 4,5,6 named it as '456' n drop down list |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-08 : 19:40:45
|
you can use a case when statement in query behind for getting thisCASE WHEN field in (1,2,3) THEN '123' WHEN field in (4,5,6) THEN '456'...END if you want to make it scalable better to create a mapping table------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
parameters