SSRS Report : Show header and footer of report only on export or print option.
Hi, I want to show header and footer of report only on export or print option. Is this possible. If yes, then should I be doing this in BI or web application (ReportViewer). Could you please provide some sample code?
October 7th, 2011 4:24am
Hi, If you are on SSRS 2008 R2, then please follow the instructions in the blog post - http://blogs.msdn.com/b/robertbruckner/archive/2010/05/02/globals-renderformat-aka-renderer-dependent-report-layout.aspx If you are not on 2008 R2, then you are out of luck. However, you can try some work-arounds such as creating a parameter so that the header/footer can be hidden based on the value in the parameter and instructing the user to select the correct value in the parameter before exporting/printing. Hope this helps!
October 9th, 2011 1:45pm