Partager via

Can i edit my PowerView Report exported to PowerPoint in Presentation Mode? YES YOU CAN

  • Article

with the release of SQL Server 2012 different versions until the RTM last week. Microsoft introduced a one kicking feature in the Business Insight Pillar with the new Amazing easy-to-use reporting PowerPivot that you can simply export this report to PowerPoint and when your slides are running the report can start being interactive.

well not only this. you can even turn you report to be editable so you can start creating some charts and do ad-hoc analysis within your presentation. so how can I do this let have a look

1. A key thing you need to know is that when you export your PowerPivot Report to PowerPoint the object that is exported is connecting to the report on the Sharepoint not connecting to the datasource of the Report. something like this

PowerViewFlowExample

2.  So after you export your Report to the PowerPoint right click on the object in the slide and click properties and in the InitParams scroll to the end and change AllowEditViewMode and set it to True

PVinPPS

3. when you present your slide Deck you’ll be able to do edit the report and start dragging and dropping same experience as the Web One.

PVinPPS2

PowerPivot is an amazing experience for Personal BI and demonstrating how easy and a flexible tool it’s to quickly get up from a database to an interactive editable report inside a presentation

 Manually modifying the InitParams or any of the Silverlight control properties is not an officially supported scenario. See msdn.microsoft.com/.../hh759323(v=sql.110).aspx. Thank you Riccardo Muti for the Heads-up

Comments

  • Anonymous
    January 01, 2003
    Note that manually modifying the InitParams or any of the Silverlight control properties is not an officially supported scenario. Seemsdn.microsoft.com/.../hh759323(v=sql.110).aspx.

  • Anonymous
    March 14, 2012
    I believe in the post you mean Power View instead of PowerPoint. I know it is kind of easy to mix up at times and there is a space in the name.

  • Anonymous
    March 14, 2012
    See how easy it is to mess this up.  I meant Power View instead of PowerPivot:)  I was too focused on the edit capabilities in PowerPoint...

  • Anonymous
    March 15, 2012
    Thanks Wagdi for the post. Really useful stuff.