Hello Techie, 

I have two different dataset in one Report,

Each Dataset result is binded to a different Table component

When I export as Excel ,I am getting all this in One Excel sheet

I need this in separate excel, as dataset1 in excel1 and dataset2 in excel2

May any one Please help me how to acheive this.

Thanks

Maybe this link could help http://www.macaalay.com/2014/03/13/generate-multiple-worksheets-by-groups-in-ssrs-exported-excel-spreadsheets/

Hi Pras05,

According to your description, you have created two tablixes in your report, each tablix returns data from different datasets. When exporting to Excel, you want to display each tablix in different sheets, right?

In your scenario, since you want to separate those two tablixes in different sheets, you should add a page break between those two tablixes. So in your scenario, you could select "Add a page break after" option in tablix1 properties, or select "Add a page break before" option in tablix2 properties.

If you have any question, please feel free to ask. 

Best regards,
Qiuyun Yu