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-07 : 11:52:50
|
| I have a lists of id but just want to group it as two in ssrs .these are'opt1 15,20,25'and 'opt2 200,201,202,203,204'So if it takes the paramter id 15,20 and 25 then it is grouped in 'opt1 15,20,25'or if it takes parameter id as 200,201,202,203,204 then it is grouped in 'opt2 200,201,202,203,204'Both the grouping should be labeled under OPT(Parameter)Please advise. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-07 : 17:00:53
|
| Why not create a high level mapping table to map ids against descriptions op1,op2 etc? Its scalable as it would enable you to add new ids or renove existing ones as and when you want rather than changing report filter logic each time------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
|
|
ssrs parameter