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