Databases Reference
In-Depth Information
Click next to
Parameter Name
to display value
@City
. Both the boxes get a
gray border and the
Delete
button is enabled. However, it appears this will
not modify the query.
3.
4.
Click on
Delete
and click on
OK
to the
Dataset Properties
screen and in the
Query
tabbed page remove the where clause:
"WHERE Customers.City LIKE @City"
5.
Then, delete
@City
from the
Parameters
node under
Report Data
. Run the
report (hit
F5
) and verify that the parameter for searching is removed.
6.
Delete the
Total
row as well. Verify the third row has been removed.
Adding a group to the data
Right now, there is no column grouping. We have seen earlier that the data can be
grouped by
City
or
Country
and we will now create a column group.
1.
Delete the
Country
column as shown in the following screenshot:
Search WWH ::
Custom Search