Link to home
Start Free TrialLog in
Avatar of prashant04
prashant04Flag for India

asked on

How do I get the report from multiple RDLs to single Excel file

I want multipe RDL data of SSRS report in single excel,
Before I use to extract the RDL data to single excel and than merge all excel to one. but I need some solution to get the diferent RDL data into one.
Avatar of Howard Cantrell
Howard Cantrell
Flag of United States of America image

If you are using stored procedures then all you have to do is add all the datasets to one report and it will print all of the data on one report.
You may be able to compose the individual reports by creating an additional RDL file containing subreports for each of the original reports, one after the other. You would then render this new report as Excel. I haven't tried this recently, and I don't know if there are quality issues or length limitations, particularly when the Excel renderer is used. I do seem to remember having done this successfully some time in the past (rendering to HTML, not to Excel).
Avatar of prashant04

ASKER

Hi,
Thanks for your responds, and I have understood the logic, but I need to create RDL which will generate the report in multiple excel sheet in same workbook, please find attached attached copy of screen shot.
Snapshot.JPG
ASKER CERTIFIED SOLUTION
Avatar of Megan Brooks
Megan Brooks
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial