I don't want to export my header

  • I've created a report in SSRS. When viewing on-screen, we want people to see the Page header. However, if they export it to Excel, we don't want the header to export. Any ideas on how I can accomplish this?

  • Add a parameter as HeaderDisplay and add available values with True and False and default value as True.

    Create a rectange to the Page header. Add the header content. On the rectangle Visibility set to use parameter HeaderDisplay in the expression as. (= Not HeaderDisplay)

    When user select the False, the header will not be visible and will not export to excel

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply