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

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