SQL Server Forums

Home | Weblogs | Forums | SQL Server Links

Active Forum Topics | Popular Articles | All Articles by Tag | SQL Server Books | About

SQL Server Forums

Register Now and get your question answered!

Username:	Password:
Save Password
Forgot your Password?

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

Help

New Topic

Reply to Topic

Printer Friendly

Author

Topic

sqlfresher2k7
Aged Yak Warrior

583 Posts

Posted - 05/29/2012 : 14:57:10

When i export a MS Excel file generated By SSRS 2008... i'm not able to change the sheet name (Sheet 1,Sheet 2,Sheet 3) dynamically.

Please help..

Note:we have sqlserver 2008 not 2008 R2.

visakh16
Very Important crosS Applying yaK Herder

India
47031 Posts

Posted - 05/29/2012 : 15:05:50

you cant change it till ssrs 2008 r2. The only workaround till then is to try adding a document map.

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

sqlfresher2k7
Aged Yak Warrior

583 Posts

Posted - 05/29/2012 : 15:07:31

Thanks visakh..

Can you please elaborate about the document map workaround solution.

visakh16
Very Important crosS Applying yaK Herder

India
47031 Posts

Posted - 05/29/2012 : 15:33:52

see an example

http://beyondrelational.com/modules/2/blogs/65/posts/11571/how-to-add-a-document-map-to-your-reports.aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

sqlfresher2k7
Aged Yak Warrior

583 Posts

Posted - 05/29/2012 : 16:42:40

Thanks Visakh

visakh16
Very Important crosS Applying yaK Herder

India
47031 Posts

Posted - 05/29/2012 : 21:16:06

wc

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Topic

New Topic

Reply to Topic

Printer Friendly

Jump To:

SQL Server Forums

This page was generated in 0.03 seconds.