Friday, February 10, 2012

Bundling Multi-Reports Into One

We are attempting to take a 13 Slide Graphical Powerpoint Report and Generate
same in Reporting Services. The individual Slides (which contain up to as
many as 4 subreports with graph and matrix) are beautiful! They deploy well
and we are all happy...IF that is you are opening them 1 at a time and
printing...which of course any Executive worthy of the name will not do.
Our current schema is a page under our department page on our company site
for all reports. When a user chooses a report it is run and the user is able
to print it. How....(coming to the point now actually, finally) can I
bundle those 13 reports into 1 so that when the user clicks on the website
the entire 13 are run and they are able to be printed?
--
Donna Bliss
Senior Project Manager
Union Pacific RailroadThis sounds lame, but did you try to create a report that has 13
subreports -> each pointing to the report in question you want?
=-Chris
"Donna Bliss" <DonnaBliss@.discussions.microsoft.com> wrote in message
news:C33D3D04-1962-45C3-8FA9-5E40F6C7760A@.microsoft.com...
> We are attempting to take a 13 Slide Graphical Powerpoint Report and
> Generate
> same in Reporting Services. The individual Slides (which contain up to as
> many as 4 subreports with graph and matrix) are beautiful! They deploy
> well
> and we are all happy...IF that is you are opening them 1 at a time and
> printing...which of course any Executive worthy of the name will not do.
> Our current schema is a page under our department page on our company site
> for all reports. When a user chooses a report it is run and the user is
> able
> to print it. How....(coming to the point now actually, finally) can I
> bundle those 13 reports into 1 so that when the user clicks on the website
> the entire 13 are run and they are able to be printed?
> --
> Donna Bliss
> Senior Project Manager
> Union Pacific Railroad|||I have not...and I will try it, but is formatting an issue?
For example in MS Access I can place a subreport without worrying about the
size or formatting etc., it is taken from the sub report.
Is it the same in Reporting Services?
"Christopher Conner" wrote:
> This sounds lame, but did you try to create a report that has 13
> subreports -> each pointing to the report in question you want?
> =-Chris
> "Donna Bliss" <DonnaBliss@.discussions.microsoft.com> wrote in message
> news:C33D3D04-1962-45C3-8FA9-5E40F6C7760A@.microsoft.com...
> > We are attempting to take a 13 Slide Graphical Powerpoint Report and
> > Generate
> > same in Reporting Services. The individual Slides (which contain up to as
> > many as 4 subreports with graph and matrix) are beautiful! They deploy
> > well
> > and we are all happy...IF that is you are opening them 1 at a time and
> > printing...which of course any Executive worthy of the name will not do.
> > Our current schema is a page under our department page on our company site
> > for all reports. When a user chooses a report it is run and the user is
> > able
> > to print it. How....(coming to the point now actually, finally) can I
> > bundle those 13 reports into 1 so that when the user clicks on the website
> > the entire 13 are run and they are able to be printed?
> >
> > --
> > Donna Bliss
> > Senior Project Manager
> > Union Pacific Railroad
>
>|||Thanks Chris.
The sort of crazy thing is you have to add a rectangle between the 13
subreports in order to get the page breaks, but otherwise it works.
"Christopher Conner" wrote:
> This sounds lame, but did you try to create a report that has 13
> subreports -> each pointing to the report in question you want?
> =-Chris
> "Donna Bliss" <DonnaBliss@.discussions.microsoft.com> wrote in message
> news:C33D3D04-1962-45C3-8FA9-5E40F6C7760A@.microsoft.com...
> > We are attempting to take a 13 Slide Graphical Powerpoint Report and
> > Generate
> > same in Reporting Services. The individual Slides (which contain up to as
> > many as 4 subreports with graph and matrix) are beautiful! They deploy
> > well
> > and we are all happy...IF that is you are opening them 1 at a time and
> > printing...which of course any Executive worthy of the name will not do.
> > Our current schema is a page under our department page on our company site
> > for all reports. When a user chooses a report it is run and the user is
> > able
> > to print it. How....(coming to the point now actually, finally) can I
> > bundle those 13 reports into 1 so that when the user clicks on the website
> > the entire 13 are run and they are able to be printed?
> >
> > --
> > Donna Bliss
> > Senior Project Manager
> > Union Pacific Railroad
>
>|||No. And subreports cannot be placed in a table or matrix if you are
exporting in Excel format (they will be ignored). There are also other
problems when a user saves an Excel report that has subreports and then
loads it back in. Subreports are best avoided and used as a last resort.
Donna Bliss wrote:
> I have not...and I will try it, but is formatting an issue?
> For example in MS Access I can place a subreport without worrying about the
> size or formatting etc., it is taken from the sub report.
> Is it the same in Reporting Services?
> "Christopher Conner" wrote:
>
>>This sounds lame, but did you try to create a report that has 13
>>subreports -> each pointing to the report in question you want?
>>=-Chris
>>"Donna Bliss" <DonnaBliss@.discussions.microsoft.com> wrote in message
>>news:C33D3D04-1962-45C3-8FA9-5E40F6C7760A@.microsoft.com...
>>We are attempting to take a 13 Slide Graphical Powerpoint Report and
>>Generate
>>same in Reporting Services. The individual Slides (which contain up to as
>>many as 4 subreports with graph and matrix) are beautiful! They deploy
>>well
>>and we are all happy...IF that is you are opening them 1 at a time and
>>printing...which of course any Executive worthy of the name will not do.
>>Our current schema is a page under our department page on our company site
>>for all reports. When a user chooses a report it is run and the user is
>>able
>>to print it. How....(coming to the point now actually, finally) can I
>>bundle those 13 reports into 1 so that when the user clicks on the website
>>the entire 13 are run and they are able to be printed?
>>--
>>Donna Bliss
>>Senior Project Manager
>>Union Pacific Railroad
>>

No comments:

Post a Comment