Creating Reports with FastReport (FireDAC)
Go Up to Getting Started (FireDAC)
This article guides you through the creation of your first report built with FastReport and FireDAC.
Starting
To create your first report, you need to drop the following components to your form:
- TFDConnection
- TFDGUIxWaitCursor
- TFDPhysXXXXDriverLink. In our example, TFDPhysIBDriverLink.
- From the FastReport 5.0 category of the Tool Palette.
- TfrxDBDataset
- TfrxReport
Apart from these components you need to add the dataset components that you need to create your report, for example TFDTable, TFDQuery, TFDStoredProc...
In our example we add a TFDQuery.
Add a TfrxDBDataset for each different dataset you want available on your report. Set the DataSet property of the TfrxDBDataset to the appropriate dataset.
The first three components are used to connect to your DBMS.
Use the TfrxDBDataset component to connect to the dataset, for example a TFDQuery. You need as many TfrxDBDataset components as datasets.
Use the TfrxReport to create your report.
If you need to use more than one connection or connect to different DBMSs, you can drop as many TFDConnection components as you need. You also need to drop a TFDPhysXXXXDriverLink to your form or data module corresponding to the DBMS used. Set the Connection property of the dataset to the appropriate TFDConnection.
Adding Datasets to Your Report
To start editing your report double-click frxReport1 and the editor opens.
The TfrxReport component editor area consists of a leftmost Tool Palette and three pages: Code, Data and Page1. On the right you can see the Data Tree with four tabs: Data, Variables, Functions and Classes.
In order to use the information from the DBMS in your report, you need to add the datasets to the Data Tree:
- Select the Data page on the left.
- Go to Report > Data and the Select Report Datasets opens.
- Select the datasets you want to add to the Data Tree.
- Click OK
Now you can see the dataset information under the Data tab of the Data Tree. In our example we are connecting to the EMPLOYEE.GDB database located at C:\Users\Public\Documents\Embarcadero\Studio\20.0\Samples\Data and we use a TFDQuery with the SQL statement Select * from employee;. After adding the dataset on the Data Tree all the fields from the employee table are available.
Using Datasets
Select Page1 of the FastReport editor. The added datasets are available in the Data Tree. Expanding the dataset nodes allows you to drag and drop the required fields to the page area in order to build the report.
Fast Report preview
