FineReport BI and reporting tool has an interface similar to Excel, with bound data in every column, which significantly reduces the cost of learning. Anyone who is used to Excel will be a fast learner of FineReport. FineReport supports multiple SHEET and cross SHEET calculations and is perfectly compatible with EXCEL formulas. Users can design arbitrarily complex patterns with WYSIWYG editor.
FineReport supports multi-working directories (project switching) and remote design. Users can locally design and remotely publish templates and directly edit and change the report documents on the server, thereby realizing inter-departmental and multi-personnel collaboration. Both data and template authorities can be set, and the template lock function prevents editing conflicts.
FineReport connects data sources through various channels including direct connection to the database via JDBC, sharing database connection with the application server via JNDI or connection to the SAP system via JCO.
FineReport supports the following types of data sources:
* Relational Database： Include such mainstream relational databases as Oracle, SqlServer, Mysql, DB2, Sybase, Access, Derby, Postgres, Informix; Support SQL data sheets or views, or stored procedures.
* Non-relational Database：Essbase, Ssas, SAP, Hadoop, FineCube, Saphana, SAP BW, MongoDB, Hive.
* Text Data Sources: Data in Excel, Txt, XML documents.
* Other Data Sources: Built-in data source in server, built-in dataset in reports, and JSON dataset.
The FineReport BI and reporting software supports multi-source data association, row and column symmetry, section, page and group report, dynamic compartment operation, function (formula) support, aggregate report, etc. FineReport can efficiently produce various types of statistical reports such as finance, HR, sales, inventory, logistics.
For the characteristics of large complex reports, FineReport introduces the function of aggregated reports, which divides the original report into rules. Each aggregate has its independence, and there is an organizational relationship between blocks and blocks.
The reports and BI product chart function available on the market are generally realized through Fusioncharts, Jfreechart and other third party plug-in components, which have such inherent defects as: poor basic functions, additional expenses (required for high-level charts), insufficient technical support capacities, unguaranteed future upgrading, etc.
The HTML5 chart technology under the independent research and development of FineReport supports various chart types, patterns and styles. It also features flexible parameter passing and rich interactive effects and perfectly supports mobile devices.
Unlike traditional tables, the Data Map provides a brand-new visual presentation of the business data, providing enterprises with a variety of visualized information for high-level business data analysis.
The FineReport Data Map has powerful functions and an abundance of built-in map levels. It supports heat maps and self-defined maps and can integrate Baidu and Google GIS maps to realize such functions as zooming and positioning.
The Dashboard is created for mobile terminals and large-size screens, and it has many unique properties (e.g., adaptive screen, independent component refreshing) that common report designers do not have.
Users can construct a powerful and comprehensive ‘Decision-supporting System’ via functions of the dashboard, charts and multiple interactions for the enhanced presentation of various business indexes and the multi-dimensional analysis of data.
The effects of FineReport’s large-size screen solution:
By setting the parameters and parameter interface, FineReport provides the flexibility to define a powerful query interface in which the user may enter query condition(s) to control the display content and the form of reports. Various controls are available in FineReport. The parameter design interface allows a visualized drag-and-drop design and flexible interface layout, and realizes many functions including parameter linkage, dynamic column query, automatic query, display of all values with null parameters, dynamic display parameter controls, viewing different reports by parameter and the direct reference of pre-defined controls.
Good interactive analysis experience helps the user to read reports and explore data value. FineReport supports several types of interactive analysis effects.
* Chart Linkage: Once the user clicks the master chart series, all sub-charts will change accordingly.
* Data linkage: Once the user clicks the master table data, the data in all sub-charts and sub-tables will change accordingly.
* Multi-data Drill: One cell data with several data drill-through linkage options.
* Drill of Any Combination: The chart can drill down to charts and tables, and the tables can also drill out charts and tables.
* Infinite Hierarchy Drill: The setting up of a drill relationship with infinite times.
* Multi-dimensional Data Analysis: Multi-dimensional display of data through the dashboard.
* Instant Analysis: Instant screening, sorting, filter operation and reference on Web page
FineReport BI and reporting software provides flexible filling functions. Users can fill reports in any pattern including multi-source filling, self filling, row filling, cross filling and multi-stage reporting. Moreover, a variety of filling verifications and submission controls enable the real and close combination of ‘filling’ (data collection) and ‘display’ (data analysis).
Multi-stage Reporting: The reporting and approving of business requirements can be realized quickly and simply based on the process and schedule engine.
Offline Filling: This function enables the offline filling of data. Such functions as control usage, data check and automatic calculation are available for offline reports.
Page-break Filling: The report to be filled is divided into several pages for browsing, thus improving the readability and performance of reports.
Multi-sheet Filling: This function supports multi-sheet report data filling.
Batch Import of excel: This function supports direct import or filling entry and enables the batch import of Excel data into the database.
FineReport supports various export types including .pdf, Word, Excel (including Excel property control), .txt, .svg and images.
APPLET, .pdf and Flash printing methods are also available in FineReport. Initialized by FineReport, Flash printing pioneers a new field of report printing technology and realizes zero-client printing.
FineReport offers a variety of print controls to meet different print requirements, including chromatography printing, page-break printing, scale printing, silent printing, offset printing, printing by automatically selecting the paper and orientation, printing by different page sizes for one group of reports and batch printing, therein addressing many actual application difficulties.
Based on the FineReport report decision-making management system (i.e., report platform), a client enterprise can build up a report center for convenient report management, account management, organization management and authority management so as to support the analysis of various enterprise themes.
Uniform Access: A uniform application access portal is provided that allows users of different roles to view reports and report functions to meet their own requirements via the account and authority control.
Centralized Management: A uniform system management environment is provided for system resources, accounts, authorities, report templates, logs and scheduled settings in the report decision-making management system, enabling the user to achieve convenient regular management.
Classified Maintenance: On the basis of integrated and regulated report data, corresponding report development tools are provided for different types of reports. A uniform and templated custom and publishing plan is adopted to simplify the report maintenance process and reduce dependence on IT technicians.
Again, FineReport has taken the lead in completely opening up the system appearance API. The user can adjust the themes in the report decision-making system to suit their own taste, including frames, backgrounds, patterns, styles and log-in pages.
FineReport business intelligence and reporting tool adopts native rendering techniques which can speed up and optimize mobile processors. The rendering speed and interactive operation fluency have been improved by a wide margin compared with traditional HTML reports. Supports component design, responsive layout, adaptive screen for mobile terminal reports (local operation is also available through gesture), data drill, chart linkage, data linkage and filling. It provides a good mobile experience with flip-over, favorites, comments and sharing functions. Supports two-dimensional code scanning to add servers and only enables access to authorized mobile devices to fully guarantee account information security.
FineReport has a user-friendly APP (name: DataAnalyst) and fully supports both IOS and Android systems. Reports can be filled in and displayed on mobile devices and PC terminals, and can be integrated to third party APPs.
This function allows the fast and convenient setting of such tasks as daily, monthly, quarterly and annual reports without additional work. After setting the schedule, the server will automatically complete the set tasks within the specified time and generate the required documents; it will even send the generated results to the user via email.
FineReport also supports scheduled filling and realizes the loading, summary and filling of data into the database through the report templates. For example, the sales performances of each branch office will be calculated regularly every month. This data exists in the databases of each branch office. Through scheduled filling, the overall performance of each branch office can be stored in the head office’s database.
All kinds of application systems have authority control to guarantee confidentiality and meet business requirements. Based on complex reports, FineReport provides rich authority authentications and refined authority control plans to facilitate single sign-on.
Through simple settings on the authority control page, the user can control the template viewing authority, filling authority and utilization authority of template remote design data connections, and displaying authority of template contents. In addition, report templates can be encrypted.
FineReport is a pure JAVA software which can be seamlessly integrated with JAVA projects. It supports independent deployment and embedded employment. Non-JAVA projects can also be perfectly deployed and integrated with the support of an independent web server.
C/S system and page integration are realized through embedded browser controls and iframe.
FineReport BI and reporting tool is not a closed application. The application developers can use web scripts and API interfaces for deep development and control. FineReport also supports plug-in development, installation, utilization and management to meet individualized requirements. At the same time, FineReport is making great efforts to construct the FineReport ecosphere and help more technicians benefit from FineReport’s plug-in development.