Create a New Chart Report
this section, we will launch Reporting Services' Report Designer, and then
create a new report with a dataset. Next, we will place the chart item
on the report. Finally, we will designate and populate the report item.
a Blank Report
begin by creating a blank report.
the Reports folder in Solutions Explorer.
from the context menu that appears.
New Item from the cascading menu, as shown in Illustration 5.
in the Add New Item dialog.
following into the Name box, replacing the default of Report1.rdl
New Item dialog appears, as shown in Illustration 6.
Illustration 6: The Add
New Item Dialog Initial View
Click the Open
button at the bottom of the Add New Item dialog.
design environment opens. We see the Data, Layout and Preview
tabs appear in the Report Designer (As I mentioned in Master Chart Reports: Pie Charts in
Reporting Services, in the views presented in many
illustrations, I have docked many of my toolbars in places I find convenient.
Your environment will probably differ somewhat, and so it may not appear
identical to the illustrations).
has opened in Data View, as shown in Illustration 7.
Illustration 7: The
Design Environment - Data View Tab (Compacted)
up a Data Connection and Create a Dataset
Our next step is to set
up a Data Connection. As we have noted numerous times throughout our
series, Reporting Services can connect with, and create the datasets it
needs from, virtually any ODBC or OLE DB-compliant data source
(in addition to the obvious MSSQL Server and MSAS data stores). .NET-based
API's add the potential for other data sources, assuming that you have a
legacy, or otherwise eccentric, scenario on your hands.
Let's set up a Connection,
and create a Dataset within our practice example.
Dataset in the Dataset selector at the top of the Data tab,
as depicted in Illustration 8.
Illustration 8: Select
New Dataset in the Dataset Selector Data Tab
As soon as we click the New Dataset selection, the Data
Link Properties dialog box appears, defaulted to the Connection tab.
Type the name
of the computer housing the targeted OLTP database, AdventureWorks2000.
server name, MOTHER1, appears in this article.)
Select the radio
button to the left of the authentication option that is appropriate for your
is Windows NT Integrated security.)
within the Select the database on the server selector.
settings on the Connection tab of the Data Link Properties dialog
should resemble those shown in Illustration 9.
Illustration 9: Data
Link Properties Dialog Connection Tab
Click the Test
Connection button to verify connectivity to the data source.
receive a message box, indicating a successful test connection, as shown in Illustration
Illustration 10: Testing
Positive for Connectivity ...
to accept the settings we have made, and to close the Data Link Properties
presents us with the dataset design tool, based upon our newly connected
source. We are immediately positioned to design our query, which brings us to
the next step.
ellipses ("...") button to the right of the default dataset name
of AdventureWorks2000, which appears in the Dataset selector, as
shown in Illustration 11.
Illustration 11: Editing
the New Dataset
for the name of the Dataset dialog box, replacing the default name of AdventureWorks2000.
remains selected for the data source by default.) The Dataset dialog
appears as shown in Illustration 12.
Completed Dataset Dialog
to accept the settings and return to the Data tab, which displays in the
Generic Query Designer.
Click the Generic
Query Designer button, shown in Illustration 13, to "deactivate"
it, and to shift, instead, to the Query Builder.
Shifting to the Query Builder ...
Builder appears. The Query Builder is composed of four distinct panes,
each of which can be resized, or hidden (or "recalled") via the
buttons atop the Query Builder and otherwise, to accommodate the needs of the
developer. The Query Builder, with sectional panes labeled on blue,
appears (compacted view) in Illustration 14.
Illustration 14: The
Panes of the Query Builder
Right click in
the Diagram pane area of the Query Builder.
menu appears, as depicted in Illustration 15.
Illustration 15: Using
the Context Menu to Add Tables to the Diagram Pane ...