CODEWITHSUNDEEP
reporting-servicesssrs-2008-r2ssrs-tablix
el ninho
el ninho

Reputation: 4233

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!

Upvotes: 3

Views: 3222

Answers (1)

alejandro zuleta
alejandro zuleta

Reputation: 14108

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.

Upvotes: 6

Related Questions