Working with data

Data source

Please, note that the database user that is used to create the connection must have limited rights to modify the database, as well as rights to view private data. Otherwise, you allow full access to the database to any user who runs the report generator with this template.

FastReport Online Designer does not have the ability to add data sources, but you can create a connection through the connection wizard by setting the required connector on the server. Also, if you open a report with a data source added, it will be shown in the Data window. You can drag fields from a data source onto the report page. This will create a text object with a link to the data field.

The source data can contain related tables. That is, the tables have a relationship on the key field that allows you to create reports of type "Master-detail". One record in the primary table will match one or more records in the detail table. FastReport Online Designer cannot create the relationship, but allows to use them when working with the already created reports.