Hide Specific Items During Report Export in Bold Reports
This guide explains how to hide specific report items, such as tables, charts, or text boxes, during export by using visibility expressions. This approach controls the visibility of report elements based on the rendering format, ensuring that only relevant data and visuals appear in the exported output while enhancing report flexibility.
Steps to Hide Items During Export
1. Select the Item to Hide
Open your report and identify the item, such as a table, chart, or text box, that you want to hide during export.
2. Configure the Visibility Property
Locate the Visibility category in the Properties pane and find the Hidden property.
- Click the square icon next to the Hidden property and select Expression.
- Configure an expression in the
Visibilityproperty to define the export formats in which the item should be hidden.
Use the following expression to hide the report item when exporting to PDF:
=IIf(Globals!RenderFormat.Name = "PDF", True, False)
Replace PDF with the specific export format you want to target, such as Excel or Word.
3. Preview and Export the Report
- Preview the report to ensure all data is visible.
- Export the report and verify that the specified item is hidden in the selected export format(s).
Conclusion
Using visibility expressions based on the render format allows you to hide specific report items during export, ensuring cleaner and more relevant output while maintaining complete details in preview mode.
