Home Product Center
Product Introduction Composition Structure Function Details Core Advantages Video Tutorials Free Download Free Activation Code Acquisition Successful Cases
Customer Overview Typical Customers More Successful Cases Knowledge Garden
Frequently Asked Questions Insights and Discussions Design Details Installation Deployment Filling Specialized Professional Knowledge About FineReport
Corporate Philosophy Corporate Culture Contact Us Partner Recruitment Talent Acquisition Product Center Product Introduction Composition Structure Function Details Core Advantages Video Tutorials Free Report Download Free Activation Code Acquisition Function Details
FineReport, as the leading Web-based reporting software in China, offers very comprehensive reporting functions. You can quickly view the detailed features of FineReport by clicking on the following list. Simple and efficient report designer
Powerful data presentation (report) function
Zero-client-side data entry form
Browser-based zero-client report printing
Heterogeneous data source table association
High-performance report server
Visually appealing chart function
24-hour report scheduling
Ad hoc reports
Parameter passing and report management
Permission function
Report display platform
Deployment and secondary development
Simple and Efficient Report Designer
The design concept of FineReport is "Excel + Data Column." Most basic operations and interface styles are similar to Excel, which means that when designing reports with FineReport, you only need to understand operations related to binding data columns to cells. Operations related to data columns involve binding database fields to cells and then using relationships between cells for symmetrical expansion of rows and columns to obtain the required report format. These operations are handled by backend code, eliminating the need for manual expression writing.
Excel-like designer interface, simple and easy to use. The FineReport designer interface is similar to Excel, so users familiar with Excel don't require any additional learning costs. Even general users can quickly master the use of the designer after reading the FineReport help documentation. The design interface is simple and user-friendly, allowing non-technical end-users to learn and use it to create report templates. Interface as shown below:
Web-based report designer with an Excel-like interface, drag-and-drop design for report templates, a clever data binding function where users can simply drag and drop to create report templates. Users do not need to master complex code writing, reducing the learning difficulty and greatly improving the efficiency of creating report templates.
Report Cell Functions
Cell Formatting: Similar to Office operations, including borders, font size, color, background color, etc.
Cell Diagonal Lines: Supports multiple diagonal lines in headers, flexible settings.
Cell Subordinate Relationships: Cells bound to data columns are not parallel but have subordinate relationships; subordinate cells expand according to their parent cells.
Floating Elements: Including text, formulas, graphics, images, etc., can be dragged to any position on the report;
Conditional Highlighting: Suitable for large data displays, highlights important data;
Hyperlinks: Can link web pages, email addresses, and reports. Most importantly, linking other reports to achieve data drilling;
Parameters and Filtering Conditions: Interactive control of reports.
Remote interactive editing, collaborative design of report templates Innovative multi-person remote-assisted design of report templates, powerful template locking, unlocking functions, and permission controls effectively ensure the efficiency and synchronization of multi-person collaboration.
FineReport Remote System Interaction Design, Web 2.0 New Experience Customizable Personalized Report Designer FineReport can customize personalized report designers, where menus, toolbars, including page structures, can all be customized according to different types of users. For example, the designer used by finance department users and HR department users within the same FineReport-based system can be different, fully meeting the personalized needs of users.
Lossless Import of Excel Files FineReport Report Designer supports lossless import of Excel files and binds data on existing Excel files for editing, saving a lot of time and improving the efficiency of making report templates.
Powerful Data Presentation (Report) Function
FineReport supports both pure DHTML and Swing modes of presentation, dynamically controlling pages and outputting report files without distortion into various common file formats.
Perfectly Solving Chinese-style Reporting Problems Regardless of how the original data in the database is stored or how the final user requires the data to be displayed, FineReport's unique multi-data-source relationship queries and formula dynamic expansion calculations allow for the creation of report templates exactly according to user requirements without changing the table structure or altering user requirements.
Diverse Data Presentation Styles Supporting HTML, PDF, EXCEL, WORD, TEXT, FLASH style presentations. Additionally, internal template files can also be generated.
Overlay Printing Feature FineReport uses background drawing and absolute positioning to complete overlay printing designs. Users can scan the forms they want to overlay as background images and use the report designer to place data positions accurately.
Print Control Features Provide comprehensive page print controls: forced pagination, filling blank rows, row-column pagination, overlay printing, free column division, repeating titles, PDF printing, server-side printing, etc. Specifically, force pagination based on grouping or other arbitrary methods, fill blank rows. Titles can repeat during pagination, not just the top header, but also the left header for wide tables can be set to repeat during pagination. Data can be freely divided into columns, longer reports can be divided by rows and displayed in multiple columns. Reports with many columns can use column division to show multiple rows on the same page.
Zero Client-Side Data Entry Form
All traditional data entry solutions fail to solve the matching relationship between business rule-compliant data tables and report cells, resulting in significant difficulties in either the initial design of reports or the later storage of data. However, FineReport's zero-client-side form solution, based on its powerful data presentation function, achieves free association between form content and data tables, making two-way data flow possible. It solves the problem of end-users customizing forms.
Zero-Coding Form Creation Users can efficiently and flexibly use the report designer to freely customize forms that fit their business logic while taking on the responsibility of maintaining the forms later.
Free Combination of CRUD Database Operations
Data Validation Ensuring that data entered is reasonable (e.g., whether an address is a valid email address); ensuring that the data entered meets business logic relationships (e.g., monthly sales equal the sum of daily sales). If incorrect data is inputted, the form system will provide pre-set prompts and locate the erroneous cell for easy correction by the inputter. There are two types of validity checks: one is immediate check, checking the current cell when the input focus leaves that cell, and if validation fails, the focus cannot leave. The second is submission check, checking before submitting all filled data, and if validation fails, submission is not allowed. Designers can also set prompts for when validation fails to inform users of the reasons for errors.
Automatic Calculation After filling out a cell's content and passing validation rules, the form will generate JavaScript expressions at the front-end based on user settings, automatically updating relevant cell contents or calculating results for unfilled cells, reducing data entry work. Automatic calculation can also span across sheets, involving mutual computations among multiple sheets.
Dynamic Control of Cell Writability To ensure data accuracy and security, form filling must be determined based on the context of the form to decide whether cells are editable.
Multi-source Data Entry Data can come from multiple different data sources and physical databases. The content of cells can not only be entered into multiple physical tables in the same database but also into multiple physical tables across different databases. A typical application is the main-sub-table form.
Serial Number When inserting a new row of data into a form, many cells may need to be assigned initial values based on predefined rules, reducing input workload or determining unique identifiers for new rows or custom number lists.
Multi-level Aggregation Function Aggregation involves first aggregating data from grassroots databases and then re-filling them into higher-level databases. Perform summation, averaging, counting, etc. Additionally, there are various aggregation methods such as page-aggregation and group-aggregation. For example, daily sales data stored in the user’s business system can be aggregated into a monthly sales report and then back-filled into a dedicated database table. This process can be extended to annual sales reports.
Data Expansion Automatically returns data records, and the data bound to cells can automatically expand, allowing any correspondence between report cells and database fields with automatic expansion capabilities; supports arbitrary format form data re-entry.
Row-Column Symmetry Function Data expansion is not limited to vertical expansion like traditional grouped reports but naturally supports row-column symmetry without writing a single line of code, allowing horizontal report design.
Zero-client-side Solution FineReport's form solution completely eliminates the need for third-party plugins such as ActiveX or JRE, utilizing AJAX for all page operations, providing customers with a brand-new Web 2.0 experience.
Report Splitting Function The entire report is a large, regular report, but it can actually be split into multiple irregular small regions. While these regions appear unrelated, the data between them can actually be interrelated.
Keypad Quick Input
Browser-Based Zero-Client Printing
Innovative Flash Printing Technology: This printing method perfectly resolves the browser-based report printing issue that has plagued the software industry for over a decade.
To better understand the advantages of Flash, the following compares existing report printing solutions.
Advantages and Disadvantages of Report Printing Methods
Browser Print Menu Function The advantage of this approach is that no browser extensions are needed, making it the simplest method, but it also has the most problems, such as:
Cannot precisely paginate Browsers generally determine the pagination location based on user-defined page sizes and web page content amounts, making it difficult for programmers to control. Headers and footers may interfere.
Cannot accurately align margins and printed text.
Cannot handle continuous printing For instance, if you're not just printing one ticket but several tickets consecutively.
Using Print CSS This is the most ideal method to implement web-based overlay printing. By embedding print-related CSS styles in HTML documents, this method controls the output and printing of HTML documents, such as setting paper size, paper orientation, print margins, pagination, etc. Clearly, this method has low cost, requires no plugin downloads, and has excellent cross-platform compatibility. Although Print CSS has been around for some time, no browser from any vendor has yet fully implemented the above standards, preventing developers from currently utilizing Print CSS for practical development.
Using PDF Files With this method, a PDF file stream is downloaded from the server side, opened in IE using Adobe plug-ins, and printed using Adobe's print menu. Although this solution can achieve precise overlay printing, it requires downloading an Adobe plug-in of tens of megabytes. This is often recommended by foreign reporting tools, but it is not the best choice in China, where PDFs are less popular.
Using ActiveX This solution involves downloading a control. Its advantages include high print precision and good pagination control, but its disadvantages are also obvious. ActiveX controls only support IE browsers, and because Microsoft increasingly emphasizes network security, newer browser versions often disable ActiveX by default, causing frequent installation failures. Such controls are also relatively large (generally over 1MB), requiring significant download time.
Using Applet Method Both pagination and precise printing can be achieved perfectly with this method. However, its disadvantages are also apparent:
The cost of installing Applets is enormous. It requires downloading files of several megabytes. The Applet itself may not be large, but the JRE required to run it is generally at least 10 megabytes (JRE 1.4.2, 15.45 MB). Users need great patience to perform printing.
When printing reports, data must be retrieved again from the server, making the process inefficient. In the Applet solution, data is generally presented in HTML format, and when printing, the Applet must retrieve the same invoice data from the server. It appears to print the current page's invoice, but in reality, the Applet does not use the data from the current HTML page to print but instead downloads the data to the Applet for printing. That is, if printing, there must be two requests: one for HTML presentation and one for printing.
Using Flash Method With this method, both pagination and precise printing can be achieved perfectly. Nearly 95% of browsers already have Flash Player pre-installed, so no further installation is needed before printing. If installation is necessary, it only takes a few hundred kilobytes, making it extremely convenient.
Table Association for Heterogeneous Data Sources
The FineReport reporting system can connect to various data sources, whether databases, files, Excel files, text, or enterprise applications. Through JDBC/JNDI, FineReport can connect to all mainstream databases such as Oracle, DB2, SQLServer, MySQL, Sybase. At the same time, FineReport can simultaneously connect to multiple data sources, and its built-in data table association function easily realizes table associations between heterogeneous data sources.
FineReport's table association for heterogeneous data sources supports multiple data sources and high-performance reporting servers.
The reporting server mainly includes paginated preview display, cell preview display, encoding settings (browser and server), toolbar settings, mail server settings, load balancing, reporting page cache support, JSP, Tag support, and server-side printer management.
Report Parsing Function
The FineReport reporting server primarily reads and parses templates created by the report designer and converts these templates into HTML pages, making it convenient for users to view, modify, and print data through a browser.
Multiple Integration Usage Methods
It can be used independently or deployed as an application on third-party servers such as Tomcat, Weblogic, Websphere, etc.
Integration Method Advantages Applicable Scope
Independent Use Users do not need to understand the principles of the FineReport reporting server nor its detailed configuration process. After installing the FineReport reporting software, users can directly start and stop the server via corresponding menus in the Windows Start menu, making it very simple and user-friendly. Suitable for end-users with limited knowledge of Java language and small systems.
Deployment Use Requires installing third-party application servers such as Tomcat, Weblogic, Webshpere, etc., then deploying the FineReport reporting server as an application inside. Basic understanding of the FineReport reporting server principle is required. Its advantage is that it can share connection pool management and cluster load balancing with the application server, enabling seamless integration with the application. Suitable for users with programming and system administration knowledge of Java language and medium-to-large systems.
Data Cache Container
When a large number of concurrent users access the reporting server simultaneously, or when users access report templates with large amounts of data, the server consumes a large amount of memory. Without a disk caching mechanism, such memory usage could easily lead to server memory overflow, causing the server to crash.
The innovative data cache container of the FineReport reporting server places data read from the database, designed templates, and computed templates, which would otherwise consume much memory, into this container. This makes the FineReport reporting server capable of supporting unlimited concurrency and displaying ultra-large data.
FineReport Designer Lossless Import of Excel Files Clustering Mechanism (Cluster)
When concurrent data is particularly large, a single FineReport reporting server may not be able to handle the pressure. At this point, multiple FineReport reporting server clusters need to be built to handle client requests together, as shown in the figure below:
Clustering Mechanism (Cluster), FineReport supports unlimited concurrency and shared connection pools.
Connecting to databases is a resource-intensive and relatively slow operation in applications, but they are essential. A connection pool is a container of open and reusable database connections. The connection pool is released from memory only when all database connections are closed. The basic benefit of using a connection pool is improved application performance and scalability. The database connection pool is managed by the application server, and the FineReport reporting server and other system applications can share the connection pool, making full use of database connections and significantly increasing database read speed.
Aesthetic Chart Function
FineReport contains aesthetically pleasing chart functions with diverse types, offering common chart types found in Excel. These include bar charts, column charts, line charts, area charts, pie charts, scatter plots, radar charts, dashboards, etc. It supports combined displays of multiple types and can integrate third-party charts (such as JFreeChart).
Charts can intuitively present the intrinsic relationships of data and vividly display the state of data, providing auxiliary support for data analysis and decision-making. FineReport charts support dynamic displays and hyperlinks for more complex applications, comprehensively satisfying different application needs.
Some examples of charts are shown below:
FineReport provides common chart types found in Excel and allows combined displays.
FineReport provides common chart types found in Excel and integrates third-party charts.
FineReport provides common chart types found in Excel and integrates JFreeChart, etc.
FineReport provides common chart types found in Excel with a rich variety of chart types. 24/7 Report Scheduling
Define tasks for continuous data display and entry throughout the day. Displayed reports can be cached to disk for archiving, facilitating users' instant review. Scheduled form entries can periodically perform ETL processes such as data extraction and cleaning. The execution of schedules depends on the report server.
Ad Hoc Reports
A new semantic layer definition based on data tables allows non-technical end-users to design report templates in a browser-based interface using HTML and AJAX. They can choose predefined query conditions, define data columns, select the appearance style of the report template, and define grouped or crosstab templates. Templates can be saved and viewed anytime.
FineReport's Ad Hoc Reporting Function Parameter Passing and Report Management
Users often view reports based on certain query conditions or combinations of conditions to get the desired data results. In some cases, we also need to generate fixed-time reports such as daily, monthly, and annual reports.
Flexible Query
Supports any flexible parameter queries and combination condition queries.
Scheduled Report Generation
Automatically generates reports at scheduled times, such as daily / weekly / monthly / quarterly / annually.
Diverse Push Methods
Flexible push methods store the scheduled generated reports in local systems or FTP, email them to the server or specified addresses in various formats such as TEXT, HTML, EXCEL, PDF, Word, CSV, SVG.
Customization of Report Management
Users can also customize report management and other permission mechanisms that meet the business requirements of their enterprises on the basis of FineReport's extensible functions.
Permission Function
Enterprise application systems have high requirements for security issues. Traditional access control methods DAC (Discretionary Access Control) and MAC (Mandatory Access Control) find it hard to meet the complex needs of enterprise environments. Therefore, NIST (National Institute of Standards and Technology) proposed RBAC (Role-Based Access Control), which logically separates users from access permissions, better fitting the characteristics of enterprise users, organizations, data, and applications.
FineReport's permission control system is based on RBAC, with all permission operations subdivided infinitely and assigned to specific roles. Application system users only need to specify specific roles to conveniently use all the permission contents defined in FineReport's permission system.
FineReport's permission control system based on the RBAC model ensures enterprise data security.
FineReport's permission control system based on the RBAC model ensures enterprise data security Report Display Platform
Simple configuration without coding creates rich BS management pages for easy use.
The following is the settings page:
FineReport's BS management settings page Below is the display page:
FineReport's BS management display page Deployment and Secondary Development
The report server can be integrated into the application server in multiple ways. It provides rich, open, and clearly structured API interfaces that can be easily embedded into various applications.
WEB Deployment
FineReport's service program appears in JAR package form, which can be uniformly packaged with the application and deployed on the application server, making installation very easy.
Environment Support
FineReport is purely JAVA developed, and both the report designer and the report server support all operating systems that can deploy JDK and databases with JDBC interfaces. Particularly, the support for UNIX/LINUX is the same as for Windows.
Rich API Interfaces
FineReport provides clear, rich, and open JAVA API calls for application programmers, allowing for the extension and deep control of reports.
Page Integration
The HTML generated by FineReport can be arbitrarily embedded and placed in application pages (JSP), and the browser side is seamlessly embedded.
Return to Top FineReport V6.5.2 Download Latest Updates
FineReport 6.2 Latest Patch Release
FineReport 6.5 Latest Patch Release
FineReport Reporting Tool Collaborates with Tie Siyuan Management System
FineReport Reporting Tool Perfectly Displays Guangda Securities
Win Prizes by Activating FineReport First Season First Issue
Common FAQ Answers
How does FineReport help us develop software?
What is the activation code for the FineReport report designer?
What improvements are there in the new version of FineReport?
What are the differences between the unregistered and registered versions of the FineReport reporting software?
Business Consultation
86-025-51862240
Technical Support
86-025-66780097
About FineReport Wide Talent Recruitment Contact Us Site Map Legal Statement Copyright © 2010 FineReport, INC. All Rights Reserved.