Excel - Hiding Elements When Exporting

When exporting complete reports to Excel, developers commonly want to hide some of the elements in the report page, like the Export button or link. This can be done very easily using Show Modes.

Consider the example shown above. The definition, on the left, includes an image that can be clicked to export the report to Excel. However, when it's exported, shown on the right, the Excel Export icon appears in the worksheet itself. We don't want that icon to appear in the worksheet.

To "hide" the icon image in the export, simply place it beneath a Division element. This element supports Show Modes, which the Image element does not.

Then set the Division element's Show Modes attribute value to the built-in Show Mode value rdBrowser, as shown above. Elements with this Show Mode value will only be visible in the browser.

When the report is run and exported, as shown above, the document no longer includes the Export Excel icon.