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 |
|
kt677
Starting Member
2 Posts |
 Posted - 2005-10-18 : 17:54:52
|
| I am exporting to Excel from Reporting Services report and it is displaying each group on a different sheet. Is there anyway to rename each sheet during the export?? |
|
|
jhermiz
3564 Posts |
Posted - 2005-10-19 : 08:23:23
|
You will have to create your own code to do this, or a macro inside that excel sheet to do this.When MS or any reporting service allows for exporting they dont allow you to embed code to go outside of the realms of the reporting service engine. Just like crystal, rs, or any other reporting service you cannot do this. You will have to live with the regular exporting optionor write your own assembly.Jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
 |
|
|
kt677
Starting Member
2 Posts |
Posted - 2005-10-19 : 13:12:33
|
| Thanks! I had figured as much. |
|
|
|
|
|
|
Export to Excel