Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
oron
Starting Member
2 Posts |
 Posted - 2008-06-30 : 08:39:10
|
| Hi,I have in my application about 10 reports that I should export to Excel using the ReportViewer programatically.My application now can export these reports to 10 different files, but what I need is to export these reports to one excel file with different worksheet for each report.Is there a way to do it with the Render method or other ReportViewer method?Thanks,Oron |
|
|
antonio.collins
Starting Member
2 Posts |
Posted - 2008-06-30 : 19:03:38
|
| multiple table and/or matrix report items are rendered as seperate excel tabs so just put the 10 tables/matrices in the report body. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-03 : 04:47:25
|
| Try making a report which includes all 10 reports as subreports and exporting to excel. I'm not sure how excel will render the subreports but worth making a try. |
|
|
|
oron
Starting Member
2 Posts |
Posted - 2008-07-14 : 08:57:53
|
| Thanks for the reply.I've tried the sub reports option and it worked fine, although I had to put each sub report in rectangle and set the rectangle PageBrakeAtEnd to true which is a must to get sub report to a separete worksheet. |
|
|
|
|
|
|
Render report to existing Excel file