Add a New Reporting
will add a new Report Server project, within which we will craft a basic
report to present an approach for rapid KPI creation.
the Solution 'RS032_Adventure Works level, atop the tree within the Solution
--> New Project ... from the cascading context menus that appear, as
depicted in Illustration 25.
Illustration 25: Adding a
Project to the Solution ...
New Project dialog appears.
Within the Templates
pane, select Report Server Project.
following into the Name box underneath the Templates pane:
RS032 Simple KPIs
Navigate to a
desired location, using the Browse button to the right of the Location
box, as necessary, for the new Project file.
New Project dialog appears, with our input, similar to that shown in
Illustration 26: Adding a New Report Server Project ...
to create the new Report
Simple KPIs Report Server Project appears, with associated object folders,
in Solution Explorer, as depicted in Illustration 27.
Illustration 27: The New Report
Server Project within the Solution Explorer
next create a shared Data Source within the new Report Server Project.
This will be the last of our preparatory steps for working with KPIs in a
an Analysis Services Shared Data Source
Within the Solution
Explorer tree, just underneath the new RS032 Simple KPIs Report Server Project, right-click the Shared Data
New Data Source ... from the cascading context menus that appear, as shown in
Illustration 28: Adding
a New Shared Data Source
Data Source dialog opens, defaulted to the General tab.
following into the Name box on the General tab.
RS032_Adventure Works DW
following in the Type box, just beneath the Name box:
Microsoft SQL Server Analysis Services
Click the Edit
button to the right of the Connection string box, underneath the Type
Click the Edit
button on the Shared
Data Source dialog.
Properties dialog opens.
correct server / instance name into the Server name box of the Connection Properties dialog. (Mine is MOTHER1\MSSQL2K5,
In the Connect
to a database section in the bottom half of the dialog, in the selector box
labeled Select or enter a database name, select RS032_Adventure Works
Properties dialog appears, with our settings, similar to those
depicted in Illustration 29.
Illustration 29: The
Connection Properties Dialog with Example Settings ...
authentication settings are correct for the local environment, as we did for
the relational data source above
10. Click the Test Connection
message box appears, indicating that the Test connection succeeded,
assuming that our changes (or lack of same, as appropriate) are appropriate.
The message box appears as shown in Illustration 30.
Illustration 30: Testing
Positive for Connectivity ...
11. Click OK to dismiss the
12. Click OK to accept changes,
and to dismiss the Connection
Data Source dialog appears, with modified settings, similar to that
shown in Illustration 31.
Illustration 31: The Shared
Data Source Dialog with Modified Settings ...
13. Click OK to close the Shared
Data Source dialog, and to return to the development
We are now ready to create a basic report, and to gain some
exposure to creating KPIs in Reporting Services.