Template Dataset

1) Datasets are used to store the data retrieved from databases and can be directly applied to template design. Datasets can be divided into server datasets and template datasets according to their scope of use.

2) A template dataset is private, which corresponds to the current template, is stored in a separate file of this template and cannot be shared with other templates.

3) Please read: Data Connection, Dataset

1. Open the Template Dataset interface

1) Click [Template]>[Template Dataset] on the toolbar above.

2) The Template Dataset interface is shown below.

2. Add a new template dataset

Please refer to Dataset for dataset type. We use DB query as an example.

1) Click  and select [DB Query].

2) Select the database FRDemo.

3) Input the following SQL statements:

SELECT * FROM Sales_Volume 
WHERE Region='${Region}'

Where '${Region}' represents a parameter, which controls the value range of Region field.

4) Set the default value of region as [East China], and the type of the default value to character string type.

5) The new template dataset will be displayed at the bottom left of the main interface of the Designer.

3. Composition of the template dataset page

The template dataset page is mainly composed of the following four parts:

1) New template dataset interface;

2) Data connection interface;

3) Database SQL query statement interface: and

4) Parameter setting interface.