Supress report header when exporting to excel

Mel · September 28, 2016, 1:41pm

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

jeffw8713 · September 28, 2016, 6:12pm

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

Mel · September 28, 2016, 6:24pm

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

jeffw8713 · September 29, 2016, 5:41pm

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