Research And Implementation Of Report Engine Based On Cell Expansion

A report is a medium for presenting data with tables and charts,and the use of reports is ubiquitous in the enterprise.Excellent reports can filter,merge,statistics,and analyze basic data,provide a visual representation and a good basis for decision makers.Firstly,this article looked at the pros and cons of reporting tools at home and abroad,including BIRT,JasperReport,Pentaho and rundry reports.There are several important features of Chinese reports:multiple data sources,segmentation,cross group computing,it shows that these tools have problems in designing and representing Chinese reports.Secondly,this article abandoned the traditional strip-type design method,adopted a design method based on cell unit,and implemented a report engine based on cell expansion theory.This theory learned from EXCEL,including the naming way of cell unit,the basic properties setting way of cell unit and the contents expression of cell unit.This theory realized data filteration and merge by using the inheritance relationships between cells as core.Thirdly,this article designed a paging way for final result matrix which is used in normal paging situation and repeat paging situation,and described the representation way of final result.Finally,it desinged serveral application scenarios according to the features of Chinese reports,tested the presentation and export foundation of the report engine,and summarized the test results.The test results showed that this report engine based on cell expansion can meet the needs of Chinese reports.