I apologize if this has been asked before, but I was unable to locate a prior post related to this. I have 2 ssrs reports already created that the client likes to receive in ms excel format, however they now want both of these reports merged into a single ms excel file, split into 2 tabs. Is there any way to do this in ssrs? Thanks.

Hi, You can merge two reports into one report. Then you can add page break between two tablix/tables. For that you need to just add page break after first tablix or before second tablix. This will automatically export report int saperate tabs when you export to excel. - Chintak (My Blog)