Filtering the Dataset
the dataset to make it smaller for purposes of reporting.
On the Data
tab, click the ellipses ("...") to the right of the Dataset
Selector, as shown in Illustration 19.
dialog appears, as shown in Illustration 20.
Click the Filters
first row in the Expressions column.
selector becomes enabled.
following from the options that are available in the Expressions
In the Operator
column of the same row, select the "=" ("equal")
sign, if not already in place
in the Value column of the same row.
following word into the Expression list:
specifying that we wish to filter the dataset to return the Clothing
category only. Note that this is a filter of the dataset, and
affects reports that rely upon the dataset; it is not a filter of
the data source, as we shall see.
Expression dialog appears as shown in Illustration 21.
Illustration 21: The
Edit Expression Dialog
to accept the expression and close the dialog.
returned to the Filters tab of the Dataset dialog, which now
appears as shown in Illustration 22.
Dataset Dialog - Filters Tab
dialog closes, and we arrive at the Data tab of Report Designer.
Click the Run
button to populate the Result pane.
pane is populated by the Dataset. We see not only the Clothing category,
but all others from our initial query, as well. This is because, as I
mentioned earlier, the filter lies between the Dataset (what we
see in the Result pane) and the report.
Click the Preview
tab to process the preview of our report.
begins, and data begins populating the report even as processing is occurring.
We see that the Clothing category is the only category
returned in the report, as partially depicted in Illustration 23.
Illustration 23: Report
Preview (Partial View)
understanding of the filter operation is confirmed.
Click the Layout
tab to return to the Design Surface
new data column, Line Total, appears for selection in the Fields
pane, as shown in Illustration 24.
Illustration 24: Line
Total Joins the Field Selection
We are now ready to add
the Line Total field to our report. But first, let's save our work to
free up system resources, as well as to avoid any mishaps.
--> Save RS02_Authoring.rdl As ... from the main menu.
the location of choice in the Save File As dialog.
Name the file
will add a new data field and a subtotal next.