We will introduce data set of FineReport reporting tool in this article.Data set means the data collection that is taken from database and directly applied in the template design.

1. Overview

Data set means the data collection that is taken from database and directly applied in the template design.
Data set, based on application scope, can be divided into Server Data Set and Template Data Set.

1.1 Server data set

Server data set is defined in Server >Server Data Set, which is applicable to the data sets of all reports on the entire server, including Database Query, Built-In Data Set, File Data Set, SAP Data Set,Stored Procedure, MDD, Linked Database and Tree Database.

1.2 Template data set

Template data set is defined in the Template > Template Data Set or the Data Set Window, which is only applicable to the data set of single template. Specific types are same as those in the server data set.

Template data set is only valid for current template.

2. Data set window

The Data Set Window of designer will display all defined data sets, including Template Data Set and Server Data Set, as shown below:

Note: Data Set Window can add, delete and query the template data set, but can only preview the server data set and stored procedure data set.