Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

Exporting SQL Server Reporting Services Reports to PowerPoint


By:   |   Read Comments (1)   |   Related Tips: More > SQL Server 2016

Attend these FREE MSSQLTips webcasts >> click to register


Problem

This tip covers a new Reporting Services 2016 feature: exporting reports to PowerPoint.

Solution

A new feature introduced in the SQL Server 2016 preview CTP 2.4 is the ability to export reports to PowerPoint. To test this functionality, I used the sunburst chart from this tip How to create a Sunburst Graph in SQL Server Reporting Services 2016.

Sunburst example

The careful reader may have noticed that in the latest CTP 3.0 release, the sunburst now by default starts with the biggest slice at 12 o'clock. This was one of the remarks in the sunburst tip, but it has already been fixed by the SSRS team.

When the report is run, you can simply select PowerPoint from the export drop down menu.

Export

If you don't see PowerPoint listed, you can check the report server configuration file (RSReportServer.config) to see if the PPTX rendering extension is registered and visible. There's a known bug that when you upgrade SQL Server 2016 from an older CTP to CTP 2.4, the PPTX rendering extension is not installed. In that case it's better to install a brand new SSRS instance using CTP 2.4 or later.

When the report is rendered, you'll get a dialog prompting you to save the PowerPoint file. When you open the file, you can see the result:

PPT export

The title and the footer have been translated to separate text boxes and the chart has been converted to an image. Now let's add a table to our report:

Add table

When exported to PowerPoint, the table has been converted to an image as well and not to a PowerPoint table.

PPT export with table

Actions (such as linking to a URL) are preserved on textboxes (like the title for instance), but not on charts or tablixes. In the following export, there's an action defined on the title and the table, but only the title can be clicked in PowerPoint.

PPT export with actions

Just like in most rendering extensions - like PDF for example - you have to pay attention to the size of your report body and its objects inside. If not, it's possible your report is spread out over multiple PowerPoint slides. It can even happen that the generated image of your chart or table is divided in multiple pieces. Here is an example:

PPT export with incorrect size
Next Steps


Last Update:


signup button

next tip button



About the author
MSSQLTips author Koen Verbeeck Koen Verbeeck is a BI professional, specializing in the Microsoft BI stack with a particular love for SSIS.

View all my tips
Related Resources





Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Notify for updates 


SQL tips:

*Enter Code refresh code     



Thursday, April 13, 2017 - 1:00:22 PM - Dave Back To Top

Thanks! Shame they dont let you export to powerpoint in portrait. they give the option but it doesnt do anything. 

 


Learn more about SQL Server tools