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