Databases Reference
In-Depth Information
Hands-on exercise 5.4 - setting up a group
and creating a document map
Demographic data provides a good example of the idea of groups. The global data of
country is first broken up into information pertaining to states and information related
to the states in turn comes from the various counties. Grouping of information helps in
providing global pictures of the state of things of importance such as education, health,
welfare programs, and so on.
Report Builder's GUI provides a great deal of support for groupings of data in
a database.
In the previous hands-on exercise, you created a query that had a parameter in it.
You later associated this with the report. As we are going to use the same report,
at first, you will modify the query to drop the parameter. Once the parameter is
dropped, you have no filtering and you will get all the rows.
To work with groups, you will start with this set from a single data source.
Using this source, you will group your data based on
City
.
Bring up the report from the previous hands-on
exercise and remove a parameter
You need to bring up the report either from the report server, if you saved it there,
or from the file system. You should look for the report file,
ParametricReport.rdl
.
We are doing this because we want to use the report we created earlier. We could
start from scratch as well. However, by doing this we also learn how to undo things.
1.
From the button at top-left side of Report Builder 3.0, click on
Open
and
browse. Most likely, you will find it in the adjoining list of
Recent Documents
.
2.
Double-click on
Dataset1
. This brings up the
Dataset Properties
page,
click on the
Parameters
tab as shown in the following screenshot:
Search WWH ::
Custom Search