Hello all, 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 ? Thanks, Iris--

the "iif" statement is calculated at runtime therefore you will need to modify this slightly... Create two report headers one for each (1. Detailed 2. Summary) and use the visibility expression to show based on runtime which will show.