Co-construction and share filing system with Finereport

First, the application of the background

With the continuous development of information technology, the rapid development of a suitable user business needs of the development of the report is a potential in the inevitable, so in the continuous research and analysis of this business characteristics of the production of this reporting system, in order to enable different developers to build and share data for reporting and statistical analysis of the report system.

Second, the tool

Finreport, Oracle relational database.

Third, the demand analysis

The reporting officer is responsible for the completion of the local state and city;

The project manager needs to make a statistical analysis of the entire shared facility to form new statistical reports and charts to provide decision-making information.

Five, data analysis

Analyze dimensions

System classification--the database design of basic data must use the master table to clarify the data that the state, who at what time to fill out.

Classification of resources--reporting documents and statistical reports

Vi. Production of statements

① Traditional methods of making

Difficulty 1, for the completion of the needs of the report table corresponding database tables may have multiple and in the reporting address can not use any incoming parameters such as: [Url]&op=write, etc.

Difficulty 2, fill out the report using the tab, so the use of data between pages to reference the problem need to add a refresh button.

Difficulty 3, the database table initial chemical control configuration table is empty, you need to generate the corresponding primary key word in the interface Gencun storage and the relationship between the table also need to be deposited into the table.

② using Finereport reporting tools

Support the production of multi-data source report, easily realize the association between the system;

database table primary key fields are used to generate primary key numbers using the function uuid () in the Finereport Report tool and are not stored correctly. The refresh operation is done by re-reading the data from the database again.

Seven, the effect shows

Data Reporting Guide page:

There is no data for the first entry to the reporting page.

Click on the "New" button to enter the new page

After entering the appropriate information, click on the Return button to return to the boot page after clicking submit successfully.

Click Back to go to the Boot list page to see the data you just created

Click on the "Fill out" link to enter the Fill page

Just now the information can be clearly seen but can not be modified Oh, next click on the "Go to fill page >>" link into the fill.

Click on a different tab page to switch to a different reporting page to complete the data reporting

The refresh button in the Function menu can be displayed on the page after the data that needs to be reread is re-read.

Note: Now the office staff on the Excle form used to use, so the imitation of the Excle form is also doubly emotional, in addition to the humanized guide function is more perfect. The only disadvantage is that the judgment of permissions and the operation of the data on it can only be difficult for the logged-on user to manipulate only the data that they have created. Hope that Finereport can provide some access to the user login parameters, such as: User name and other information, used as a basis for judgment.

Copyright NOTICE: This article for Bo Master original article, without Bo Master permission not reproduced.

Co-construction and share filing system with Finereport