Computer Science ›› 2017, Vol. 44 ›› Issue (5): 184-188.doi: 10.11896/j.issn.1002-137X.2017.05.033

Previous Articles     Next Articles

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

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!