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 |
|
jbphoenix
Yak Posting Veteran
68 Posts |
 Posted - 2009-11-30 : 15:08:06
|
| I have a report that has 4 subreports. 2 of the subreports are 4 pages each because of page breaks and grouping. When I export to excel on the first 5 pages are exported to the 5 tabs. Can I add tabs to the excel workbook? How do I get the rest of the report exported?Thanks |
|
|
jbphoenix
Yak Posting Veteran
68 Posts |
Posted - 2009-11-30 : 15:42:53
|
| Here's what I've found so far - according to http://msdn.microsoft.com/en-us/library/ms159836.aspx "The maximum number of worksheets is not defined in Excel, but external factors, such as memory and disk space, might causes limitations to be applied."I might change the way my reports run and have each subreport print on a page. |
 |
|
|
jbphoenix
Yak Posting Veteran
68 Posts |
Posted - 2009-11-30 : 16:53:22
|
| I changed the way my reports work. Now the sub reports print on a page. But now when I export to excel I only have the document map tab and tab1 and tab2. I want to have each of the subreports be on it's own tab. Anyone know how to make that happen? |
|
|
|
|
|
|
Export to Excel