Re: Reporting Services and Excel

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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 sheet 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
> > > > sheet. Thanks!!
> > >
> > >
>
>

Relevant Pages

  • Re: more on DIBAPI32 and Window Printing
    ... The filename is optional. ... The report "seems" to remember the first picture that it is ... >> from" to File and then specify the BMP. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Secure C library - fopentmp_s (a usable secure create and open named temporary file)
    ... I would like to be able to specify all three. ... The filename is then generated by filling the remaining of fname. ... Although this specification would allow many different implementations, the drawback is that it assumes that the initial portion of a filename has some useful interpretation, like directory names in POSIX and Windows. ... Another possibility would be to add a template parameter which specifies how the filename is to be constructed. ...
    (comp.std.c)
  • Re: Filename Problem
    ... specified which is then opened and loaded into the matlab workspace. ... [filename, pathname] ... The easiest thing is to specify an output argument for load: ...
    (comp.soft-sys.matlab)
  • File Upload - ValidationExpression (ASP.NET). Please help!!!
    ... "You must specify the file location and the filename must follow this ... Do I need to put it in ValidationExpression? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Problem with WQL query [CIM_DataFile]:Property-combinations fail
    ... My only problem is, if I specify some property-combinations, ... the FileName, but not the extension, it works also. ... if I specify drive, path, FileName and Extension together. ...
    (microsoft.public.win32.programmer.wmi)