SQLTeam.com | Weblogs | Forums

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/


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?