DrillDown Problem in SSRS 2008
Hi, I have prepared one sample drill down report where in, by clicking on the country column's items states will be shown. Ex. +US... when I Click on '+' sign, USA states will be shown and '+US' becomes '-US', without altering anything if I Click on +INDIA it shows states of INDIA and '+INDIA' becomes '-INDIA', at this point i.e when I click on '+INDIA', why '-US' will not automatically become '+US' ?
October 21st, 2010 1:05pm

Hi Avinash, What I understand is that first you click on + sign to expand the states of US and didn't collapse the section before clicking on the + sign with India. Yes, the US section will not collapse automatically until you click on - sign becuase as per my understanding it didn't postback the page just rendered it on client leaving all expanded sections in their current state. Thanks
Free Windows Admin Tool Kit Click here and download it now
October 21st, 2010 1:18pm

Hi Md.Salman, Is there any way to solve this ? If you have then please share it.
October 21st, 2010 3:35pm

Hi Avinash, You can achieve this behaviour by using parameter and expressions in your report. 1. Create a report parameter, e.g. "ExpandSectionValue" 2. Create a link on Country Name group item and call the same report passing the country name (Group item value) as the value of parameter "ExpandSectionValue". Set the other parameter values (if exist) as selected by user. 3. Edit the detailed section of the group and set the visibility expressions as follows =IIF(Parameters!ExpandSectionValue.Value = Fields!GroupName.Value, False, True) This will create a link on country name and only the details for those country will be expanded on which user will click. Pardon me if I wrote something wrong as I don't have SSRS environement right now to test it first. Hope this will help. Thanks
Free Windows Admin Tool Kit Click here and download it now
October 21st, 2010 4:42pm

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

Other recent topics Other recent topics