CN103631767A - Automatic generation method of universal data report - Google Patents
Automatic generation method of universal data report Download PDFInfo
- Publication number
- CN103631767A CN103631767A CN201210296958.0A CN201210296958A CN103631767A CN 103631767 A CN103631767 A CN 103631767A CN 201210296958 A CN201210296958 A CN 201210296958A CN 103631767 A CN103631767 A CN 103631767A
- Authority
- CN
- China
- Prior art keywords
- data
- report
- generation method
- automatic generation
- universal
- 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
Links
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention relates to a report generation method, in particular to an automatic generation method of a universal data report, and belongs to the technical field of computers. The automatic generation method of the universal data report at least comprises the following steps of grabbing report data from a data source, carrying out structural description applicable to tables on the report data, selecting report format data items as needed, calling a universal table handling process through an inter-process communication technology, and using the grabbed report data to generate a report file according to the content of selected table data items. Due to the fact that the automatic generation method of the universal data report is achieved through a human-computer interaction mode and the inter-process communication technology, the problems that in the process of report generation, the style is fixed, and a file format cannot be universal are effectively solved, and a user can achieve the purpose that the corresponding report file with the universal format can be efficiently, flexibly, conveniently and automatically generated through the appointed data source.
Description
Technical field
The present invention relates to a kind of report form generation method, especially a kind of automatic generation method of conventional data form.The invention belongs to field of computer technology.
Background technology
In field of computer technology, the form of electronics offers with the form of form the data that user is concerned about, and the analysis result producing for these data.The form that statement form provides with respect to other data, has the features such as simple and clear, directly perceived and standard, is widely used in all trades and professions.But, due to all trades and professions, all departments are different for the call format of form, and the pattern of the add-ins such as title of form, gauge outfit, table tail is also varied, in many existing methods, be all to generate specific form for a certain series products at present, the pattern of form is relatively fixing, report file form disunity after generating like this, and can not open, process with general spreadsheet; Or enable to open, its pattern can not reach the form of user's expectation, cannot meet the various needs of user, generally have to utilize by hand and process again by user.The form generating according to existing method does not have extensibility, if the pattern of form changes, needs update software source code, not only can not for interface user, directly use in time, and the work cost of modification source code is larger, safeguards inconvenient.Have, the report file form owing to adopting existing method to generate, does not possess versatility again, is therefore often unfavorable for the follow-up reprocessing of data in form.
Formally in view of the foregoing, the present invention proposes a kind of automatic generation method of brand-new conventional data form, make the generation of form more flexible, more meet user's use.
Summary of the invention
The object of the invention is to: the deficiency existing for above prior art, the technology of carrying out Inter-Process Communication in the mode of man-machine interaction realizes the automatic generation of form.Effectively solved that the pattern in Report form application is fixed and the uncurrent problem of file layout, thereby made user can carry out efficiently, generate flexibly required data sheet.For realizing the present invention, at least need following steps:
Step 1: seize report data from data source;
Step 2: data are carried out to structural description;
Step 3: option table table formateed data item as required;
Step 4: utilize inter-process communication techniques to call form of general use treatment progress, by the report data of seizing according to the list data item content generating report forms file of selecting.
Particularly, seize report data step and further can comprise image data, data are processed, obtain the result data that need to show in form.Be processed as statistical calculation in form, such as summation, the computing such as average; The message gathering as data query or file polling or user-defined format sends.
For ease of data can the form List of input with parameter in, described data structured is described as that data formation is had to the 2-D data structure that form row and column is described, namely data structured is described as finally need to being presented at the result data in form, and by data importing in self-defining 2-D data structure.Two-dimensional structure data are the set with the pleasure trip on foot of same alike result, and the attribute that its most important feature is all first ancestrals must be the same.Such as relational data table, bivariate table etc.
For the convenience of the user, described selection statement form data item, such as title, gauge outfit, the table tail of form be listed as the content information of first-class project and the table style information such as each self-corresponding font, color, carries out with guide approach.
Known according to technique scheme analysis, the form that use the present invention generates automatically compared to the prior art tool has the following advantages:
1, greatly improve the efficiency of user's generating report forms, be conducive to robotization and the normalized enforcement of form.
2, the use of man-machine interaction mode, has increased the dirigibility of form greatly, makes report style to carry out Dynamic Selection and needn't revise source code according to user preferences.
3, owing to utilizing inter-process communication techniques directly to call general form, process file generated form, make final report file there is certain Universal and scalability.User can open the report file that previous step generates, and directly further revises.
Embodiment
Embodiment mono-
Use Microsoft VisualStudio .Net developing instrument exploitation client operating software, use database management tools SqlServer2000 special-purpose on market to set up the needed database of system, concrete mode is:
Step 1: links and accesses data source, and obtain corresponding primary data, can gather report data.This process user can realize in many ways, such as message transmission of data base querying, file polling, user-defined format etc., if need to show result data in form, the data that gather are reprocessed, certain statistics for example, the calculating such as sue for peace, average, otherwise directly carry out next step.
Step 2: form 2-D data structure, 2-D data structure is custom data version, the data of report display with report tableau format is corresponding should be consistent, namely the same with form have a row and column structure, it is parameter input that this data structure is conducive to the Organization of Data of form, so that in importing form, form form content.Two-dimensional structure data refer to have first ancestral's of same alike result set, and the attribute that its most important feature is all first ancestrals must be consistent, such as relation database table, bivariate table etc.Concrete, the formation of 2-D data should, before Inter-Process Communication, just should complete before creating target process example.The data of passing to its use when target process creates are exactly the data that can directly show.The publicity that the arrangement process of data needs according to user after access data sources obtains raw data completes.This implementation has multiple, and the mode that can select by classification allows user select the method that arranges to provide summation as the first step, and user can select also can not select this statistical, completely according to user's needs.Also the mode that can add up publicity by User Defined is processed these raw data.2-D data is exactly dynamically to determine according to user's needs.
Step 3: select, determine the data item of statement form, this step can complete by user and computer interactive process.Can be with the form of guide in this process, by user, specified the content of project and the patterns of pattern and report data such as title, tabulation time, query time, row head, gauge outfit, table tail of form, such as title, gauge outfit, the table tail of form be listed as first-class contents of a project information and the table style information such as the font of reply separately, color.The pattern of the form that is like this, can be able to flexible control in whole report generation process.The change of pattern needn't be changed source code.
Step 4: utilize after the mode option table formatted data item of guide, utilize popular inter-process communication techniques at present, call as OLE technology etc.Such as passing through OLE technology, the link of object and embedded technology, in originating process, create a target process example, if the process excel that this target process is spreadsheet, originating process can be ready to the context of this target process when creating target process example, with and needed data, such as be exactly all kinds of list datas in excel.According to user, seize the report data in the 2-D data structure after also structuring like this, and by man-machine interaction definite form content and demonstration, utilize computing machine to generate the report file that this report form processing software is corresponding, due to what call, be general report form processing application process, so the report file generating has certain extensibility and versatility.
Step 5: call corresponding process software the form that generates and preserve is opened and presented to user, if necessary, by user, form is made to last polishing, modification preservation.
In addition to the implementation, the present invention can also have other embodiments.All employings are equal to the technical scheme of replacement or equivalent transformation formation, all drop on the protection domain of requirement of the present invention.
Claims (7)
1. an automatic generation method for conventional data form, is characterized in that: the automatic generation that realizes form needs following steps:
Step 1: seize report data from data source;
Step 2: data are carried out to structural description;
Step 3: option table table formateed data item as required;
Step 4: utilize inter-process communication techniques to call form of general use treatment progress, by the report data of seizing according to the list data item content generating report forms file of selecting.
2. the automatic generation method of conventional data form according to claim 1, is further characterized in that: the described report data step of seizing further comprises image data, and data are processed, and obtains the result data that need to show in form.
3. the automatic generation method of conventional data form according to claim 1, is further characterized in that: described step 2 to the structural description of data for data formation being there are to the two-dimensional structure data of form boat and row.
4. the automatic generation method of conventional data form according to claim 3, is further characterized in that: in described step 2, data are carried out to structural description and also comprise in data importing two-dimensional structure data.
5. the automatic generation method of conventional data form according to claim 1, is further characterized in that: described collection is that the message of data base querying or file polling or user-defined format sends.
6. the automatic generation method of conventional data form according to claim 2, is further characterized in that: described be processed as statistical calculation in form.
7. the automatic generation method of conventional data form according to claim 1, is further characterized in that: described selection form personal data item carries out with guide approach.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210296958.0A CN103631767A (en) | 2012-08-21 | 2012-08-21 | Automatic generation method of universal data report |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210296958.0A CN103631767A (en) | 2012-08-21 | 2012-08-21 | Automatic generation method of universal data report |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103631767A true CN103631767A (en) | 2014-03-12 |
Family
ID=50212844
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210296958.0A Pending CN103631767A (en) | 2012-08-21 | 2012-08-21 | Automatic generation method of universal data report |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103631767A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104715052A (en) * | 2015-03-27 | 2015-06-17 | 国家电网公司 | Method and system for generating statement |
| CN105786787A (en) * | 2016-02-29 | 2016-07-20 | 四川长虹电器股份有限公司 | Efficient PDF report form testing method based on Java |
| CN105808173A (en) * | 2014-12-31 | 2016-07-27 | 青岛中科软件股份有限公司 | General printing method based on winform software |
| CN109614098A (en) * | 2017-09-30 | 2019-04-12 | 北京国双科技有限公司 | The generation method and device of configuration interface |
| CN111401017A (en) * | 2020-03-11 | 2020-07-10 | 广联达科技股份有限公司 | Method and system for automatically generating list report |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1427363A (en) * | 2001-12-19 | 2003-07-02 | 深圳市中兴通讯股份有限公司上海第二研究所 | General report form generation method |
| US20090327851A1 (en) * | 2008-06-27 | 2009-12-31 | Steven Raposo | Data analysis method |
| CN102567539A (en) * | 2011-12-31 | 2012-07-11 | 北京新媒传信科技有限公司 | Intelligent WEB report implementation method and intelligent WEB report implementation system |
-
2012
- 2012-08-21 CN CN201210296958.0A patent/CN103631767A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1427363A (en) * | 2001-12-19 | 2003-07-02 | 深圳市中兴通讯股份有限公司上海第二研究所 | General report form generation method |
| US20090327851A1 (en) * | 2008-06-27 | 2009-12-31 | Steven Raposo | Data analysis method |
| CN102567539A (en) * | 2011-12-31 | 2012-07-11 | 北京新媒传信科技有限公司 | Intelligent WEB report implementation method and intelligent WEB report implementation system |
Non-Patent Citations (2)
| Title |
|---|
| 宋建松: "基于ole技术调用EXCEL实现复杂报表生成", 《内蒙古电大学刊》, no. 86, 31 October 2006 (2006-10-31), pages 40 - 41 * |
| 王兰春: "在PowerBuilder中通过OLE实现复杂的Excel报表", 《软件》, vol. 33, no. 5, 31 May 2012 (2012-05-31) * |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105808173A (en) * | 2014-12-31 | 2016-07-27 | 青岛中科软件股份有限公司 | General printing method based on winform software |
| CN104715052A (en) * | 2015-03-27 | 2015-06-17 | 国家电网公司 | Method and system for generating statement |
| CN104715052B (en) * | 2015-03-27 | 2018-08-28 | 国家电网公司 | Generate the method and its system of report |
| CN105786787A (en) * | 2016-02-29 | 2016-07-20 | 四川长虹电器股份有限公司 | Efficient PDF report form testing method based on Java |
| CN105786787B (en) * | 2016-02-29 | 2018-07-06 | 四川长虹电器股份有限公司 | Efficient PDF reports test method based on Java |
| CN109614098A (en) * | 2017-09-30 | 2019-04-12 | 北京国双科技有限公司 | The generation method and device of configuration interface |
| CN111401017A (en) * | 2020-03-11 | 2020-07-10 | 广联达科技股份有限公司 | Method and system for automatically generating list report |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN113094037B (en) | Interaction method, development platform, equipment and storage medium for forms and workflows | |
| CN104699803B (en) | XBR L report formulation method meeting multi-aperture report sending requirements | |
| US20120179644A1 (en) | Automatic Synthesis and Presentation of OLAP Cubes from Semantically Enriched Data Sources | |
| US20130173664A1 (en) | Mapping non-relational database objects into a relational database model | |
| CN110045953A (en) | Generate the method and computing device of business rule expression formula | |
| CN103631767A (en) | Automatic generation method of universal data report | |
| US20120331010A1 (en) | Systems And Methods For Performing A Query On A Distributed Database | |
| US10997784B2 (en) | Generating space models from map files | |
| MX2014004167A (en) | Automatic relationship detection for reporting on spreadsheet data. | |
| CN114119058B (en) | User portrait model construction method, device and storage medium | |
| CN1427363A (en) | General report form generation method | |
| US20130054627A1 (en) | Systems And Methods For Providing A Data Glossary Management System | |
| US20080104529A1 (en) | Draggable legends for sql driven graphs | |
| CN105574070A (en) | System and method for reporting multiple objects in enterprise content management | |
| CN110287459B (en) | Form batch processing method, system, device and storage medium | |
| US8413109B2 (en) | Systems and methods for metamodel transformation | |
| CN107291582A (en) | Intelligent integration method of testing based on standard big data | |
| CN109523418A (en) | Drawing acquisition methods, device, computer equipment and storage medium | |
| US20090164432A1 (en) | System and method for generating a product report | |
| CN114616558A (en) | Data visualization for generating multiple fact data sets with appropriate metric aggregation | |
| CN109360106A (en) | Portrait construction method, system, medium and computer system | |
| CN114270313A (en) | Computer-implemented method, computer program and physical computing environment | |
| CN102789488B (en) | Data query treatment system and data query processing method | |
| US8984455B1 (en) | Methods for generating schematic diagrams and apparatuses using the same | |
| Amin et al. | Evaluating large-scale biomedical ontology matching over parallel platforms |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20140312 |