Automatically Update Charts, Graphs, and Reports in PowerPoint

Here is a neat trick for getting graphs in PowerPoint to automatically update from SQL Reporting Services.

Prerequisites:

• Word
• PowerPoint
• SQL Reporting Services

1. Go directly to the report server, not the SharePoint integrated mode. Have it output to HTML,
2. insert it into a field in Word, then
3. embed that word document in a PowerPoint slide.

http://ReportServerMachine/ReportServer?http://LocationOfReport/Shared%20Documents/DailyReport.rdl&rs:Command=Render&rs:Format=HTML4.0&rc:Toolbar=False

Alternatively, you can render it as an image:
http://ReportServerMachine/ReportServer?http://LocationOfReport/Shared%20Documents/DailyReport.rdl&rs:Command=Render&rs:Format=Image&rc:Toolbar=False&rc:OutputFormat=PNG

The reason for this is that the SharePoint integration puts in a bunch of AJAX that confuses Word. The report server can produce pure HTML with no Javascript.

Thanks:  Shashank Pawar, his post has some screenshots.