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
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
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.
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
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.
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...
Note that 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.
Thanks Wagdi for the post. Really useful stuff.