I have a main report that shows a bar chart for the sales per country. once I click on a country bar, a drill down report shows a (+/-) list of all countries toggled by the country name, with only the clicked country expanded, while the others are collapsed.
I was asked by the client to add an "Expand All" button to allow them to expand all countries detail at once. However, when I added this button, the first functionality was lost.
In the initialToggleState Expression of the toggle textbox country I used: =iif(Fields!country_ID.Value=Parameters!param_Country_ID.Value OR Parameters!paramExpandOrCollapse.Value = "Expand" ,true, false)
Could I have both functionalities working without one canceling the other?