This is related to using the PowerView reports in SQL Server 2012 using Analysis Services in the tabular mode.

I thought it would be helpful to post some of the URL Actions that you can use with your PowerView Reports which will add more functionality to your reports and to your end users.

So this will then enable you to have more options when sending out the PowerView Reports to end users, depending if you want them to create the reports or just view reports other people have created.

As I find more URL Actions I will then update them in this blog post.

The first two URL Actions that I have below I actually found from Dan English Blog, but I have put them in here again as a reference for myself also.

http://denglishbi.wordpress.com/2012/06/13/url-actions-with-reporting-services-power-view-rtm/

Before I explain the actual URL Actions it might be useful to explain where you would add the URL actions.

For any of the URL Actions below you simply need to add the URL Action to the end of your URL string. So this is what the normal URL would look like:

http://powerpivot/_layouts/ReportServer/AdHocReportDesigner.aspx?RelativeReportUrl=/PowerView/My%20Report%20Table%20Name/SQL%20Name%20Table%20Name%20Report.rdlx&ViewMode=Presentation

And after you add a URL Action it will have the following at the end, which will be highlighted in RED below

http://powerpivot/_layouts/ReportServer/AdHocReportDesigner.aspx?RelativeReportUrl=/PowerView/My%20Report%20Table%20Name/SQL%20Name%20Table%20Name%20Report.rdlx&ViewMode=Presentation&ReportSection=ReportSection

Below are the URL Actions

URL Actions

Each of the URL Actions will be explained below with a screenshot of what the expected outcome will be.

&ViewMode=Presentation

This is the default when you click on a report from SharePoint. It still shows the File, Edit Report and Full Screen Mode. As we as enabling the user to refresh the data.

&ViewMode=Edit

If in SharePoint you click on Edit in PowerView you will then go to the Edit Mode which enables the user to Edit the Report. Or it will show you the Ribbon for editing and creating your report

&PreviewBar=True

This is the same as the &ViewMode=Presentation.

&PreviewBar=False

This is where you will not show the Preview Bar at all. So the user will not be able to edit, go Full Screen or refresh the data once the report has loaded.

NOTE: In order to not show the PreviewBar at all, you have to ensure that your &ViewMode is set to Presentationalso. So you should add following URL Action at the end of your URL: &ViewMode=Presentation&PreviewBar=False

If the &ViewMode is set to Edit, it will still show the PreviewBar

&ReportSection=ReportSection

This is the default view that you will see when open the report

NOTE: If you do not have multiple views then the ReportSection will not apply to your report

&ReportSection=ReportSection3

This is when you create multiple views in your Report and you want the report to open on a particular View. As with the above example this will open on View Number 4. The reason for this is the first ReportSection is Zero, then one, two etc…

I hope that it helps you guys out