I have a drill down report that has column headings for group 1 data in the report header. When the user drills down to the details I would like to change the column headings so that they correspond to the details group. I've tried to create to column heading rows and toggle their visibility with the drill down toggle field but get the error message "Toggle items must be text boxes that share the same scope as the hidden item or are in a scope that contains the hidden item, and cannot be contained within the current report item unless current grouping scope has a Parent." Is there any way of doing this? Thanks.http://homepages.woosh.co.nz/bf/

Hi goofaholix, No, the toggle event can't be captured so as to be used in the expression for changing the column header text. You can submit a feedback at https://connect.microsoft.com/SQLServer/Feedback and hope the feature enabled in the next release. thanks, Jerry

What you CAN do (although not quite as neat) is to use a Parameter to create your toggle. create a parameter called LevelOfDetail With 2 available inputs (both hardcoded) as "Summary" & "Detail" Set all your visibility based on something like =IIF(Parameters!LevelOfDetail.Value = "Summary",FALSE,TRUE) remember that the visibility property is actually the "Hidden" property so the TRU/FALSe is probably reversed to what you would expect With hits applied, you do not need 2 sets of headers as you can simply toggle the text: =IIF(Parameters!LevelOfDetail.Value = "Summary","Summary Header","Detail Header") Obviously this has a limitation in that you cannot show / hide detail on a section by section basis - the report is either all detail or all summary but if that is not too much of an issue then this will work quite neatly - I have employed exactly this methodology in the past to show P&L reports at summary or detail level... Rgds Geoff