Previous Next

Enabling the User to Filter Data : Tutorial 3: Creating and using report parameters : Task 3: Build a data set

Task 3:

In this procedure, you build a data set to retrieve data from the Products table in the Classic Models database.

1
2
Products
3
4
select productname,
productvendor,
quantityinstock
from Products
5
Choose Finish to save the data set. Edit Data Set displays the columns you specified in the query, and provides options for editing the data set.
6
Choose Preview Results to confirm that the query is valid and that it returns the correct data. You should see the results that appear in Figure 12‑11.

Figure 12-11 Data rows returned by the Products data set

Figure 12-11
7

(c) Copyright Actuate Corporation 2008