Integrate PowerPoint and Reporting Services?

I am trying to move many of our group's monthly report functions from
Excel workbooks to a common Reporting Services environment, so data
will be visible to everyone at the end of the reporting period.
However, some of these slides have found their way into committee
meetings, which are driven entirely out of PowerPoint presentations.
I am being hit with a request to merge RS Reports with the existing
PowerPoint presentations. Unfortunately, while RS does render to the
screen, there is no easy way to copy the output to a file at a quality
level equivalent to what we had.
Right now, I can save my reports to Excel, then copy-paste the Range
into PowerPoint, but many times the built-in export fails to render
like the Report shows the data on the screen, often including cell
borders in Excel that were not specified in the HTML as well as other
spacing weirdness.
* Is there way I can include an embedded object in PowerPoint that
references a ReportViewer that pulls from the Reporting Server? The
Include Object menu in PP does not list this as an option.
* Is there a way to build a custom Render function to output the whole
page to a WMF (Windows MetaFile) format?
-- ScottOn Nov 9, 4:44 pm, Orne <polysilly...@.yahoo.com> wrote:
> I am trying to move many of our group's monthly report functions from
> Excel workbooks to a common Reporting Services environment, so data
> will be visible to everyone at the end of the reporting period.
> However, some of these slides have found their way into committee
> meetings, which are driven entirely out of PowerPoint presentations.
> I am being hit with a request to merge RS Reports with the existing
> PowerPoint presentations. Unfortunately, while RS does render to the
> screen, there is no easy way to copy the output to a file at a quality
> level equivalent to what we had.
> Right now, I can save my reports to Excel, then copy-paste the Range
> into PowerPoint, but many times the built-in export fails to render
> like the Report shows the data on the screen, often including cell
> borders in Excel that were not specified in the HTML as well as other
> spacing weirdness.
> * Is there way I can include an embedded object in PowerPoint that
> references a ReportViewer that pulls from the Reporting Server? The
> Include Object menu in PP does not list this as an option.
> * Is there a way to build a custom Render function to output the whole
> page to a WMF (Windows MetaFile) format?
> -- Scott
I can't speak directly to your scenario; however, you could either try
creating a custom renderer to render in Power Point from SSRS/
Reporting Services (http://msdn.microsoft.com/msdnmag/issues/05/02/
CustomRenderers/default.aspx ) -or- you could purchase a third party
tool (http://www.downloadjunction.com/product/software/135002/
index.html ). Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Nov 9, 7:01 pm, EMartinez <emartinez...@.gmail.com> wrote:
> I can't speak directly to your scenario; however, you could either try
> creating a custom renderer to render in Power Point from SSRS/
> Reporting Services (http://msdn.microsoft.com/msdnmag/issues/05/02/
> CustomRenderers/default.aspx ) -or- you could purchase a third party
> tool (http://www.downloadjunction.com/product/software/135002/
> index.html ). Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
Thanks, this is very promising!
-- Scott|||On Nov 12, 8:01 am, Orne <polysilly...@.yahoo.com> wrote:
> On Nov 9, 7:01 pm, EMartinez <emartinez...@.gmail.com> wrote:
> > I can't speak directly to your scenario; however, you could either try
> > creating a custom renderer to render in Power Point from SSRS/
> > Reporting Services (http://msdn.microsoft.com/msdnmag/issues/05/02/
> > CustomRenderers/default.aspx ) -or- you could purchase a third party
> > tool (http://www.downloadjunction.com/product/software/135002/
> > index.html ). Hope this helps.
> > Regards,
> > Enrique Martinez
> > Sr. Software Consultant
> Thanks, this is very promising!
> -- Scott
You're welcome. Let me know if I can be of further assistance.
Regards,
Enrique Martinez
Sr. Software Consultant