(Generally speaking, a complete report design process is roughly divided into the following processes:
1: Open the designer
2: Configure the data source
3: New report
4: Configure private data sources
5: Report Design
6: Preview the report
7: Publish the report
Part 1: Configuring the Data Source
Step 1: Create a new database
Open the report designer, select the server on the top menu bar of the designer, select the public data source manager from the drop-down menu, and a data source manager dialog box will pop up.
Click the Add Data Source button in the upper left corner of the dialog to add a new data source. Here we name the data source FRDemo.
Select the data source just named with the mouse, and the corresponding data source property modification panel will be displayed on the right, with five properties: driver, URL, user name and password, and a test database connection button.
Step 2: Set database properties
First set the driver, select sun.jdbc.odbc.JdbcOdbcDriver in the driver item, and then click the ... button next to the URL text box, the system will automatically display the corresponding URL format according to the selected driver.)