Hi, I have an problem. I have an SSRS report having multiple grouped sections that renders as collapsed sections. User can expands those sections. User requires the functionality that they can expand specific sections and save those sections in their favorite. When user opens the the report again the sections they expanded should be rendered as expanded. The section has assiciated toggleID based on which the expansion is done by SSRS. mY problem is if user expands three sections out of 10 sections how do i expand only those specific sections. I saved the expanded toggleIDs in database but when i try to send the expanded IDs to SSRS for expansion of report they don't work. It works fine for single section, problem is for multiple section. I have already tried below mentioned three scenarios. 1. Sending comma separated section IDs e.g Parameter Name Values ToggleID 1,2,3 2. Sending Multiple Toggle IDs Parameter Name Values ToggleId 1 ToggleId 2 ToggleId 3 3. Sending The ParameterName and Collection of Values (List<Values>) Parameter Name Values ToggleID 1 2 3. None of the above scenarios are working. Any help is greately appreciated.

Hi There You will be able to do this I think what I did for your example 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 There You will be able to do this I think what I did for your example 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, Thanks for taking out time to help me with this problem. I will try implementing this approach and will keep update you with results.

Hi There Thanks for your posting and good luck, I hope it will resolve your problem Many thanks SYed

Thanks!! as per your solution, you are using a parameter to show groups expanded. However when user expands on particular Country, we need to save that country in that parameter. Any idea how we can do that? Please note that in this case SSRS report is integrated with Sharepoint, hence user expands group on sharepoint site and then saves the report. So in sharepoint site SSRS is redered as normal HTML, hence we do not get any State id which we can store unless there is way which I am not aware. Let me know in case you have any idea on this

Hi There Thanks for your posting. The only way I can think of is please use a hidden parameter for your User!UserID and give your user a multivalued parameter which give them an option to select expand and collapse based on their desire. Create a table inside your database which will hold the state of your expand items So for example your table might look like this USerID Expanded items Yourdomain\UserA Gaming Revenue Yourdomain\UserA Movie Revenue Yourdomain\UserB Movie Revenue When the user next time run the report you will select these items inside your parameter and expand those items which has been selected last time in the parameter, if user say change his setting you can override his values inside your table. I hope this will help Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful

Thanks for your time on this...As per your solution you are asking to drive the expand collapse from parameter. If i understand correctly, user will select parameter and accordingly nodes can be expanded. However our current report is not driven that way. User will expand collapse any node using +/-. Whichever are expanded by user needs to be stored back in Parameter and saved to database. Now when we do grouping we do not have any action or event handler by which we can pass that node which user expanded to the paramater to save in database. Do you have any idea to do this?