I am creating a report with many columns. The main purpose of this report is to be exported to Excel so users can use for further analysis. Is there a way to create a report in SSRS where the web interface/UI of the report has hidden columns that reveal themselves as expandable parts of exisiting visible columns when user exports the report to Excel? Appreciate any and all help!

If you are using SQL Server Reporting Service 2008 R2, you can do this using the RenderFormat global variable. for more info, see this posting http://www.mssqltips.com/tip.asp?tip=2106 I am not sure how this can be done in earlier versions of SSRSCraig Bryden - Please mark correct answers

If you create groupings on columns then you can set initial visibility to not visible You can also set a cell to be able to toggle visibility - in ALL versions of SSRS, if you set this up, it exports to excel as grouped data with the ability to expand / collapseRgds Geoff

Thanks so much Geoff! How do you set up toggle visibility? I am currently going into "advanced mode" on the groupings pane --> columns --> setting toggle visibility to the textbox which i want to expand/collapse. When I try to preview it, I get the following error: "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".

You get that error when you try to apply the toggle item outside of the table that has the fields that are being toggled! Generally, if you have a parent group / child group relationship, you would set the child group's toggle item to be the parent group header - you don;t need to keep the text in the parent group header - can have whatever text in there... Long story short - create a group above the level you want to toggle visibility for. Set that as the togle item and adjust the text in the cell to suitRgds Geoff