Re: Reporting Services and Excel

From: nupee (nupee_at_discussions.microsoft.com)
Date: 08/13/04 

Date: Fri, 13 Aug 2004 13:01:01 -0700

Once again Keith, your advised has helped me tremendously, Thanks!!..In terms
of the name of the file, I noticed that you can specify a filename if you are
saving the report to a fileshare directory but you cannot specify a filename
if you are sending the report via the report server email delivery in report
manager. Is there a way around that?? My report will be emailed to several
customers and I would like to specify different filenames for each
customer/report based on inidividual subscriptions for each customer.

"Keith Kratochvil" wrote:

> Unfortunately it is not possible to controle the naming of the tabs. It is
> possible to create a document map (the first worksheeet contains named links
> to each tab). This is the only option for now. I had a disucssion with an
> individual from Microsoft on this issue and I believe they are looking into
> it. There is no official timeline for the enhancement. There is no
> guarantee that they will put it in, but I am hoping that it will make it
> into the product eventually.
>
> Regarding the name of the file, yes you can specify the name of the file and
> the path when setting up the subscription.
>
> --
> Keith
>
>
> "nupee" <nupee@discussions.microsoft.com> wrote in message
> news:31E014F7-F155-433F-AEE3-A38C5C817A0E@microsoft.com...
> > Thank You Keith. Your suggestions worked perfectly after several hours of
> > tweeking. I'm hoping you can help me customize it even further. Since each
> > subreport is a Tab or *** in Excel, I need to pass the name of the
> > subreport to Excel so that the tabs or subreport assume the subreport
> name.
> > Currently each tab is named the default (Sheet1, Sheet2, etc.). Is this
> > possible? Also, once the report is deployed, I would like to set up a
> > subscription. Can you assign a certain filename that you want the
> > subscription to save the file as or does it assign it the name of the
> > project?? Thanks!!
> >
> > "Keith Kratochvil" wrote:
> >
> > > I did something similar with one of our reports. I created each
> individual
> > > report. I then created one report with the subreports. I put each
> > > subreport within a rectangle and I gave each subreport a different name
> > > (right-click on the subreport | properties | general tab | name). I
> have
> > > page breaks after each rectangle, and each subreport shows up on a
> different
> > > tab.
> > >
> > > --
> > > Keith
> > >
> > >
> > > "nupee" <nupee@discussions.microsoft.com> wrote in message
> > > news:49D866DD-D778-458B-BE8B-FF5268B96280@microsoft.com...
> > > > Can someone please help me. My first posting for this question went
> > > > unanswered. Here goes...I'm trying to create a report in reporting
> > > services.
> > > > The end result will be a subscription that creates an Excel file with
> > > > contains multiple sheets (Tabs). Each sheet should corresponds to a
> > > different
> > > > query or subreport. All the sheets will be derived from the same data
> > > source
> > > > and all the sheets except for one have the same column headers. Can
> > > someone
> > > > tell me how I would set this up in reporting services??? I have been
> able
> > > to
> > > > create several reports and deployed them individual. The result is a
> > > > subscription for each report, and several individual Excel files with
> one
> > > > ***. Thanks!!
> > >
> > >
>
>

Loading