Finereport short tutorial

Software Installation and help

1. Software: http://www.finereport.com/products/trial

2. register and obtain the activation code: http://www.finereport.com/products/login?mobile phone receives the verification code and sends it to IOT platform. After successful registration, you will receive an email containing the user name, password, and activation code.

3. Help System: http://www.finereporthelp.com/?help after installation-> tutorial

4. After the first installation, enter the obtained verification code to open the software. Some features are disabled in the trial version, which limits the maximum number of connections.

5. System demonstration. Help> demo

The administrator username and password that can be configured are saved in:

% Installation directory % \ webreport \ WEB-INF \ resources \ privilege. xml

Define data connection

Open the software server of the template designer-> define data connection

Supports JDBC and JNDI. JDBC includes Oracle, MySQL, DB2, sqlserver, Sybase, and access. You only need to enter the URL and user name and password. Data connections are stored in:

% Installation directory % \ webreport \ WEB-INF \ resources \ datasource. xml

Design Report

Open the template designer to create a workbook, create a database query on the dataset panel, drag the queried fields to the workbook, and add the header. We designed the report goodslist. CPT. By default, the designed report storage directory is:

% Installation directory % \ webreport \ WEB-INF \ reportlets.

Deployment

You can choose independent deployment or embedded deployment. Because it is integrated into an existing project, select embedded deployment.

1. Copy the four directories classes, Lib, reportlets, resources under the % finereport_home % \ webreport \ WEB-INF directory to the % project directory % \ WEB-INF.

2. Integrate the Web. xml file

For Tomcat integration, you only need to add the corresponding Servlet and servlet-mapping child elements to the Web. xml of an existing project.

Copy the following part of Web. xml under % finereport_home %/webreport/WEB-INF to the Web. xml under % project directory %/WEB-INF and insert after the last servlet:

1. <servlet>

2. <servlet-Name> reportserver </servlet-Name>

3. <servlet-Class> Com. Fr. Web. reportservlet </servlet-Class>

4. <load-on-startup> 0 </load-on-startup>

5. </servlet>

6. <servlet-mapping>

7. <servlet-Name> reportserver </servlet-Name>

8. <URL-pattern>/reportserver </url-pattern>

9. </servlet-mapping>

3. Check whether the deployment is successful

Restart tomcat, start the browser, and enter

Http:/IP: server port number/project directory/reportserver. If you successfully enter the management platform, the finereport application has successfully deployed the Tomcat server.

Reportserver? OP = FS is a data decision-making system.

Reportserver? OP = fr_platform is the FR management platform. Here you can set administrator accounts and customize identity authentication.

Web page Integration

Finerepor reports can be directly integrated into web pages through the frame framework. Web pages can be written in many scripting languages, such as JSP, ASP, PHP, VB, JavaScript, and HTML, A report can be embedded in a frame to be displayed on a web page.

If you want the buttons on your system page to call the finereport internal ready-made JS methods such as (printing method), you need to load the finereport JS file. In actual situations, a page may not only have the report part, it also loads your own JS files. To avoid unnecessary JS conflicts, we recommend that you display the report content in the frame instead of in the div. In this way, when calling the js method inside finereport, you do not need to introduce the JS file of finereport. You can directly obtain the report through frame and then call the method. For details, refer to customizing toolbar nodes in the paging document.