通用水晶报表自动生成技术研究

Research on Automatic Generation Technology of General Crystal Report

针对水晶报表制作周期长、维护困难,难已满足用户个性化和不断变化需求的现状,文中研究自动生成技术,设计思路是由大型数据库支持前端程序运行,将报表的外观、结构、程序等信息存储在数据库中,运行时根据这些信息自动生成报表。首先进行界面设计,包括报表页眉节、页眉节、详细资料节、页脚节、报表页脚节;然后进行数据库设计,包括概念结构设计和逻辑结构设计;最后进行关键程序设计,包括主程序设计、设置字段设计、设置统计值设计。运用自动生成技术,提高了软件开发劳动生产率,改变了传统的软件开发模式。

For the current situation about long production cycle, difficult to maintain, difficult to meet users＇ individual and changing needs of crystal reports, study automatic generation technology, the design idea is run by the large database front-end programs, and the report appearance,structure,procedures are stored in database,running to automatically generate reports based on this information. First conduct interface design,including the report header segment, header segment, details segment, page footer segment, report footer seg- ment;second,carry on database design,including conceptual structure design and logic structure design;finally ,conduct key program de- sign, including main program design, set field design, set statistics design. Using the automatic generation technology, improve the labor productivity of software development, and has changed the traditional mode of software development.