I don't want to export my header

• clawrence-989946

  SSC Rookie

  Points: 30

  More actions

  April 9, 2009 at 1:22 pm

  #202909

  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?

• Shivanand Kamath

  SSC-Addicted

  Points: 450

  More actions

  April 9, 2009 at 1:43 pm

  #975397

  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