5 Answers, 1 is accepted
You cannot change the layout of a report or conditionally hide sections/items depending on the export format the report is rendered into. The excel export aims for a WYSIWYG representation of the report, and if you need only the report data than you can export to csv, where you can concentrate on the data only as shown in this KB article:Configuring the CSV Rendering Extension.Greetings,
the Telerik team
It is possible to modify the report definition before processing and rendering the report to XLSX. In this scenario you need to create the report object and modify its definition by removing the page header and page footer sections from the report items collection:
Additional information is available in the Programmatic Control of Reports help article.
Do we know if there is an easier way to do this now in the report designer?
Yes, you can do this using conditional formats.
On the page header, create a new Conditional Format.
Set the Filter as follows:
Then the in Style, untick Layout - Visible