SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 ssrs parameter		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

shilpash
Yak Posting Veteran

72 Posts
Posted - 05/07/2012 :  11:52:50  Show Profile  Reply with Quote
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

India
47189 Posts
Posted - 05/07/2012 :  17:00:53  Show Profile  Reply with Quote
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 MVP
http://visakhm.blogspot.com/
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000