Export to Excel with multiple worksheets for multiple datasets

Question

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.

Answer 1

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.