locked
Output SSRS reports as Powerpoint slides??? RRS feed

  • Question

  • Hi,

    I have a random and bizarre question, is there a way to add an SSRS report to Powerpoint presentations as a slide? Basically, I have a Powerpoint presentation which currently sucks chart data from an Excel spreadsheet into a Powerpoint slide, such that the ppt can only be updated by refreshing Excel (which is itself pulling on a pivot from SQL Server). What I'm trying to do is replace this fairly clunky process with a straight query from SQL into an SSRS report which will update the slide in the PPT presentation. The process requires that users still have access to the Powerpoint slide so they can make changes to it but the data itself is embedded until such time as it's refreshed (preferably by a scheduled agent task), but also so that the slide can be viewed offline, I've only ever used SQL for on-line reporting in HTML and Excel, can anyone think of a way (either by MS or 3rd party product) that I can do this?

    Cheers in advance.
    My wife says I never listen to her, or something like that anyway.
    Wednesday, May 27, 2009 3:21 PM

Answers

  • There are third party offerings available (e.g. from Aspose) that provide a PowerPoint rendering extension on top of RS 2005 and RS 2008.

    HTH,
    Robert
    Robert Bruckner   http://blogs.msdn.com/robertbruckner
    This posting is provided "AS IS" with no warranties, and confers no rights.
    • Marked as answer by StraNGeLaD Thursday, May 28, 2009 4:13 PM
    Thursday, May 28, 2009 4:00 PM

All replies

  • "Save the reports as images and import them into PowerPoint slides:
    http://www.pptfaq.com/FAQ00050.htm
    Use Live Web:
    http://skp.mvps.org/liveweb.htm
    Export graphs to excel and import into PowerPoint
    http://www.pptfaq.com/FAQ00593.htm
    "

    Also, can't you use the SSRS toolbar to export to powerpoint?

    "I have no particular talent. I am merely inquisitive." -- Albert Einstein
    Wednesday, May 27, 2009 3:27 PM
  • Save the reports as images and import them into PowerPoint slides:
    http://www.pptfaq.com/FAQ00050.htm
    And this is automated how exactly?

    Use Live Web:
    http://skp.mvps.org/liveweb.htm
    This is simply iframing the product, if the product is offline then there'll be nothing there surely?

    Export graphs to excel and import into PowerPoint
    http://www.pptfaq.com/FAQ00593.htm
    How is this easier than the current solution?

    Also, can't you use the SSRS toolbar to export to powerpoint?
    Again, how is this automated?


    My wife says I never listen to her, or something like that anyway.
    Thursday, May 28, 2009 9:26 AM
  • It's not automated.
    "I have no particular talent. I am merely inquisitive." -- Albert Einstein
    Thursday, May 28, 2009 3:39 PM
  • There are third party offerings available (e.g. from Aspose) that provide a PowerPoint rendering extension on top of RS 2005 and RS 2008.

    HTH,
    Robert
    Robert Bruckner   http://blogs.msdn.com/robertbruckner
    This posting is provided "AS IS" with no warranties, and confers no rights.
    • Marked as answer by StraNGeLaD Thursday, May 28, 2009 4:13 PM
    Thursday, May 28, 2009 4:00 PM
  • Thanks, that seems to be the best option, I've been looking at it and might try downloading the trial edition and seeing if it's a practical solution. Cheers.
    My wife says I never listen to her, or something like that anyway.
    Thursday, May 28, 2009 4:13 PM