I have a report with few grouping levels. by default few of the group levels are visible, while for a detailed report either specific group need to be collapsed, or detailed report option to be chosen.
Since in the group summary line I have few statistics, I want the report column header/names to be changed dynamically. I have used expression in header so it will change dynamically when a user wish to see the detailed or summary report using:
=IIf(Parameters!P_Detailed_Report.Value="Y","Detailed column header ","Summary column Header")
But the above won't work off course when the user actively collapses a group.
Can I have the header text to change when a certain group is collapsed by user ?
View Complete Post