Export to Excel - Naming of Sheets
in [Reports]
|
Prev: How do Install and configure SQL Reporting Services 2008 when SSRS2005is present
Next: Keep Together on Subreports
From: Sean L on 19 Oct 2009 04:14 Hi, Using SSRS 2008, with the VisualStudio Report Writer I have a report which exports fine to excel. There are a number of page breaks which then get outputted to new sheets in the workbook. This is exactly what i wanted to happen. Only problem is that the sheets don't have names (except for the standard sheet1, sheet2, etc. Is there a way to have the sheet name inserted from the export function? Thanx Sean
From: Uri Dimant on 19 Oct 2009 04:53 Hi You might want to review the following related threads: * http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1713177&SiteID=1 * http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=309746&SiteID=1 "Sean L" <seanl(a)centriq.co.za> wrote in message news:FBCC5F89-3841-4EB7-99FA-64BC624C642F(a)microsoft.com... > Hi, > Using SSRS 2008, with the VisualStudio Report Writer > I have a report which exports fine to excel. There are a number of page > breaks which then get outputted to new sheets in the workbook. This is > exactly what i wanted to happen. Only problem is that the sheets don't > have names (except for the standard sheet1, sheet2, etc. Is there a way to > have the sheet name inserted from the export function? > > Thanx > Sean
From: Dave Yoda on 19 Oct 2009 06:19 Hi Sean, I haven't tried it myself (so far), but you might want to check out this: http://spacefold.com/lisa/post/Changing-the-Sheet-names-in-SQL-Server-RS-Excel-QnD-XSLT.aspx Cheers, Dave "Sean L" <seanl(a)centriq.co.za> schrieb im Newsbeitrag news:FBCC5F89-3841-4EB7-99FA-64BC624C642F(a)microsoft.com... > Hi, > Using SSRS 2008, with the VisualStudio Report Writer > I have a report which exports fine to excel. There are a number of page > breaks which then get outputted to new sheets in the workbook. This is > exactly what i wanted to happen. Only problem is that the sheets don't > have names (except for the standard sheet1, sheet2, etc. Is there a way to > have the sheet name inserted from the export function? > > Thanx > Sean
From: Sean L on 19 Oct 2009 07:45
thanx "Uri Dimant" <urid(a)iscar.co.il> wrote in message news:OatmQnJUKHA.4364(a)TK2MSFTNGP04.phx.gbl... > Hi > You might want to review the following related threads: > > * http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1713177&SiteID=1 > > * http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=309746&SiteID=1 > > > > > > > > "Sean L" <seanl(a)centriq.co.za> wrote in message > news:FBCC5F89-3841-4EB7-99FA-64BC624C642F(a)microsoft.com... >> Hi, >> Using SSRS 2008, with the VisualStudio Report Writer >> I have a report which exports fine to excel. There are a number of page >> breaks which then get outputted to new sheets in the workbook. This is >> exactly what i wanted to happen. Only problem is that the sheets don't >> have names (except for the standard sheet1, sheet2, etc. Is there a way >> to have the sheet name inserted from the export function? >> >> Thanx >> Sean > > > |