Export to Excel: How to rename Excel tabs from Reporting Services

Hello,
When I export a report of 1 page in Excel,
the default name of the tab is the name of my report.
BUT, when I export a report that has much of 1 page, I obtain
"sheet1, sheet2 and sheet3" for the Excel tabs.
It is possible to export my report with specific
names for my Excel tabs?
Did someone else also meet this problem before?
I found nothing about that.
I thought that maybe with subreport it could work, but it does not.
Thank you very muchProviding explicit names for the Excel tabs is not supported in RS 2000.
It is on the wishlist for inclusion in a future release, but we have seen
only limited demand for this feature compared to many other items on the
wishlist.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"So" <So@.discussions.microsoft.com> wrote in message
news:D2179240-6B4E-458C-9337-D0C47A31191B@.microsoft.com...
> Hello,
> When I export a report of 1 page in Excel,
> the default name of the tab is the name of my report.
> BUT, when I export a report that has much of 1 page, I obtain
> "sheet1, sheet2 and sheet3" for the Excel tabs.
>
> It is possible to export my report with specific
> names for my Excel tabs?
> Did someone else also meet this problem before?
> I found nothing about that.
> I thought that maybe with subreport it could work, but it does not.
> Thank you very much|||I have come across this issue as well. If its possible to get this in a
later release it would definitely be a feature that would interest us.
Thank you
"Robert Bruckner [MSFT]" wrote:
> Providing explicit names for the Excel tabs is not supported in RS 2000.
> It is on the wishlist for inclusion in a future release, but we have seen
> only limited demand for this feature compared to many other items on the
> wishlist.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "So" <So@.discussions.microsoft.com> wrote in message
> news:D2179240-6B4E-458C-9337-D0C47A31191B@.microsoft.com...
> > Hello,
> >
> > When I export a report of 1 page in Excel,
> > the default name of the tab is the name of my report.
> >
> > BUT, when I export a report that has much of 1 page, I obtain
> > "sheet1, sheet2 and sheet3" for the Excel tabs.
> >
> >
> > It is possible to export my report with specific
> > names for my Excel tabs?
> >
> > Did someone else also meet this problem before?
> >
> > I found nothing about that.
> > I thought that maybe with subreport it could work, but it does not.
> >
> > Thank you very much
>
>|||You can send your comments to:
mswish@.microsoft.com
http://www.microsoft.com/mswish
--
Adrian M.
MCP
"Tony Staley" <TonyStaley@.discussions.microsoft.com> wrote in message
news:00BC937F-5151-4FE2-AB09-27D4BD71C271@.microsoft.com...
>I have come across this issue as well. If its possible to get this in a
> later release it would definitely be a feature that would interest us.
> Thank you
> "Robert Bruckner [MSFT]" wrote:
>> Providing explicit names for the Excel tabs is not supported in RS 2000.
>> It is on the wishlist for inclusion in a future release, but we have seen
>> only limited demand for this feature compared to many other items on the
>> wishlist.
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>> "So" <So@.discussions.microsoft.com> wrote in message
>> news:D2179240-6B4E-458C-9337-D0C47A31191B@.microsoft.com...
>> > Hello,
>> >
>> > When I export a report of 1 page in Excel,
>> > the default name of the tab is the name of my report.
>> >
>> > BUT, when I export a report that has much of 1 page, I obtain
>> > "sheet1, sheet2 and sheet3" for the Excel tabs.
>> >
>> >
>> > It is possible to export my report with specific
>> > names for my Excel tabs?
>> >
>> > Did someone else also meet this problem before?
>> >
>> > I found nothing about that.
>> > I thought that maybe with subreport it could work, but it does not.
>> >
>> > Thank you very much
>>|||Has this issue been resolved with 2005?
Thanks and have a nice weekend,
Ryan
"Adrian M." wrote:
> You can send your comments to:
> mswish@.microsoft.com
> http://www.microsoft.com/mswish
> --
> Adrian M.
> MCP
>
> "Tony Staley" <TonyStaley@.discussions.microsoft.com> wrote in message
> news:00BC937F-5151-4FE2-AB09-27D4BD71C271@.microsoft.com...
> >I have come across this issue as well. If its possible to get this in a
> > later release it would definitely be a feature that would interest us.
> >
> > Thank you
> >
> > "Robert Bruckner [MSFT]" wrote:
> >
> >> Providing explicit names for the Excel tabs is not supported in RS 2000.
> >> It is on the wishlist for inclusion in a future release, but we have seen
> >> only limited demand for this feature compared to many other items on the
> >> wishlist.
> >>
> >> --
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >> "So" <So@.discussions.microsoft.com> wrote in message
> >> news:D2179240-6B4E-458C-9337-D0C47A31191B@.microsoft.com...
> >> > Hello,
> >> >
> >> > When I export a report of 1 page in Excel,
> >> > the default name of the tab is the name of my report.
> >> >
> >> > BUT, when I export a report that has much of 1 page, I obtain
> >> > "sheet1, sheet2 and sheet3" for the Excel tabs.
> >> >
> >> >
> >> > It is possible to export my report with specific
> >> > names for my Excel tabs?
> >> >
> >> > Did someone else also meet this problem before?
> >> >
> >> > I found nothing about that.
> >> > I thought that maybe with subreport it could work, but it does not.
> >> >
> >> > Thank you very much
> >>
> >>
> >>
>
>|||I've been looking for some evidence that naming Excel tabs has been resolved
in SQL 2005, but haven't found it. In our company, wide use of reporting
services is dependent almost solely on the ability to replace creating Excel
reports manually or with our own proprietary tools (which are otherwise far
less flexible than SSRS). Having many tabs with meaningful names is central
to that question (arguably each tab today could be its own report, but that's
far less convenient for the user--I don't think our major customers would
accept it). I know it can seem like the way you do things is the way
everyone does it, but I'm honestly surprised this isn't a critical missing
feature for a lot of others like it is for us.
Regards,
Jason R
"Ryan" wrote:
> Has this issue been resolved with 2005?
> Thanks and have a nice weekend,
> Ryan
> "Adrian M." wrote:
> > You can send your comments to:
> > mswish@.microsoft.com
> > http://www.microsoft.com/mswish
> >
> > --
> > Adrian M.
> > MCP
> >
> >
> > "Tony Staley" <TonyStaley@.discussions.microsoft.com> wrote in message
> > news:00BC937F-5151-4FE2-AB09-27D4BD71C271@.microsoft.com...
> > >I have come across this issue as well. If its possible to get this in a
> > > later release it would definitely be a feature that would interest us.
> > >
> > > Thank you
> > >
> > > "Robert Bruckner [MSFT]" wrote:
> > >
> > >> Providing explicit names for the Excel tabs is not supported in RS 2000.
> > >> It is on the wishlist for inclusion in a future release, but we have seen
> > >> only limited demand for this feature compared to many other items on the
> > >> wishlist.
> > >>
> > >> --
> > >> This posting is provided "AS IS" with no warranties, and confers no
> > >> rights.
> > >>
> > >> "So" <So@.discussions.microsoft.com> wrote in message
> > >> news:D2179240-6B4E-458C-9337-D0C47A31191B@.microsoft.com...
> > >> > Hello,
> > >> >
> > >> > When I export a report of 1 page in Excel,
> > >> > the default name of the tab is the name of my report.
> > >> >
> > >> > BUT, when I export a report that has much of 1 page, I obtain
> > >> > "sheet1, sheet2 and sheet3" for the Excel tabs.
> > >> >
> > >> >
> > >> > It is possible to export my report with specific
> > >> > names for my Excel tabs?
> > >> >
> > >> > Did someone else also meet this problem before?
> > >> >
> > >> > I found nothing about that.
> > >> > I thought that maybe with subreport it could work, but it does not.
> > >> >
> > >> > Thank you very much
> > >>
> > >>
> > >>
> >
> >
> >|||I need a work around for this. I solved this by building a MACRO to solve the
problem back in 1996 but it required that EXCEL be installed on the server,
opening the file invoking the macro automatically and then saving the file.
There should be a way to call a method say "nameWksTab" and pass it into the
file, say a CSV.
This should do-able using some of XLS tools or VB to manipulate this.
Of course the SSRS should do this easily if it expects to stay competitive
in the ever expanding BI world.
"Jason R" wrote:
> I've been looking for some evidence that naming Excel tabs has been resolved
> in SQL 2005, but haven't found it. In our company, wide use of reporting
> services is dependent almost solely on the ability to replace creating Excel
> reports manually or with our own proprietary tools (which are otherwise far
> less flexible than SSRS). Having many tabs with meaningful names is central
> to that question (arguably each tab today could be its own report, but that's
> far less convenient for the user--I don't think our major customers would
> accept it). I know it can seem like the way you do things is the way
> everyone does it, but I'm honestly surprised this isn't a critical missing
> feature for a lot of others like it is for us.
> Regards,
> Jason R
> "Ryan" wrote:
> > Has this issue been resolved with 2005?
> >
> > Thanks and have a nice weekend,
> > Ryan
> >
> > "Adrian M." wrote:
> >
> > > You can send your comments to:
> > > mswish@.microsoft.com
> > > http://www.microsoft.com/mswish
> > >
> > > --
> > > Adrian M.
> > > MCP
> > >
> > >
> > > "Tony Staley" <TonyStaley@.discussions.microsoft.com> wrote in message
> > > news:00BC937F-5151-4FE2-AB09-27D4BD71C271@.microsoft.com...
> > > >I have come across this issue as well. If its possible to get this in a
> > > > later release it would definitely be a feature that would interest us.
> > > >
> > > > Thank you
> > > >
> > > > "Robert Bruckner [MSFT]" wrote:
> > > >
> > > >> Providing explicit names for the Excel tabs is not supported in RS 2000.
> > > >> It is on the wishlist for inclusion in a future release, but we have seen
> > > >> only limited demand for this feature compared to many other items on the
> > > >> wishlist.
> > > >>
> > > >> --
> > > >> This posting is provided "AS IS" with no warranties, and confers no
> > > >> rights.
> > > >>
> > > >> "So" <So@.discussions.microsoft.com> wrote in message
> > > >> news:D2179240-6B4E-458C-9337-D0C47A31191B@.microsoft.com...
> > > >> > Hello,
> > > >> >
> > > >> > When I export a report of 1 page in Excel,
> > > >> > the default name of the tab is the name of my report.
> > > >> >
> > > >> > BUT, when I export a report that has much of 1 page, I obtain
> > > >> > "sheet1, sheet2 and sheet3" for the Excel tabs.
> > > >> >
> > > >> >
> > > >> > It is possible to export my report with specific
> > > >> > names for my Excel tabs?
> > > >> >
> > > >> > Did someone else also meet this problem before?
> > > >> >
> > > >> > I found nothing about that.
> > > >> > I thought that maybe with subreport it could work, but it does not.
> > > >> >
> > > >> > Thank you very much
> > > >>
> > > >>
> > > >>
> > >
> > >
> > >|||Hi,
can you help me how to write a marco in SSRS for the tabing names in excel?
so i can try on my report as i am having a similar issue.
Thanks in advance.
Regards
Vandana Mestri
vandana.mestri@.rave-tech.com
"Jim R" wrote:
> I need a work around for this. I solved this by building a MACRO to solve the
> problem back in 1996 but it required that EXCEL be installed on the server,
> opening the file invoking the macro automatically and then saving the file.
> There should be a way to call a method say "nameWksTab" and pass it into the
> file, say a CSV.
> This should do-able using some of XLS tools or VB to manipulate this.
> Of course the SSRS should do this easily if it expects to stay competitive
> in the ever expanding BI world.
>
> "Jason R" wrote:
> > I've been looking for some evidence that naming Excel tabs has been resolved
> > in SQL 2005, but haven't found it. In our company, wide use of reporting
> > services is dependent almost solely on the ability to replace creating Excel
> > reports manually or with our own proprietary tools (which are otherwise far
> > less flexible than SSRS). Having many tabs with meaningful names is central
> > to that question (arguably each tab today could be its own report, but that's
> > far less convenient for the user--I don't think our major customers would
> > accept it). I know it can seem like the way you do things is the way
> > everyone does it, but I'm honestly surprised this isn't a critical missing
> > feature for a lot of others like it is for us.
> >
> > Regards,
> > Jason R
> >
> > "Ryan" wrote:
> >
> > > Has this issue been resolved with 2005?
> > >
> > > Thanks and have a nice weekend,
> > > Ryan
> > >
> > > "Adrian M." wrote:
> > >
> > > > You can send your comments to:
> > > > mswish@.microsoft.com
> > > > http://www.microsoft.com/mswish
> > > >
> > > > --
> > > > Adrian M.
> > > > MCP
> > > >
> > > >
> > > > "Tony Staley" <TonyStaley@.discussions.microsoft.com> wrote in message
> > > > news:00BC937F-5151-4FE2-AB09-27D4BD71C271@.microsoft.com...
> > > > >I have come across this issue as well. If its possible to get this in a
> > > > > later release it would definitely be a feature that would interest us.
> > > > >
> > > > > Thank you
> > > > >
> > > > > "Robert Bruckner [MSFT]" wrote:
> > > > >
> > > > >> Providing explicit names for the Excel tabs is not supported in RS 2000.
> > > > >> It is on the wishlist for inclusion in a future release, but we have seen
> > > > >> only limited demand for this feature compared to many other items on the
> > > > >> wishlist.
> > > > >>
> > > > >> --
> > > > >> This posting is provided "AS IS" with no warranties, and confers no
> > > > >> rights.
> > > > >>
> > > > >> "So" <So@.discussions.microsoft.com> wrote in message
> > > > >> news:D2179240-6B4E-458C-9337-D0C47A31191B@.microsoft.com...
> > > > >> > Hello,
> > > > >> >
> > > > >> > When I export a report of 1 page in Excel,
> > > > >> > the default name of the tab is the name of my report.
> > > > >> >
> > > > >> > BUT, when I export a report that has much of 1 page, I obtain
> > > > >> > "sheet1, sheet2 and sheet3" for the Excel tabs.
> > > > >> >
> > > > >> >
> > > > >> > It is possible to export my report with specific
> > > > >> > names for my Excel tabs?
> > > > >> >
> > > > >> > Did someone else also meet this problem before?
> > > > >> >
> > > > >> > I found nothing about that.
> > > > >> > I thought that maybe with subreport it could work, but it does not.
> > > > >> >
> > > > >> > Thank you very much
> > > > >>
> > > > >>
> > > > >>
> > > >
> > > >
> > > >