一种基于单数据源的可视化自定义报表模型

Visual Custom Report Model Based on Single Data Source

通过一种新的可视化定义报表方法,用户可根据需要灵活定义报表样式,并利用XML实现动态创建数据表;在此基础上配置数据源及其字段与报表单元格间的关系,系统将据此自动拼装出相应的SQL,从而快速生成满足用户需求的各类基于单数据源的报表,并可对生成的报表进行预览和导出到Excel文件。最后,在重庆交通运输(控股)集团中的实际应用表明,这种新的可视化自定义报表方法能快速适应报表变更需求,大大提高了工作效率,并保护了用户的投资。

According to a new visualization method to custom report,the users can customize report style,and use XML technology to create database table dynamically, then the users can flexibly configure data in the relationship between the cells of reports and various fields. According to automatic assembling SQL, the system can quickly generate various types of reports based on single data source to meet the users＇ needs, and it can be previewed and exported to Excel files. Finally, practical application applied in an actual proiect of Chongqing Transportation （Holding） Group Co. , Ltd. shows that the new visual custom report method will be able to quickly adapt to the changing needs of the reports, greatly improving the work efficiency and protecting the users＂ investments.