Passing parameter to a parameter with in same Report- Important and Urget
Hi
I have a ssrs 2005 report with 8 parameters for example prm1,prm2,prm3,prm4,prm5,prm6 all this are normal report parameters now for par7 needs to have the value of prm1, prm2,prm3 and for prm8 the values are prm4, prm5, prm6
how can I get this I mean how can I able to assign one parameter values to another parameter in one report
please ask me questions if you don't understand
thanks
November 14th, 2011 9:32pm
One way I can think this can be achieved is the following
in the parameter value section for parameter par7 in the dataset concatenate the values together
= Parmeters!prm1.Value & ',' & Parmeters!prm2.Value & ',' & Parameters!prm3.Value
Then in your query you can use a split function
WHERE SomeField IN (SELECT * FROM fnSplit(@par7, ','))
You'll find plenty of references to split functions here is one example -
http://www.eggheadcafe.com/community/sql-server/13/10021854/fnsplit.aspx
Josh Ash
Free Windows Admin Tool Kit Click here and download it now
November 14th, 2011 10:48pm