Reports with Multiple Views in Power View

SQL Server 2012
Important note Important

Please visit the most up-to-date Power View documentation on Power View is now a feature of Microsoft Excel 2013, and is part of the Microsoft SQL Server 2012 Reporting Services add-in for Microsoft SharePoint Server 2010 and 2013 Enterprise Editions.

In Power View, you can create a report with multiple views that you can click through in a presentation, as you can in Microsoft Office PowerPoint. All the views in one report are based on the same model. You can copy and paste from one view to another, and duplicate whole views. If you save preview images of the views, an image of each view is displayed in the PowerPivot Gallery in SharePoint Server 2010.

Note Note

Power View is a feature of SQL Server 2012 Reporting Services Add-in for Microsoft SharePoint Server 2010 Enterprise Edition.

Report containing several views

Report with multiple views

In any mode, you can use the up and down arrow keys to navigate to the different views in a report.

In design mode, you can click the views in the View pane.

In reading and full-screen modes, you can:

  • Click the view chooser button in the lower-left to show a row of the views in the report.

    View chooser icon

    Slide chooser icon in preview, full-screen modes
  • Click the navigation arrows in the lower-right.

  • Press the arrow keys.

Each view can have its own filters, but the state of the Filters Area is constant: if the Filters Area is expanded on one view, it will be expanded on all views. As you move from view to view, in any mode, the state of the filter on each page persists: for example, if you have a filter for the Product Category field filtering for one view for cell phones, when you leave the view and return to it, the filter will still be filtering for cell phones. When you duplicate a view, the filters are duplicated, too, along with the state of each filter. Saving the report also saves the state of each filter.

View preview images are the images that Power View displays in the View pane in design mode. When you save a Power View report, by default these images are saved with the report. They are then displayed in the PowerPivot Gallery in SharePoint Server 2010, just as Microsoft Excel worksheets are displayed. However, you have the option not to save them.

Caution note Caution

Consider not saving preview images if they display information that you consider potentially sensitive.

For more information see Choose Whether to Save an Image of Each View with the Report.

Community Additions