Want to hide the Telerik.Reporting.Shape in the Exported XLSX file

1 Answer 80 Views
Conditional Formatting Report Viewer - ASP.NET
Shubham
Top achievements
Rank 1
Shubham asked on 06 Nov 2023, 10:55 AM | edited on 06 Nov 2023, 10:56 AM

I'm using 17.0.23.118 version of Telerik report in ASP.net webform. I used Horizontal line(Shape) to separate the rows in DetailArea and PageHeader area.
I want, it should visible in web view but want to hide in exported .xlsx file. Currently its visible in both places.
Please help me out in this.

1 Answer, 1 is accepted

Sort by
0
Momchil
Telerik team
answered on 09 Nov 2023, 08:02 AM

Hi Shubham,

You can implement this behavior by adding a Binding to your shape item and setting its Visible property based on the Name of the RenderingFormat global object.

To make sure you know which formats you are working with, I would suggest adding a text box to the report with the value below and previewing/exporting the report.

= RenderingFormat.Name

For example, the final result may look as follows.

I hope this helps.

Best Regards,
Momchil
Progress Telerik

Stay tuned by visiting our roadmap and feedback portal pages, enjoy a smooth take-off with our Getting Started resources, or visit the free self-paced technical training at https://learn.telerik.com/.
Shubham
Top achievements
Rank 1
commented on 22 Nov 2023, 05:25 AM

Thank you Momchil, This solution work for me.
Telerik 
Tags
Conditional Formatting Report Viewer - ASP.NET
Asked by
Shubham
Top achievements
Rank 1
Answers by
Momchil
Telerik team
Share this question
or