Microsoft Reporting Services: hide footer depending on export format? -


I am using Microsoft Reporting Services (MSRS) 2008. Currently, I am preparing reports that can be provided as PDFs and both. Excel, which normally works fine.

If I define a footer in the designer, then I see it in pdf and do not see it on excel sheet. However, when I print excel file, then the footer happens again (even in the page preview).

What to hide MSRS / as the output format? I have to put it in PDF and I do not want it in Excel. Preparing two reports will be a way to achieve this, but one of the most inconvenient.

SQL Server 208 R2 You can get this behavior by using the RenderFormat Global Variable I do not think That it is possible in earlier versions.


Comments