HI I am using ssrs 2008 to generate report,i have taken 2 table in Design Tab(one below other) I am using stored procedure to generate reports and have 2 Parameter one is PRODUCT and other is RANGE IN PRODUCT I CAN SELECT VALUE LIKE RICE,WHEAT,SOAP(i can select multiple product) IN RANGE PERAMETER IS CAN SELECT VALUE IN 1,2,3,4,5(i can select only one range) I have 2 dataset and they give same output ,so that i am using them for 2 tables but problem is, if i select all the product RICE,WHEAT,SOAP and any of the Range 1,2 or 3 then data of all the Product should be seen in 1st table and second table should be invisible But if i select All the 3 product RICE,WHEAT,SOAP and if Range Parameter is 4 or 5 then Rice and wheat Data should be seen in 1st table and Soap data should be seen in 2nd table if i select only soap Product and if range is 3 or 4 then data of Rice should be seen only in 2nd table and 1s table should be invisible What i do to achieve this?? Please Help me

HI Madam Ma But this solve only one case of mine , what in the case if i select Range 4 or 5? because if i select any of the Range (4or 5) then Rice and wheat Data should be seen in 1st table and Soap data should be seen in 2nd table

Can you please post how you defined Rice, Wheat and Soap parameter values? Depends on how you defined them and how your table is organized (is data in table grouped by something?) you'll play with the visibiliy of data.