CODEWITHSUNDEEP
excelreporting-servicesssrs-2008-r2
user1777929
user1777929

Reputation: 797

Export to Excel with multiple worksheets for multiple datasets

I'm building a report in SSRS with TWO separate Datasets.

  1. One Dataset EXCLUDES some data for a certain date range.
  2. The Second dataset is only for EXCLUDED data for that date range.

I would like to show the EXCLUDED data on a separate worksheet when exported to Excel.

Both datasets have the same fields and need to take the same date range that will be specified in the code and parameters.

I looked up a few suggestions in previous questions here, but that wouldwork for the SAME single dataset. I don't think it would work for two separate datasets.

Upvotes: 0

Views: 720

Answers (1)

MarioS
MarioS

Reputation: 262

You have two separate datasets, so I'm assuming you have two separate tables.

Right-click on the second table, and click "page break" (I'm not sure if it is within "properties" or not, I no longer use SSRS so I can't check).

When you export it, the second table will show up on the a separate tab/worksheet within the file.

Upvotes: 1

Related Questions