SSRS export tablixes to different Excel sheets

Question

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

How to achieve this?

Thanks!

Answer 1

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.

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.