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.

 All Forums
 Development Tools
 Reporting Services Development
 Exporting to excel question!

Author  Topic 

Brutoxx
Starting Member

21 Posts

Posted - 2005-04-05 : 11:02:36
I will be exporting my report to excel.
I would like to know if there is a way to rename each excel worksheet with a caption from the report.

Brutoxx
Starting Member

21 Posts

Posted - 2005-04-05 : 11:50:53
anybody?
Go to Top of Page

Brutoxx
Starting Member

21 Posts

Posted - 2005-04-11 : 12:34:53
does anybody know where I can find some info about this? I've searched all over the web... and boss is requesting this feature. :-(

highly appreciated.
Go to Top of Page

jhermiz

3564 Posts

Posted - 2005-04-11 : 13:39:41
This is not possible in the current version of RS. You will have to either pre set this information or manually enter it each time. Also there is a parameters object available to each report. You could somehow include this data in your dataset. Because that data may not have anything to do with the data you are reporting on you will get multiple values per row, which is not ideal but no way around this.


Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]
Imperfection living for perfection --
[url]http://jhermiz.blogspot.com/[/url]
Go to Top of Page
   

- Advertisement -