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 |
|
andros30
Yak Posting Veteran
80 Posts |
 Posted - 2010-09-13 : 13:30:45
|
| I'm not sure if this is possible but here we go:I have a report that returns the following fields:Entity, Month, Year, OfficeCode, Revenue, CollectionI am grouping on the month. The only thing that I'm displaying in my details are: Entity, OfficeCode, Revenue, CollectionMy question is, how can I export the report in a way that the Revenue will be on one sheet and the Collection be on another sheet but repeat the other two columns(Entity,OfficeCode). |
|
|
IceCreamWizard
Starting Member
11 Posts |
Posted - 2010-09-14 : 10:11:31
|
| Once you're happy with the table, copy and paste the entire table into your report below the original table.In the original, remove the Collection column. In the copy, remove the Revenue column.In the properties of the original table, make sure the the checkbox for starting a new page after this table is checked. That should generate a new tab in Excel for the second table. |
 |
|
|
andros30
Yak Posting Veteran
80 Posts |
Posted - 2010-09-14 : 17:34:10
|
You are soooo awesome... It works... Learn something new now haha. Thanks. |
|
|
|
|
|
|
|
|
Export to Excel by Sheet option