FineReport: Connect to database: multiple database connection status views, confirm data connection configuration with one click. The author takes connecting to the access database as an example. You only need to select the access database file to connect. Select data table: You can quickly switch between different databases and query the data table you want to use. After selecting the data table, drag it into the data editing box. The steps to select a data table are only "Add data type→Select data table→Drag the data table→Confirm". Report design: Supports batch dragging of data fields. The expansion direction and format of the fields are set directly in the cell attribute table. There are multiple display options, including grouping, list, and summary. The conditional attributes, hyperlinks, data filtering, chart settings, etc. required in advanced report design can all be found in the previous step of the cell that needs to be set and the settings can be quickly selected (appear in the right operation panel or right-click to appear). FR has preset a variety of cell styles that can be selected directly. FR provides history records. If users open and edit multiple templates at one time, they can directly find the template they want to edit or refer to. RQ:
Connect to database: A single database connection view, which requires multiple clicks to confirm to complete the data configuration. When the author connects to the access database, he needs to configure it in the "ODBC Data Source Manager" of the Windows system in advance, and then match the settings in the ODBC data source configuration of the RQ designer.
Select data table: You can switch between different databases, but you cannot query the data table you want to use. After selecting the data table, drag it into the data selection box. The steps to select a data table are "Configuration → Data Set → Data Set Type → Find Data Table → Drag and Drop Data Table → OK → OK".
Report design: only supports dragging of a single data field. The expansion direction and format of the field need to be set by clicking multiple times in the property settings panel. There are many choices for display methods. If it is not in the report setting navigation If you set it up in one step, you need to write expressions in the cells later, and it is difficult to convert between list display and group display. It is more troublesome to set up conditional attributes, hyperlinks, data filtering and charts. Sometimes it is necessary to combine semantic layer settings and require a large number of function expressions. RQ has no preset cell style (predefined cells are displayed as empty).
If the user opens multiple templates, the following picture will appear when switching back and forth, and it is impossible to distinguish which template is to be opened. Because RQ's parameter panel and report panel are two templates, it is also very troublesome when there are parameter templates.
In terms of report design, Runqian provides a report production wizard to facilitate beginners to use. Throughout the wizard, the designer needs to clarify the format and display effect of the report in advance, otherwise it will be difficult to modify it later, or if an error occurs in the process, it will have to start all over again.
Comparison conclusion: Runqian’s tabulation efficiency is limited by the writing of a large number of function expressions, and is further limited by the details and layout of the designer. It fails to consider the user’s habits and improve them. FineReport, on the other hand, attaches great importance to the simplicity and coding-free nature of tabulation. It has conducted in-depth research and respects users' reporting habits. It is the fastest to get started, has the best experience, and has the highest tabulation efficiency in the industry.