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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics