SQL Server 2012 Tutorials: Reporting Services by Reporting Services

Author:Reporting Services
Language: eng
Format: mobi, epub
Publisher: Microsoft Corporation
Published: 2012-06-20T16:00:00+00:00

Start the tutorial

1. If you saved HelloWorldPicnicPowerViewRTM.xlsx in a SharePoint Server 2010 document library, click the arrow next to the HelloWorldPicnicRSDS.rsds shared data source, and then click Create Power View Report.

If you saved HelloWorldPicnicPowerViewRTM.xlsx to the PowerPivot Gallery, then click the Create Power View Report icon for.

Power View opens with the blank view in the center, the ribbon across the top, and field list on the right. In the fields section of the field list are three tables. To begin with, the tables are collapsed, showing just their names:

• Dates

• Items

• Quantities

These tables make up the data model on which the Power View report is based.

2. To expand the tables, click the arrows next to the table names.

Now you can see the fields in each table. These may include calculated columns (marked with a Sigma Σ symbol), measures (marked with a small calculator symbol), and row label fields (marked with a gray and white icon).

For more information about calculated fields and measures, see Measure and Non-Measure Fields in Power View. For information about the Power View design environment in general, see Project Crescent Design Experience.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.