CN105893634A - Method and device for generating report - Google Patents

Method and device for generating report Download PDF

Info

Publication number
CN105893634A
CN105893634A CN201610439647.3A CN201610439647A CN105893634A CN 105893634 A CN105893634 A CN 105893634A CN 201610439647 A CN201610439647 A CN 201610439647A CN 105893634 A CN105893634 A CN 105893634A
Authority
CN
China
Prior art keywords
gauge outfit
data
title
sql statement
configuration file
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Pending
Application number
CN201610439647.3A
Other languages
Chinese (zh)
Inventor
郭淳
张文杰
程唯超
王华丹
方达
冷泉
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Bank of China Ltd
Original Assignee
Bank of China Ltd
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Bank of China Ltd filed Critical Bank of China Ltd
Priority to CN201610439647.3A priority Critical patent/CN105893634A/en
Publication of CN105893634A publication Critical patent/CN105893634A/en
Pending legal-status Critical Current

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/248Presentation of query results
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, administration or maintenance of databases
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28Databases characterised by their database models, e.g. relational or object models
    • G06F16/283Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F40/00Handling natural language data
    • G06F40/10Text processing
    • G06F40/166Editing, e.g. inserting or deleting
    • G06F40/174Form filling; Merging

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • General Physics & Mathematics (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Computational Linguistics (AREA)
  • Health & Medical Sciences (AREA)
  • Artificial Intelligence (AREA)
  • Audiology, Speech & Language Pathology (AREA)
  • General Health & Medical Sciences (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

The embodiment of the invention discloses a method and device for generating a report. The need for report customization is met. The method comprises the steps that a configuration file is pre-established, wherein the configuration file comprises a header name and header format parameters of the report, and the header format parameters refer to format parameters of a table corresponding to the header name; the configuration file is read, and a header of the report is generated according to the header name and the header format parameters of the report; data corresponding to the header name is acquired from a database to generate the report.

Description

A kind of report form generation method and device
Technical field
The present invention relates to database application development field, particularly relate to a kind of report form generation method and device.
Background technology
In database application is developed, it usually needs by data in database table according to the rule pre-set Then be converted into specific file format, to meet formatting further to data and processes, analyze, common The demand enjoyed.Common particular file format is Excel form, will data conversion in data base For the form carried with Excel form.Owing to reporting tableau format to fix in prior art, it is right to be unfavorable for In data base, enriched data presents and processes, to revise original statement form or increasing new report Sheet format, it is necessary to the code generating form is modified, or develops new form code, thus A kind of report form generation method being capable of and customizing urgently occurs at present, to meet enriched data Present.
Summary of the invention
In order to solve technical problem present in prior art, the invention provides a kind of report generation side Method, it is achieved that the demand of Report Customization.
Embodiments providing a kind of report form generation method, described method includes:
Pre-build that configuration file, described configuration file include gauge outfit title and the gauge outfit lattice of form Formula parameter, described top-of-form parameter refers to the format parameter of the form corresponding with described gauge outfit title;
Reading described configuration file, gauge outfit title and top-of-form parameter according to described form generate The gauge outfit of described form;
The data corresponding with described gauge outfit title are obtained, to generate described form from data base.
Preferably, described top-of-form parameter include the initial row of form, initial row, end line and End column, the described gauge outfit title according to described form and top-of-form parameter generate described form Gauge outfit includes:
Corresponding form is merged by the initial row according to form, initial row, end line and end column, And corresponding gauge outfit title is filled in the form to described merging, to generate the gauge outfit of described form.
Preferably, described configuration file also includes the SQL statement the most corresponding with described gauge outfit title, Described SQL statement is for inquiring about the data corresponding with described gauge outfit title in data base;
The described data that acquisition is corresponding with described gauge outfit title from data base, to generate described form bag Include:
Read described SQL statement, from described data base, obtain the data corresponding with described SQL statement, To generate described form.
Preferably, the entitled form of described gauge outfit splits foundation, and corresponding data are that form splits data;
The described SQL statement of described reading, obtains corresponding with described SQL statement from described data base Data, include generating described form:
Read described form and split the SQL statement of foundation, obtain and described form from described data base Split the form fractionation data that the SQL statement of foundation is corresponding;
Generate respectively and split point form that data are corresponding with each described form.
Embodiments providing a kind of report generation device, described device includes: configuration file is built Vertical unit, gauge outfit signal generating unit and data capture unit;
Described configuration file sets up unit, is used for pre-building configuration file, wraps in described configuration file Including gauge outfit title and the top-of-form parameter of form, described top-of-form parameter refers to and described gauge outfit The format parameter of the form that title is corresponding;
Described gauge outfit signal generating unit, is used for reading described configuration file, according to the gauge outfit name of described form Claim and the gauge outfit of the top-of-form parameter described form of generation;
Described data capture unit, for obtaining the data corresponding with described gauge outfit title from data base, To generate described form.
Preferably, described top-of-form parameter include the initial row of form, initial row, end line and End column;
Described gauge outfit signal generating unit, specifically for:
Corresponding form is merged by the initial row according to form, initial row, end line and end column, And corresponding gauge outfit title is filled in the form to described merging, to generate the gauge outfit of described form.
Preferably, described configuration file also includes the SQL statement the most corresponding with described gauge outfit title, Described SQL statement is for inquiring about the data corresponding with described gauge outfit title in data base;
Described data capture unit, specifically for:
Read described SQL statement, from described data base, obtain the data corresponding with described SQL statement, To generate described form.
Preferably, the entitled form of described gauge outfit splits foundation, and corresponding data are that form splits data;
Described data capture unit, specifically for:
Read described form and split the SQL statement of foundation, obtain and described form from described data base Split the form fractionation data that the SQL statement of foundation is corresponding, generate respectively and split with each described form Point form that data are corresponding.
The present invention is by pre-setting configuration file, by gauge outfit title and the top-of-form parameter of form With code dehind, to gauge outfit title and/or the top-of-form parameter of amendment form, then directly configuring File is modified, it is not necessary to revise code again, and if be intended to increase form, then arrange new Configuration file, then utilizes original code to read new configuration file, it is not necessary to develop separately, real The multiplexing of code and the demand of Report Customization are showed.
Accompanying drawing explanation
In order to be illustrated more clearly that the embodiment of the present application or technical scheme of the prior art, below by right In embodiment or description of the prior art, the required accompanying drawing used is briefly described, it should be apparent that, Accompanying drawing in describing below is only some embodiments described in the application, skill common for this area From the point of view of art personnel, on the premise of not paying creative work, it is also possible to obtain it according to these accompanying drawings Its accompanying drawing.
The flow chart of a kind of report form generation method embodiment that Fig. 1 provides for the present invention;
The structured flowchart of a kind of report generation device embodiment that Fig. 2 provides for the present invention.
Detailed description of the invention
In order to make those skilled in the art be more fully understood that the present invention program, below in conjunction with the present invention Accompanying drawing in embodiment, is clearly and completely described the technical scheme in the embodiment of the present invention, Obviously, described embodiment is only a part of embodiment of the present invention rather than whole embodiments. Based on the embodiment in the present invention, those of ordinary skill in the art are not making creative work premise Lower obtained every other embodiment, broadly falls into the scope of protection of the invention.
Embodiment of the method:
Seeing Fig. 1, this figure is the flow chart of a kind of report form generation method embodiment that the present invention provides.
The report form generation method that the present embodiment provides comprises the steps:
Step S101: pre-build configuration file.
Under normal circumstances, form includes gauge outfit and data, and gauge outfit is mark, the mark carrying out data Or understand.In prior art, the code of report generation is all fixing, the gauge outfit of the form therefore generated Either content or form are all fixing, it is impossible to be applicable to different types of data flexibly.And Gauge outfit title and top-of-form about form, by pre-building configuration file, is joined by the present embodiment Number writes in configuration file, during generating form, as long as reading described configuration file, with regard to energy Automatically generate the gauge outfit of described form.For example, with reference to table 1, this table is the schematic diagram of configuration file, Define the cell of the gauge outfit title of form and correspondence position in the table in the table, described Position uses four parameters to represent, i.e. initial row, initial row, end line and end column, if initial row Differ with end line, and/or, initial row and end column differ, then need to carry out the conjunction of cell And.Such as, the form of entitled for gauge outfit " XX statistical table ", initial row and initial row are all 0, End behavior 1, terminates to be classified as 181, represents and is merged by front 181 cells of the first row, and Cell after merging fills " XX statistical table ".
Table 1
As a example by table 1, read described configuration file, with generate the gauge outfit of described form can be by such as Under type goes to realize: write the gauge outfit title according to form in advance and top-of-form parameter generates report The public code of table gauge outfit, during the configuration file reading described table 1, first obtains described The total number m of gauge outfit title and top-of-form parameter in configuration file, in Table 1, described m=10. Then the bar sequence number making i=1, described i be described gauge outfit data, i.e. from the Article 1 of described configuration file Start reading, the most corresponding according to the initial row of described Article 1, initial row, end line and end column Data 0,0,1,181 generate corresponding cell after, by the gauge outfit content " XX in Article 1 Statistical table " fill to this cell, then judge whether i is equal to m, if it is not, then make i=2, i.e. profit Read the Article 2 of described configuration file with described code, generate gauge outfit " mechanism number ", by that analogy. Read described configuration file, generate the process of gauge outfit be exactly by the gauge outfit title in described configuration file and Top-of-form parameter be updated to described public code and perform described substitution after the process of public code.
Except gauge outfit title and table format parameter, described configuration file can also include gauge outfit Genesis sequence etc., i.e. during generating described gauge outfit, raw according to the genesis sequence of default gauge outfit Become described gauge outfit.
Described configuration file can also include the store path of form, the need of configuration ginsengs such as compressions Number, the present invention is not specifically limited.
Step S102: read described configuration file, according to gauge outfit title and the gauge outfit lattice of described form Formula parameter generates the gauge outfit of described form.
The present embodiment by arranging configuration file, by the gauge outfit title of form and top-of-form parameter with Code dehind, to gauge outfit title and/or the top-of-form parameter of amendment form, then directly at configuration literary composition Part is modified, it is not necessary to revise code again, and if be intended to increase form, then new joining is set Put file, then utilize original code to read new configuration file, it is not necessary to develop separately, it is achieved The multiplexing of code.
Step S103: obtain the data corresponding with described gauge outfit content from data base, described to generate Form.
In the present embodiment, described form includes gauge outfit and data, and wherein, gauge outfit is according to configuration file Generating, data obtain from data base.In actual applications, obtain and form from described data base Data corresponding to gauge outfit title have multiple implementation, conventional being achieved in that to pass through SQL statement Obtain.Concrete, described configuration file also includes the SQL language the most corresponding with described gauge outfit title Sentence, described SQL statement, for inquiring about the data corresponding with described gauge outfit title in data base, is passed through Read described SQL statement, from described data base, obtain the data corresponding with described SQL statement, Thus generate described form.
The purpose that described SQL statement is arranged on described configuration file is easy for amendment, because to repair Change described gauge outfit title, then may need the SQL statement that amendment is corresponding with described gauge outfit title, so that The data inquired are corresponding with described gauge outfit title.
It addition, in actual applications, needs may be there are and generate multiple reports according to a gauge outfit title The situation of table, such as, generate point form of correspondence respectively according to province.Concrete, can be by arranging Vernier flag bit realizes the fractionation to form, and in nature, vernier is actually one can be from bag Include the mechanism every time extracting a record in the result set of many data record.If assuming gauge outfit title When vernier flag bit is 0, represent that described gauge outfit title is not form fractionation foundation, and vernier flag bit When being 1, represent that the entitled form of described gauge outfit splits foundation.Corresponding according to described gauge outfit title SQL statement obtains a form corresponding with described gauge outfit title from described data base and splits data After, when performing other data relevant to described gauge outfit title and extracting, need to split according to this form Data extract corresponding data.For example, it is assumed that form splits foundation for provincial administrative region, then Get first form corresponding with this gauge outfit title (the most provincial administrative region) and split data (example Such as Beijing) time, generate point form corresponding with described first data;Getting and this gauge outfit name When claiming second data (such as Shanghai) corresponding to (the most provincial administrative region), generate and described the Point form that two data are corresponding, by that analogy.
During generating point form, the gauge outfit title splitting foundation according to other non-forms is corresponding SQL statement extracts the data corresponding with point form, such as in generating point form corresponding with Beijing, Assume that the gauge outfit title about " population " is relevant to provincial administrative region, but not split for form and depend on According to, then extract the number corresponding with described " population " utilizing the SQL statement corresponding with " population " According to time, only extract the demographic data corresponding with Beijing.
A kind of report form generation method provided based on above example, the embodiment of the present invention additionally provides one Plant report generation device, describe its operation principle below in conjunction with the accompanying drawings in detail.
Device embodiment:
Seeing Fig. 2, this figure is the structured flowchart of a kind of report generation device embodiment that the present invention provides.
The report generation device that the present embodiment provides includes: configuration file sets up unit 101, gauge outfit generates Unit 102 and data capture unit 103;
Described configuration file sets up unit 101, is used for pre-building configuration file, in described configuration file Including gauge outfit title and the top-of-form parameter of form, described top-of-form parameter refers to and described table First place claims the format parameter of the form of correspondence;
Described gauge outfit signal generating unit 102, is used for reading described configuration file, according to the gauge outfit of described form Title and top-of-form parameter generate the gauge outfit of described form;
Described data capture unit 103, for obtaining the number corresponding with described gauge outfit title from data base According to, to generate described form.
Described report generation device include processor and memorizer, above-mentioned configuration file set up unit 101, Gauge outfit signal generating unit 102 and data capture unit 103 all store in memory as program unit, Performed storage said procedure unit in memory by processor and realize corresponding function.
Processor comprises kernel, kernel goes memorizer is transferred corresponding program unit.Kernel can With arrange one or more than, realize the customization of form by adjusting kernel parameter.
Memorizer potentially includes the volatile memory in computer-readable medium, random access memory The forms such as device (RAM) and/or Nonvolatile memory, such as read only memory (ROM) or flash memory (flash RAM), memorizer includes at least one storage chip.
The present embodiment by arranging configuration file, by the gauge outfit title of form and top-of-form parameter with Code dehind, to gauge outfit title and/or the top-of-form parameter of amendment form, then directly at configuration literary composition Part is modified, it is not necessary to revise code again, and if be intended to increase form, then new joining is set Put file, then utilize original code to read new configuration file, it is not necessary to develop separately, it is achieved The multiplexing of code and the customization of form.
Optionally, described top-of-form parameter include the initial row of form, initial row, end line and End column;
Described gauge outfit signal generating unit 102, specifically for:
Corresponding form is merged by the initial row according to form, initial row, end line and end column, And corresponding gauge outfit title is filled in the form to described merging, to generate the gauge outfit of described form.
Optionally, described configuration file also includes the SQL statement the most corresponding with described gauge outfit title, Described SQL statement is for inquiring about the data corresponding with described gauge outfit title in data base;
Described data capture unit 103, specifically for:
Read described SQL statement, from described data base, obtain the data corresponding with described SQL statement, To generate described form.
Optionally, the entitled form of described gauge outfit splits foundation, and corresponding data are that form splits data;
Described data capture unit 103, specifically for:
Read described form and split the SQL statement of foundation, obtain and described form from described data base Split the form fractionation data that the SQL statement of foundation is corresponding, generate respectively and split with each described form Point form that data are corresponding.
Present invention also provides a kind of computer program, when performing in data handling equipment, It is adapted for carrying out initializing the program code of following method step:
Pre-build that configuration file, described configuration file include gauge outfit title and the gauge outfit lattice of form Formula parameter, described top-of-form parameter refers to the format parameter of the form corresponding with described gauge outfit title;
Reading described configuration file, gauge outfit title and top-of-form parameter according to described form generate The gauge outfit of described form;
The data corresponding with described gauge outfit title are obtained, to generate described form from data base.
Those skilled in the art it should be appreciated that embodiments herein can be provided as method, system, Or computer program.Therefore, the application can use complete hardware embodiment, complete software to implement Example or the form of the embodiment in terms of combining software and hardware.And, the application can use at one Or multiple wherein include computer usable program code computer-usable storage medium (include but not It is limited to disk memory, CD-ROM, optical memory etc.) the upper computer program implemented Form.
The application is with reference to method, equipment (system) and the computer program according to the embodiment of the present application The flow chart of product and/or block diagram describe.It should be understood that stream can be realized by computer program instructions In each flow process in journey figure and/or block diagram and/or square frame and flow chart and/or block diagram Flow process and/or the combination of square frame.These computer program instructions can be provided to general purpose computer, specially With the processor of computer, Embedded Processor or other programmable data processing device to produce one Machine so that the instruction performed by the processor of computer or other programmable data processing device is produced Raw for realizing one flow process of flow chart or multiple flow process and/or one square frame of block diagram or multiple side The device of the function specified in frame.
These computer program instructions may be alternatively stored in and computer or other programmable datas can be guided to process In the computer-readable memory that equipment works in a specific way so that be stored in this computer-readable and deposit Instruction in reservoir produces the manufacture including command device, and this command device realizes flow chart one The function specified in flow process or multiple flow process and/or one square frame of block diagram or multiple square frame.
These computer program instructions also can be loaded into computer or other programmable data processing device On so that on computer or other programmable devices, perform sequence of operations step to produce computer The process realized, thus the instruction performed on computer or other programmable devices provides and is used for realizing One flow process of flow chart or multiple flow process and/or one square frame of block diagram or multiple square frame are specified The step of function.
In a typical configuration, calculating equipment include one or more processor (CPU), input/ Output interface, network interface and internal memory.
Memorizer potentially includes the volatile memory in computer-readable medium, random access memory The forms such as device (RAM) and/or Nonvolatile memory, such as read only memory (ROM) or flash memory (flash RAM).Memorizer is the example of computer-readable medium.
Computer-readable medium includes that removable media permanent and non-permanent, removable and non-is permissible Information storage is realized by any method or technology.Information can be computer-readable instruction, data knot Structure, the module of program or other data.The example of the storage medium of computer includes, but are not limited to phase Become internal memory (PRAM), static RAM (SRAM), dynamic random access memory (DRAM), other kinds of random access memory (RAM), read only memory (ROM), electricity can Erasable programmable read-only memory (EPROM) (EEPROM), fast flash memory bank or other memory techniques, read-only light Dish read only memory (CD-ROM), digital versatile disc (DVD) or other optical storage, magnetic Cassette tape, the storage of tape magnetic rigid disk or other magnetic storage apparatus or any other non-transmission medium, Can be used for the information that storage can be accessed by a computing device.According to defining herein, computer-readable Medium does not include temporary computer readable media (transitory media), such as data signal and the load of modulation Ripple.
When introducing elements of various embodiments of the present invention, article " ", " one ", " this " and " institute State " it is intended to indicate one or more element.Word " includes ", " comprising " and " having " all includes Property and mean in addition to the element listed, it is also possible to have other element.
Each embodiment in this specification all uses the mode gone forward one by one to describe, phase between each embodiment As homophase part see mutually, each embodiment stress with other embodiments Difference.For device embodiment, owing to it is substantially similar to embodiment of the method, So describing fairly simple, relevant part sees the part of embodiment of the method and illustrates.Above institute The device embodiment described is only schematically, the wherein said unit illustrated as separating component and Module can be or may not be physically separate.Furthermore it is also possible to according to the actual needs Select some or all of unit therein and module to realize the purpose of the present embodiment scheme.This area Those of ordinary skill, in the case of not paying creative work, is i.e. appreciated that and implements.
The above is only the detailed description of the invention of the present invention, it is noted that common for the art For technical staff, under the premise without departing from the principles of the invention, it is also possible to make some improvements and modifications, These improvements and modifications also should be regarded as protection scope of the present invention.

Claims (8)

1. a report form generation method, it is characterised in that described method includes:
Pre-build that configuration file, described configuration file include gauge outfit title and the gauge outfit lattice of form Formula parameter, described top-of-form parameter refers to the format parameter of the form corresponding with described gauge outfit title;
Reading described configuration file, gauge outfit title and top-of-form parameter according to described form generate The gauge outfit of described form;
The data corresponding with described gauge outfit title are obtained, to generate described form from data base.
Method the most according to claim 1, it is characterised in that wrap in described top-of-form parameter Include the initial row of form, initial row, end line and end column, the described gauge outfit name according to described form Claim and the gauge outfit of the top-of-form parameter described form of generation include:
Corresponding form is merged by the initial row according to form, initial row, end line and end column, And corresponding gauge outfit title is filled in the form to described merging, to generate the gauge outfit of described form.
Method the most according to claim 1 and 2, it is characterised in that in described configuration file also Including the SQL statement the most corresponding with described gauge outfit title, described SQL statement is for data base The data that middle inquiry is corresponding with described gauge outfit title;
The described data that acquisition is corresponding with described gauge outfit title from data base, to generate described form bag Include:
Read described SQL statement, from described data base, obtain the data corresponding with described SQL statement, To generate described form.
Method the most according to claim 3, it is characterised in that the entitled form of described gauge outfit is torn open Dividing foundation, corresponding data is that form splits data;
The described SQL statement of described reading, obtains corresponding with described SQL statement from described data base Data, include generating described form:
Read described form and split the SQL statement of foundation, obtain and described form from described data base Split the form fractionation data that the SQL statement of foundation is corresponding;
Generate respectively and split point form that data are corresponding with each described form.
5. a report generation device, it is characterised in that described device includes: configuration file is set up single Unit, gauge outfit signal generating unit and data capture unit;
Described configuration file sets up unit, is used for pre-building configuration file, wraps in described configuration file Including gauge outfit title and the top-of-form parameter of form, described top-of-form parameter refers to and described gauge outfit The format parameter of the form that title is corresponding;
Described gauge outfit signal generating unit, is used for reading described configuration file, according to the gauge outfit name of described form Claim and the gauge outfit of the top-of-form parameter described form of generation;
Described data capture unit, for obtaining the data corresponding with described gauge outfit title from data base, To generate described form.
Device the most according to claim 5, it is characterised in that wrap in described top-of-form parameter Include the initial row of form, initial row, end line and end column;
Described gauge outfit signal generating unit, specifically for:
Corresponding form is merged by the initial row according to form, initial row, end line and end column, And corresponding gauge outfit title is filled in the form to described merging, to generate the gauge outfit of described form.
7. according to the device described in claim 5 or 6, it is characterised in that in described configuration file also Including the SQL statement the most corresponding with described gauge outfit title, described SQL statement is for data base The data that middle inquiry is corresponding with described gauge outfit title;
Described data capture unit, specifically for:
Read described SQL statement, from described data base, obtain the data corresponding with described SQL statement, To generate described form.
Device the most according to claim 7, it is characterised in that the entitled form of described gauge outfit is torn open Dividing foundation, corresponding data is that form splits data;
Described data capture unit, specifically for:
Read described form and split the SQL statement of foundation, obtain and described form from described data base Split the form fractionation data that the SQL statement of foundation is corresponding, generate respectively and split with each described form Point form that data are corresponding.
CN201610439647.3A 2016-06-17 2016-06-17 Method and device for generating report Pending CN105893634A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201610439647.3A CN105893634A (en) 2016-06-17 2016-06-17 Method and device for generating report

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201610439647.3A CN105893634A (en) 2016-06-17 2016-06-17 Method and device for generating report

Publications (1)

Publication Number Publication Date
CN105893634A true CN105893634A (en) 2016-08-24

Family

ID=56731097

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201610439647.3A Pending CN105893634A (en) 2016-06-17 2016-06-17 Method and device for generating report

Country Status (1)

Country Link
CN (1) CN105893634A (en)

Cited By (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106708792A (en) * 2016-12-01 2017-05-24 北京奇虎科技有限公司 Method and apparatus for displaying report in webpage
CN106911765A (en) * 2017-01-23 2017-06-30 北京思特奇信息技术股份有限公司 A kind of report file method for down loading and device
CN107145533A (en) * 2017-04-18 2017-09-08 北京思特奇信息技术股份有限公司 A kind of report form generation method and device
CN107169294A (en) * 2017-05-22 2017-09-15 中国电子科技集团公司第四十研究所 The secondary judgement processing method of Excel forms in a kind of ATS for Environmental Test
CN107609109A (en) * 2017-09-13 2018-01-19 山东浪潮云服务信息科技有限公司 A kind of report form generation method, device and system
CN109508447A (en) * 2017-09-14 2019-03-22 长沙博为软件技术股份有限公司 A kind of list data analysis method of the high col width of fixed row
CN109739906A (en) * 2018-11-21 2019-05-10 深圳市佰仟金融服务有限公司 A kind of report form generation method and system
CN109905432A (en) * 2017-12-08 2019-06-18 武汉楚鼎信息技术有限公司 A kind of the data automatic loading method and system and device of network data list
CN110516217A (en) * 2019-08-09 2019-11-29 济南浪潮数据技术有限公司 A kind of auto report completing method and device
CN111563082A (en) * 2020-04-30 2020-08-21 中国银行股份有限公司 Report generation method and device
CN112100994A (en) * 2020-09-27 2020-12-18 中国建设银行股份有限公司 Excel-based report display method and device
CN112767013A (en) * 2021-01-05 2021-05-07 北京锐安科技有限公司 Business report splitting method, device, server and storage medium

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101308490A (en) * 2008-04-28 2008-11-19 北京航空航天大学 Dynamic report generation method and platform
CN103345484A (en) * 2013-06-21 2013-10-09 中国工商银行股份有限公司 Report form processing system based on dynamic domain and method
CN104123394A (en) * 2014-08-13 2014-10-29 中国银行股份有限公司 Method for processing report file of database
CN105260476A (en) * 2015-11-06 2016-01-20 上海熙菱信息技术有限公司 Self-defined configuration method and system for reports

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN101308490A (en) * 2008-04-28 2008-11-19 北京航空航天大学 Dynamic report generation method and platform
CN103345484A (en) * 2013-06-21 2013-10-09 中国工商银行股份有限公司 Report form processing system based on dynamic domain and method
CN104123394A (en) * 2014-08-13 2014-10-29 中国银行股份有限公司 Method for processing report file of database
CN105260476A (en) * 2015-11-06 2016-01-20 上海熙菱信息技术有限公司 Self-defined configuration method and system for reports

Cited By (13)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN106708792A (en) * 2016-12-01 2017-05-24 北京奇虎科技有限公司 Method and apparatus for displaying report in webpage
CN106911765A (en) * 2017-01-23 2017-06-30 北京思特奇信息技术股份有限公司 A kind of report file method for down loading and device
CN107145533A (en) * 2017-04-18 2017-09-08 北京思特奇信息技术股份有限公司 A kind of report form generation method and device
CN107169294A (en) * 2017-05-22 2017-09-15 中国电子科技集团公司第四十研究所 The secondary judgement processing method of Excel forms in a kind of ATS for Environmental Test
CN107609109A (en) * 2017-09-13 2018-01-19 山东浪潮云服务信息科技有限公司 A kind of report form generation method, device and system
CN109508447A (en) * 2017-09-14 2019-03-22 长沙博为软件技术股份有限公司 A kind of list data analysis method of the high col width of fixed row
CN109905432A (en) * 2017-12-08 2019-06-18 武汉楚鼎信息技术有限公司 A kind of the data automatic loading method and system and device of network data list
CN109739906A (en) * 2018-11-21 2019-05-10 深圳市佰仟金融服务有限公司 A kind of report form generation method and system
CN110516217A (en) * 2019-08-09 2019-11-29 济南浪潮数据技术有限公司 A kind of auto report completing method and device
CN111563082A (en) * 2020-04-30 2020-08-21 中国银行股份有限公司 Report generation method and device
CN111563082B (en) * 2020-04-30 2023-09-19 中国银行股份有限公司 Report generation method and device
CN112100994A (en) * 2020-09-27 2020-12-18 中国建设银行股份有限公司 Excel-based report display method and device
CN112767013A (en) * 2021-01-05 2021-05-07 北京锐安科技有限公司 Business report splitting method, device, server and storage medium

Similar Documents

Publication Publication Date Title
CN105893634A (en) Method and device for generating report
CN102024039B (en) Form generating method based on electric operation maintenance system (EOMS)
US20130263068A1 (en) Relative ordering circuit synthesis
CN107145480B (en) Method for compiling XBRL report based on Word
CN101976235A (en) Extensible Word report automatically-generating method based on dynamic web page
CN102663103A (en) Configurable method for automatically generating database and accessing data
CN102819766A (en) Method, device and enterprise system for checking forms
CN101727324A (en) Code generation method and device
CN105045775A (en) Method and apparatus for generating Excel document in designated format
CN103927385A (en) Unifying method and device of data model
CN101354759A (en) Method and system of work process flow defining conversion based on element model
CN103744647A (en) Java workflow development system and method based on workflow GPD
CN105608119A (en) Rapid thematic map drawing technology
CN103425692A (en) Data exporting method and data exporting device
Greenwood et al. A templated approach for multi-physics modeling of hybrid energy systems in modelica
CN104765775A (en) Log saving method and device
CN106649566B (en) A kind of sequence number generation method and device
CN101272222B (en) Restriction calibration method and device
CN108984156A (en) A kind of software auto generating method and system for exempting from code development based on template
CN105468570B (en) A kind of document synthesis methods of exhibiting and device
CN102446206B (en) A kind of cross-platform switch and method of three-dimensional data
CN109614519A (en) Data lead-in method and data importing device
CN105139892B (en) A kind of data-driven method of testing and system for being applied to storage product
CN107918662A (en) Document method for splitting and device
CN113485746A (en) Method and device for generating application program interface document

Legal Events

Date Code Title Description
C06 Publication
PB01 Publication
C10 Entry into substantive examination
SE01 Entry into force of request for substantive examination
RJ01 Rejection of invention patent application after publication
RJ01 Rejection of invention patent application after publication

Application publication date: 20160824