SSRS - Export a summarized version of report to excel without all details on another sheet

• Copy the existing report tablix, and paste it into the report after the existing tablix.
• You should have two identical tablixes on the same report.
• Right click on the second one and set a page break before, and set the visibility to baseo n an expression.
• enter this as the formula
• [&RenderFormat.IsInteractive]
• This will hide the second tablix as long as the report is interactive, meaning it will not show on screen but it will export to excel
• The page break will cause it to export on a new sheet
• On the second tablix, hide the details row, and it will only export the visible totals