This topic will guide you through the process of creating a simple data-aware report with dbForge Studio for MySQL. You will learn how to bind a report to data, edit report bands, use the Data Source window to add report controls to the report and bind them to data, and also how to number pages in the report.
Note that it is recommended that you review the How To: Create a Static Report topic first. It will help you learn how to create a simple report with dbForge Studio.
In this example, a report will be bound to data from the address data table of the Sakila database. To add the table to the report, simply drag it from Database Explorer to the Data Source window.
Now, your report is bound to data. The next steps show how to customize the report’s layout, and to specify which data fields should be used to provide data for report controls.
Click the top-left corner of the report designer to invoke the report’s smart tag. Choose the Edit and Reorder Bands… option in this list to edit the collection of report bands. For example, select the PageHeader band and remove it (it’s unnecessary for this report) but add the ReportHeader band:
You can also use the Report Editor dialog box to change any other report band settings (e.g. the height of the PageFooter band).
Now, you have a data-aware report. Its structure is shown on the right side of the report document. Note that bound controls are marked with yellow database icons:
In this topic, you’ve created a simple report which is bound to data. You can now proceed to the Creating a Master-Detail Report topic to learn how to use Detail Report bands to create master-detail relationship reports.