Hi, I have developed a SSRS report with parent (based on three columns.. col1,col2,col3) and child group(col4,col5), Both group has group total row. I made the child group total visibility based on one condition like if the col3 has some values then it will be visible. Now with this i want to filter the values of child group based on value of col3. Suppose if col3=a then in the child group col4 (it has values like aa,ab,ac,ad) should contains only aa,ab. Remaining values will come in the Parent group. Is it possible or not. If possible how to do this. If possible call me at +91 9880370009 or mail me on sridhar.dpm@gmail.com. Since we have to deliver the report to business tomorrow or day after tomorrow your timely help will be more helpful for me. Urs Sridhar.

Hi Sridhar, Looks like your question is doable. But still I'm not able to understand your req. 100% though. Is it possible to show up an example here? (skydrive) Also please give us more details so that we can help you ASAP on your time line. For your reference you can see my below shared rdl file:- ( Does they guide you towards your question in anyway? ) http://cid-15e0e13bd0545504.office.live.com/self.aspx/.Public/Total%5E_AND%5E_GrandTotal%5E_WithFilter%5E_NEW.rdl http://cid-15e0e13bd0545504.office.live.com/self.aspx/.Public/Total%5E_AND%5E_GrandTotal%5E_Multiple%5E_BenID.rdl Thanks KumarKG, MCTS

Hi Kumar, Thanks for your quick response. R U from India ? I am not able to download the RDL files which you provided in your mail. Can you send me that in my gmail ID mentioned above so that i will check on that. I will send you the RDL file which i have created with a excel sheet for sample data. Urs Sridhar.