Exporting to Excel - renaming tabs

I have created an adhoc report in VS which I then export to Excel. The
way the report is set up is that I have a seperate tab(worksheet) for
each company that features on the report. However, I would like the
company name on each tab instead of the generic sheet1, sheet2 etc..
Any ideas welcome!I don't have an answer to your question, but how do you manage to get more
than one tab on the exported Excel file?
--
Thank you,
Alain Quesnel
alainsansspam@.logiquel.com
www.logiquel.com
"Mark" <markbtmn@.gmail.com> wrote in message
news:2e8aa1cb-4970-43e9-852b-ac9a18551741@.v67g2000hse.googlegroups.com...
>I have created an adhoc report in VS which I then export to Excel. The
> way the report is set up is that I have a seperate tab(worksheet) for
> each company that features on the report. However, I would like the
> company name on each tab instead of the generic sheet1, sheet2 etc..
> Any ideas welcome!|||On Feb 8, 7:28=A0am, "Alain Quesnel" <alainsanss...@.logiquel.com> wrote:
> I don't have an answer to your question, but how do you manage to get more=
> than one tab on the exported Excel file?
> --
> Thank you,
> Alain Quesnel
> alainsanss...@.logiquel.com
> www.logiquel.com
> "Mark" <markb...@.gmail.com> wrote in message
> news:2e8aa1cb-4970-43e9-852b-ac9a18551741@.v67g2000hse.googlegroups.com...
>
> >I have created an adhoc report in VS which I then export to Excel. The
> > way the report is set up is that I have a seperate tab(worksheet) for
> > each company that features on the report. However, I would like the
> > company name on each tab instead of the generic sheet1, sheet2 etc..
> > Any ideas welcome!- Hide quoted text -
> - Show quoted text -
Mark,
Out of the box, RS does not have the functionality to rename the
tabs. Folks in my company end up doing some hefty gymnastics
with .NET and/or macros. This link claims to offer a solution but
I've not been able to get it to work. Let us know if you have better
results than me.
http://www.spacefold.com/lisa/post/Changing-the-Sheet-names-in-SQL-Server-RS=
-Excel-QnD-XSLT.aspx
Alain,
To get separate tabs by group, check the Page break at end check box
on the edit group dialog.
HTH you both|||On Feb 8, 6:14=A0pm, toolman <t...@.infocision.com> wrote:
> On Feb 8, 7:28=A0am, "Alain Quesnel" <alainsanss...@.logiquel.com> wrote:
>
>
> > I don't have an answer to your question, but how do you manage to get mo=re
> > than one tab on the exported Excel file?
> > --
> > Thank you,
> > Alain Quesnel
> > alainsanss...@.logiquel.com
> >www.logiquel.com
> > "Mark" <markb...@.gmail.com> wrote in message
> >news:2e8aa1cb-4970-43e9-852b-ac9a18551741@.v67g2000hse.googlegroups.com...=
> > >I have created an adhoc report in VS which I then export to Excel. The
> > > way the report is set up is that I have a seperate tab(worksheet) for
> > > each company that features on the report. However, I would like the
> > > company name on each tab instead of the generic sheet1, sheet2 etc..
> > > Any ideas welcome!- Hide quoted text -
> > - Show quoted text -
> Mark,
> Out of the box, RS does not have the functionality to rename the
> tabs. =A0Folks in my company end up doing some hefty gymnastics
> with .NET and/or macros. =A0This link claims to offer a solution but
> I've not been able to get it to work. =A0Let us know if you have better
> results than me.http://www.spacefold.com/lisa/post/Changing-the-Sheet-name=
s-in-SQL-Se...
> Alain,
> To get separate tabs by group, check the Page break at end check box
> on the edit group dialog.
> HTH you both- Hide quoted text -
> - Show quoted text -
Hey toolman,
Apologies in the slow response to your posting. Gave the link a try
but after spending some time on it I still couldn't get it to work.
Seems very long winded just to get some tab names working. We use
another BI reporting tool called Microstrategy which makes it simple
to do this as all you have to do is create a template with named tabs
and link it to your report - simple! Microsoft should take a leaf out
of these guys book! Doesn't help me but maybe i'll find something else
on the net.
Cheers