I need a work around for this. I solved this by building a MACRO to solve the
opening the file invoking the macro automatically and then saving the file.
"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
> > > >>
> > > >>
> > > >>
> > >
> > >