Has anyone ever tried to control the toggle state of recursive items independently, to provide drilldown capabilities for this type of data structure? Can one elect to expand or collapse individual levels based on a data-driven element, such as a boolean "Expanded" field passed in the data? I attempted this without any luck. I also tried using level comparisons within the scope of the group but since there is only one group visibility setting, if you want to collapse a level you unfortunately have to make it invisible (which means you'll never have an opportunity to expand it) so that doesn't work. Possibly what I am attempting isn't supported. I am trying to add drilldown capabilities into a recursive detail group such that I gain the ability to perform both recursive aggregations along with the ability to set the toggle states of each level independently. Note that according to my tests, using a recursive group and toggling/drilldown only appears to work if all items are expanded upon initial report execution. The user may then collapse levels and the toggle state and report behavior work properly however this is not the desired initial state we're looking for. Thank you for your time! AS

Hi There Please have a look on this example as I have craeted a multivalued parameter and based on that I am expanding and collapsing the group Please see the attached picture Please do the following Please right clikc on the group whose visibilty you would like to be toggle and put expression like this =IIF(instr(join(Parameters!Country.Value,","),Fields!Country.Value)>0, False, True) =IIF(instr(join(Parameters!Country.Value,","),Fields!Country.Value)>0, False, True) And display can be toggle by the textbox which you would like Now go to your textbox and go to the property initialtogglestate and put expression like this =IIF(instr(join(Parameters!Country.Value,","),Fields!Country.Value)>0, True,false) =IIF(instr(join(Parameters!Country.Value,","),Fields!Country.Value)>0, True,false) I hope this will helps Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

Hi Syed, Thank you for your response. I'm trying to employ a recursive parent group in addition to drilldown controls for the same group, so unfortunately this does not meet that criteria. I hope I've explained it properly. Thanks, Anthony Siciliano AS