Supress report header when exporting to excel

Hello all,

I am developing a report but I wanted to have an option to either SUPRESS the REPORT HEADER or not when I export it to Excel format. How do I achieve that?

Thank you all

Check out this blog: http://blog.hoegaerden.be/2011/01/18/ssrs-hideshow-items-dependant-on-export-format/

1 Like

Thanks Jeff but how do I place the expression if I want to supress my Page Header?

What happens if you set the property for all text boxes in the page header so they don't show when exporting to Excel?