Wednesday, November 12, 2014

SSRS Report Builder - Remove Element from Report Export



To render an element on a report but not print the element in the export file, place the code below in the element's "Visibility" Hidden property.

=NOT(Globals!RenderFormat.IsInteractive)



Use the code below to exclude from specific export files. 

=IIF(Globals!RenderFormat.Name = "EXCEL", True, False)
 This table represents the Render Format Name to use in the expression. 

RendererRenderFormat.NameRenderFormat.IsInteractive
Preview in BIDS or rendered through Report ManagerRPLTrue
XML file with report dataXMLFalse
CSV (comma delimited)CSVFalse
TIFF file or Print buttonIMAGEFalse
PDFPDFFalse
MHTML (web archive)MHTMLTrue
ExcelEXCELFalse
WordWORDFalse

No comments:

Post a Comment