Dan English's BI Blog

Welcome to my random thoughts in regards to Business Intelligence, databases, and other technologies

URL Actions with Reporting Services Power View (RTM)

Posted by denglishbi on June 13, 2012

[tweetmeme source=”denglishbi” only_single=”false”]

Yesterday we took a quick peek inside the RDLX file – Inside the Power View RDLX File.  Today we will take a step back into SharePoint and explore what we can do when we access the Power View files through the URL.

WARNING: The items that are displayed and discussed here are not documented at all by Microsoft and could potentially change at any point down the road, so use at your own risk.power view

Many of you might be familiar with Reporting Services (SSRS) and creating report files (RDL).  With these files you have a lot of flexibility with your design and you can also leverage a lot of commands and syntax when accessing these files through the URL (in Report Manager or SharePoint) – URL Access Parameter Reference.

So what is available with v1 of Power View with the RTM release of SQL Server 2012?

Unfortunately not a whole lot.  But we do have a couple of things:

  1. ViewMode
  2. ReportSection

Hmmm….they don’t look like anything we had available with previous report files.  You are absolutely correct.  These are new options that are specific to Power View files (RDLX files).  With these files we can determine how the initial viewing mode is – currently only presentation (reading mode) or edit – and then which report (view) you want to look at (assuming you have multiple views in your report files).

So let’s take a quick peek at what these options look like:

ViewMode

With the ViewMode option you currently have two options you can use, either Presentation (Reading) or Edit

Presentation (Reading) mode is the initial view state of Power View files that you see when you access a RDLX file in SharePoint

image

Edit mode is what you see when you open up the canvas and have the options to be able to alter and change the layout of the report

image

You can now see that by switching the ViewMode value from Presentation to Edit we go from the Reading mode to the Edit mode where the canvas is available and we can modify the layout and design of the Power View report file.

ReportSection

What are ReportSections? In the RDLX file layout, a ReportSection is actual the equivalent of a view in a report file.  So if you have multiple views you will have multiple ReportSection tags within the ReportSections portion of the RDL file that is embedded in the RDLX file (see previous post for information on this – Inside the Power View RDLX File).   Take the file from our previous post and we can see the XML layout as follows:

image

The ReportSections area is setup so that when you export into PowerPoint and access the views in say the PowerPivot Gallery it knows which view of the RDLX file to display and output.

In looking at our example up above you can see that we have 4 views included in the Power View report.  In the XML displayed here we see 4 ReportSection tags in the RDL file and the naming convention is ReportSection, ReportSection2, ReportSection3, and ReportSection4.

So with the naming convention displayed here let’s go back to our URL expressions above and expand on them and include the ReportSection into the URL address to change from the first view in the Power View report file to the second:

image

By using the ReportSection command we have been able to navigate from the first view (report) in our file (ReportSection=ReportSection) to the second view (ReportSection=ReportSection2).  Pretty slick!

As you can image this will work for the third and fourth views in the report file as well.

So for now this is what we have available to us, just ViewMode and ReportSection.  It does provide you the means to be able to send an end-user to a specific view within a Power View report file (assuming you have more than one view defined).

If you want to find out more about Power View and want to learn about designing Tabular models to support Power View, don’t forget to check out our book – Visualizing Data with Microsoft Power View.

Enjoy!

Advertisements

3 Responses to “URL Actions with Reporting Services Power View (RTM)”

  1. Erik Langhorst said

    if you look in the initparams of a powerpoint export of PowerView, you’ll see more parameters.
    check: http://blogs.technet.com/b/meacoex/archive/2012/03/14/can-i-edit-my-powerview-report-exported-to-powerpoint-in-presentation-mode-yes-you-can.aspx on how to get them

  2. […] https://denglishbi.wordpress.com/2012/06/13/url-actions-with-reporting-services-power-view-rtm/ […]

  3. Vishal said

    Hi,

    Have you worked on localizations with PowerView reports? We have 64 reports in a SharePoint site that need to be “converted” to Dutch, I am trying to find if there is a way to do it. I did try to extract the rdl file from the rdlx file and modify them but on zipping and renaming them the files become unreadable to SharePoint.
    Can you help?
    Thanks,

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: