Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SSRS export tablixes to different Excel sheets

I have 2 tablixes on one report. I want to export them to different sheets (one tablix one sheet).

How to achieve this?

Thanks!

like image 249
el ninho Avatar asked Sep 02 '25 04:09

el ninho


1 Answers

Try adding a page break between both tables.

Add a rectangle between the tablixes and set the Rectangle property: Add a Page break before or Add a page break after.

UPDATE:

You can set the Name of the page by setting the Rectangle PageName property.

enter image description here

When you export a report to Excel, the report pages that were created by page breaks are exported to different worksheets.

REFERENCE

Let me know if this helps.

like image 180
alejandro zuleta Avatar answered Sep 05 '25 00:09

alejandro zuleta