I have 2 tablixes on one report. I want to export them to different sheets (one tablix one sheet).
How to achieve this?
Thanks!
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.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With