计算机科学 ›› 2017, Vol. 44 ›› Issue (5): 184-188.doi: 10.11896/j.issn.1002-137X.2017.05.033

• 软件与数据库技术 • 上一篇    下一篇

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

汤加,符云清,万煊民   

  1. 重庆大学软件学院 重庆400044,重庆大学软件学院 重庆400044,重庆大学计算机学院 重庆400044
  • 出版日期:2018-11-13 发布日期:2018-11-13

Visual Custom Report Model Based on Single Data Source

TANG Jia, FU Yun-qing and WAN Xuan-min   

  • Online:2018-11-13 Published:2018-11-13

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

关键词: 可视化,自定义报表,数据源,XML

Abstract: 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 project 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.

Key words: Visualization,Custom report,Data source,XML

[1] LIU L Q.The Research of Report Tool Based on NonlinearModel [D].Beijing:North China Electric Power University,2010.(in Chinese) 刘丽钦.基于非线性模型的报表工具的研究[D].北京:华北电力大学,2010.
[2] SUN F P.Design and Implementation of A Reusable ReportGenerating System Based on XML Technology [D].Beijing:Beijing University of Chemical Technology,2005.(in Chinese) 孙风平.基于XML的可复用报表生成系统的设计与实现[D].北京:北京化工大学,2005.
[3] XIN Y L.The Research and Implementation of the Reusable Report Processing Platform Based on SoftproLine[D].Harbin:Harbin Engineering University,2007.(in Chinese) 辛玉玲.基于SoftproLine的可重用报表处理平台的研究与实现[D].哈尔滨:哈尔滨工程大学,2007.
[4] XU N S,SUN F P.Design and Implementation of Reusable Report Generating System Based on XML Technology [J].Computer Engineering and Design,2006(3):463-465.(in Chinese) 许南山,孙风平.基于XML的可复用报表生成系统的设计与实现[J].计算机工程与设计,2006(3):463-465.
[5] XUAN S B,LI Y S,LI X,et al.User-defined report design based on excel in VC [J].Computer Engineering and Design,2006,28(8):1483-1485,1488.(in Chinese) 宣士斌,李永胜,李熹,等.VC中基于Excel的用户自定义报表设计[J].计算机工程与设计,2006,28(8):1483-1485,1488.
[6] CHEN C B,HUANG G,LIU Q H.Design and Implementation of a NewUser-Defined Report Based on ASP.NET [J].ComputerEngineering & Science,2006,28(6):112-114.(in Chinese) 陈传波,黄刚,刘清慧.一种基于ASP.NET的自定义报表的设计与实现[J].计算机工程与科学,2006,28(6):112-114.
[7] PAN Y C,LIU H L.Design and Application of Customizable Re-porting System [J].Intelligent Processing and Application,2015(1):104-106.(in Chinese) 潘永才,刘海龙.可定制报表系统的设计与应用[J].物联网技术,2015(1):104-106.
[8] FU Y Q,XIAO W T,LIAO X,et al.Design and Implementation of User-definition Report Based on Excel and XML[J].Compu-ter Science,2013,0(7):147-149.(in Chinese) 符云清,肖文婷,廖希,等.基于Excel和XML的自定义报表设计与实现[J].计算机科学,2013,0(7):147-149.
[9] GAO H Y.Research and Application of Key Technologies inWeb Report Development[D].Xi’an:Xidian University,2011.(in Chinese) 高红艳.Web报表开发中的若干关键技术研究与应用[D].西安:西安电子科技大学,2011.
[10] WANG Z W.Research of Enterprise Information System andKey Technologies Based on Component [D].Beijing:China University of Petroleum,2008.(in Chinese) 王振武.基于构件的企业信息系统及其关键技术研究[D].北京:中国石油大学,2008.
[11] ZHANG J.Design of Report Generation System Based on .NET [D].Xi’an:Northwestern Polytechnical University,2004.(in Chinese) 张军.基于.NET的报表生成系统设计[D].西安:西北工业大学,2004.

No related articles found!
Viewed
Full text


Abstract

Cited

  Shared   
  Discussed   
No Suggested Reading articles found!