CN103646049A - Method and system for automatically generating data report - Google Patents
Method and system for automatically generating data report Download PDFInfo
- Publication number
- CN103646049A CN103646049A CN201310612068.0A CN201310612068A CN103646049A CN 103646049 A CN103646049 A CN 103646049A CN 201310612068 A CN201310612068 A CN 201310612068A CN 103646049 A CN103646049 A CN 103646049A
- Authority
- CN
- China
- Prior art keywords
- data
- data item
- parameter
- resolve
- sheet
- 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.)
- Granted
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a method and a system for automatically generating a data report. The method includes the steps: connecting a database, receiving an input parameter and judging whether the data report is outputted or not; opening a database file if the data report is outputted, and analyzing parameters of data items; splicing the data items of query results of the data report to form a data access character string comprising all data items in the data report according to analysis results of the parameters of the data items; dynamically configuring query for the data report according to the query results of the data items, time slots and ordering statements of the data items; calling processing program sections of the data report according to values of the data items of the configured query results to generate the corresponding data report. By the method, the efficiency of generating the data report by users can be greatly improved, and automation and standardized implementation of the data report are facilitated, so that the data report has a certain universality and expandability.
Description
Technical field
The present invention relates to a kind of method and system of data processing, particularly a kind of method and system that can automatically generated data form.
Background technology
In technical field of data processing, data sheet offers with the form of form the data that user is concerned about, and some analysis results that produce for these data.The features such as statement form has concisely with respect to other data provide form, directly perceived and standard, are widely used in all trades and professions.But because all trades and professions are inconsistent for the call format of form, content for form requires also inconsistent, and the pattern of the data item such as title of form, gauge outfit, table tail is also varied, at present in many existing methods, all to generate specific form for a certain series products, the form of form is relatively fixing, message format disunity after generating like this, and its pattern and desired data item also differ and reach surely the form of user's expectation, cannot meet the various needs of user, 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, or user's demand changes, just need update software source code, can not for interface user, directly use in time, and the work cost of modification source code is larger, safeguards inconvenient.Have, at present a lot of system inventory class forms all take the mode of writing batch program to realize again, and each form needs a corresponding batch program, and corresponding design, realization, test etc. are extremely similar, and the simple duplication of labour is more.
Summary of the invention
The object of the invention is to propose a kind of method and system of automatically generated data form, it can utilize the mode of man-machine interaction and the technology of interprocess communication to realize the automatic generation of data sheet.
In order to realize foregoing invention object, the present invention proposes following technical scheme:
An automatically generated data report method, the method comprises the following steps:
Step (1): connection data storehouse, receive input parameter, judge whether to export data sheet;
Step (2): if be judged as output data sheet, open database file, data item parameter is resolved;
Step (3): according to the analysis result to described data item parameter, the Query Result data item of described data sheet is spliced into data access character string, the all data item of described data access character string in described data sheet form, wherein said data item comprises display data item and visit data item, the value rule that configures described display data item is: static strings and demonstration displacement, and the value rule that configures described visit data item is: position and the length of described visit data item in data access character string;
Step (4): the inquiry of described data sheet is dynamically configured as described data item Query Result, time period and described data item an ordering statement;
Step (5): according to the described Query Result data item occurrence of configuration, calling data report processor section, generates corresponding data sheet.
More specifically, step judges whether to export data sheet described in (1), be according to major key reading out data database data, obtains that working day, information judged, information comprised and gathered sign, date described working day;
In step (2), resolution data item parameter comprises: resolve index mechanism, resolve subtitle, resolve subfield and add up to parameter, resolve and amount to parameter, resolve currency, resolve the hurdle condition that adds up to, resolve subfield condition, resolve title block, resolution data field data item parameter, resolution data item an ordering statement, the parsing time;
In step (4), to the inquiry of described data sheet, be SQL query statement;
Described in step (5), according to the described Query Result data item occurrence of configuration, calling data report processor section, generates corresponding data sheet, specifically comprises the following steps:
Set up pointer, open pointer,
Loop initialization variable, statistical variable, arrange circulation sign first, end sign, page initial marking, empty file sign, add up to/total temporary variable group;
According to the described page initial marking of configuration, the operation of whether skipping, exports data sheet title if skip, and empties aggregation condition character string,
According to the total field mark of configuration, know and parameter, if meet aggregation condition, carry out the total of the amount of money, numeral, output adds up to hurdle,
According to displacement, the length information in the described data access character string of configuration, by the content in described data access character string, split in the row of data sheet, write a line item,
According to the total field mark of configuration, know and parameter, output amounts to hurdle,
Generate corresponding data sheet.
The present invention also provides a kind of system of automatically generated data form, and this system comprises with lower module:
Connection data library module, connection data storehouse, receives input parameter, judges whether to export data sheet;
Parameter analysis of electrochemical module, if judgement output data sheet is opened database file, resolves data item parameter;
Configuration data access character string module, according to the analysis result to described data item parameter, the Query Result data item of described data sheet is spliced into data access character string, the all data item of described data access character string in described data sheet form, wherein said data item comprises display data item and visit data item, the value rule that configures described display data item is: static strings and demonstration displacement, and the value rule that configures described visit data item is: position and the length of described visit data item in data access character string;
Enquiry module, is dynamically configured as described data item Query Result, time period and described data item an ordering statement the inquiry of described data sheet;
Data sheet generation module, the data item occurrence according to the described data sheet of configuration, utilizes inter-process communication techniques, and calling data report form processing process, generates corresponding data sheet.
More specifically, in this system:
In connection data library module, described in judge whether to export data sheet, be according to major key reading out data database data, obtain that working day, information judged, information comprised and gathered sign, date described working day;
In Parameter analysis of electrochemical module, resolution data item parameter comprises: resolve index mechanism, resolve subtitle, resolve subfield and add up to parameter, resolve and amount to parameter, resolve currency, resolve the hurdle condition that adds up to, resolve subfield condition, resolve title block, resolution data field data item parameter, resolution data item an ordering statement, parsing time;
In enquiry module, to the inquiry of described data sheet, be SQL query statement;
In data sheet generation module, described according to the described Query Result data item occurrence of configuration, calling data report processor section, generates corresponding data sheet, specifically comprises following module:
Pointer module, sets up pointer, opens pointer,
Initialization module, loop initialization variable, statistical variable, arrange circulation sign first, end sign, page initial marking, empty file sign, add up to/total temporary variable group;
The operational module that skips, according to the described page initial marking of configuration, the operation of whether skipping, exports data sheet title if skip, and empties aggregation condition character string,
Add up to hurdle operational module, according to the total field mark of configuration, know and parameter, if meet aggregation condition, carry out the total of the amount of money, numeral, output adds up to hurdle,
Data recordin module, according to displacement, the length information of configuration, by the content in described data access character string, splits in the row of data sheet, writes a line item,
Amount to hurdle operational module, according to the total field mark of configuration, know and parameter, output amounts to hurdle,
Generation module, generates corresponding data sheet.
Known according to the analysis of technique scheme, use the method for automatically generated data form in the present invention compared with prior art, there is following useful technique effect:
1, greatly improved the efficiency of user's generating report forms, the robotization and the standardization that are conducive to form are implemented;
2, the use of man-machine interaction mode, has increased dirigibility and the usability of form greatly, makes report data item to carry out Dynamic Selection according to user's request, and needn't revise source code;
3, owing to adopting the mode that receives input parameter to generate data sheet, make final data form there is certain Universal and scalability.
Accompanying drawing explanation
Fig. 1 is the process flow diagram of automatically generated data report method of the present invention.
Fig. 2 is the program flow diagram of one embodiment of the present of invention.
Fig. 3 is the block diagram of automatically generated data reporting system of the present invention.
Embodiment
Below in conjunction with the drawings and specific embodiments, the present invention is described in further detail, but not as a limitation of the invention.
The present invention's topmost improvement is compared with prior art, SQL statement result is spliced into " data access character string ".The information of needs is divided into two large classes, the first kind is visit data item, comprise the value rules such as form row, subtitle, the condition of skipping, these value rules are all maintained into the corresponding field of Report Customization parameter list, for the value rule of its configuration is: the position+field length of each field in data access character string, so just can, by getting the mode of substring wherein, obtain the data value needing.Equations of The Second Kind is display data item, comprises the fixing character string of printing of the needs such as statement heading, is configured to the mode of static strings+demonstration displacement.Master routine by reading this two category information from " data access character string " and configuration parameter, just can splice that report data is capable, title, subtitle, title bar etc., also can judge and whether skip, whether need to carry out subtotal, when add up to etc., thereby generate satisfactory form.
Referring to Fig. 1, be the process flow diagram of automatically generated data report method of the present invention, the execution of this process flow diagram is on the basis of the data source of having set up, and this data source can utilize the Universal Databases such as Oracle to set up, and the method comprises the following steps:
Step (1): connection data storehouse, receive input parameter, judge whether to export data sheet;
Step (2): if be judged as output data sheet, open database file, data item parameter is resolved;
Step (3 :) is according to the analysis result to described data item parameter, the Query Result data item of described data sheet is spliced into data access character string, the all data item of described data access character string in described data sheet form, wherein said data item comprises display data item and visit data item, the value rule that configures described display data item is: static strings and demonstration displacement, and the value rule that configures described visit data item is: position and the length of described visit data item in data access character string;
Step (4): the inquiry of described data sheet is dynamically configured as described data item Query Result, time period and described data item an ordering statement;
Step (5): according to the described Query Result data item occurrence of configuration, calling data report processor section, generates corresponding data sheet.
Referring to Fig. 2, it is the program flow diagram of one embodiment of the present of invention.This program circuit is based on little machine, CICS, and the technology such as COBOL and ORACLE realize.The data sheet of banking industry of take is example, has data item and the list item of a large amount of very complicateds in banking industry data, in order rapid and convenient effectively to generate needed data sheet, carries out following steps:
Connection data storehouse, this database can be the databases such as Oracle, receive input data parameters, parameters such as the province's line number in bank and report number, according to major key, read NSTRPP table data, read SYS table, obtain information on working day, according to gathering sign, date, judge whether to export data sheet.
If be judged as this data sheet of output, open exported database file, data item parameter is wherein resolved, in banking industry, the following parameter of General Analytical:
Resolve index mechanism: RPP-TXNORG;
Resolve subtitle: RPP-RPTPNM;
Resolve subfield and add up to parameter: RPP-RPTSTA;
Resolve and amount to parameter: RPP-RPTTTA;
Resolve currency: RPP-RPTCTC;
Resolve and add up to hurdle condition: RPP-RPTSTC;
Resolve paging hurdle condition: RPP-RPTPTC;
Resolve title block: RPP-RPTTAL;
Resolution data field data item parameter: RPP-RPTFTA;
Resolve SQL an ordering statement: RPP-SQLORD;
Parsing time: RPP-SQLTWR, the determining time.
Next, according to the analysis result to described data item parameter, the Query Result data item of described data sheet is spliced into data access character string, the all data item of described data access character string in described data sheet form, wherein said data item comprises display data item and visit data item, the value rule that configures described display data item is: static strings and demonstration displacement, the value rule that configures described visit data item is: position and the length of described visit data item in data access character string.
Then, the inquiry of described data sheet is dynamically configured as described data item Query Result+time period+described data item an ordering statement; This inquiry can be dynamic SQL statements: RPP-RPTSQL+ time period+an ordering statement, set up CURSOR, and OPEN CURSOR, loop initialization variable, statistical variable:
Circulation sign first: Y;
Finish sign: N;
Page initial marking: Y;
Empty file sign: N;
Add up to/amount to temporary variable data: 0.
Next, according to the described Query Result data item occurrence of configuration, calling data report processor section, master routine is by reading these information, just can splice that report data is capable, title, subtitle, title bar etc., also can judge and whether skip, whether need to carry out subtotal, when add up to etc., thereby generate the form that meets production requirement.
Or take banking industry data sheet as example, the specific procedure flow process of above-mentioned steps is:
Does is i) judgement end sign Y? if so, forward step xii to);
Ii) loop body FETCH CURSOR;
Does iii) judgement record exist? if exist, forward step v to)
Iv) determine whether to circulate for the first time? if yes, end sign is set to Y, empty file sign is set to Y, and circulation sign is first set to N, forwards step I to simultaneously); If NO, end sign is set to Y, circulation sign is first set to N, forwards step I to simultaneously);
V) new line in " data access character string " is replaced with to space, the control of skipping;
Vi) judge whether that page is full, if page is full, page initial marking is set to Y, empty aggregation condition character string simultaneously, then forward step vii to); If page less than, directly forward step vii to);
Vii) according to the condition of the skipping judgement of skipping, if do not satisfy condition, exit the control of skipping, the renewal condition temporary variable of skipping, is set to Y by page initial marking simultaneously, and empties aggregation condition character string;
Viii) add up to hurdle to process, if configured total hurdle, and meet aggregation condition, print and add up to hurdle;
Ix), if page initial marking is Y, printing reports title, according to the total sign of configuration, carries out the total of the amount of money, numeral;
X) according to information such as the displacement of configuration, length, by the content in " data access character string ", split in report line, write a line item;
Xi) sign that will circulate is first set to N, and a page initial marking is set to N, and forwards step I to);
Xii) close CURSOR, judge whether empty file sign is Y, if not, print and add up to hurdle, if configured total parameter, print and amount to hurdle, forward step xiii to); If so, directly forward step xiii to);
Xiii) closing output file, process ends.
More concrete, or take banking industry data sheet as example, below enumerated the essential information of data sheet, and a record of safeguarding at CDTRPP table:
1) form essential information:
Report name: manual handle inventory (site)
Report number: NSBD6023
Gather sign: daily paper
2) CDTRPP table has been safeguarded as next record:
(note: RPTSQL field has increased new line for ease of showing, during actual disposition, SQL statement should be maintained as a line)
Fig. 3 is the block diagram of the system of automatically generated data form of the present invention.This system comprises with lower module:
Connection data library module, connection data storehouse, receives input data parameters, judges whether to export data sheet;
Parameter analysis of electrochemical module, if the described data sheet of judgement output is opened output file, resolves data item parameter;
Organising data access character string module, according to the analysis result to described data item parameter, the Query Result data item of described data sheet is spliced into data access character string, the all data item of described data access character string in described data sheet form, wherein said row comprise display data item and visit data item, the value rule that configures described display data item is: static strings and demonstration displacement, and the value rule that configures described visit data item is: position and the length of each field in data access character string;
Data sheet generation module, according to the data item occurrence of the described data sheet of configuration, calling data report processor section, generates corresponding data sheet.
More specifically, the banking industry data sheet automatic creation system of take is example, also comprises following content in this system:
In connection data library module, described in judge whether to export data sheet, be according to major key reading out data database data, obtain information on working day, information comprised and gathered sign, date described working day;
In Parameter analysis of electrochemical module, resolution data item parameter comprises: resolve index mechanism, resolve subtitle, resolve subfield and add up to parameter, resolve and amount to parameter, resolve currency, resolve the hurdle condition that adds up to, resolve subfield condition, resolve title block, resolution data field data item parameter, resolution data item an ordering statement, parsing time;
In organising data access character string module, described data sheet desired data item is organized as dynamically: described data item selection result+time period+described data item an ordering statement,
In data sheet generation module, describedly according to the data item occurrence of described data sheet of configuration, utilize inter-process communication techniques, calling data report form processing process, generates corresponding data sheet, specifically comprises following module:
Pointer module, sets up pointer, opens pointer,
Initialization module, loop initialization variable, statistical variable, arrange circulation sign first, end sign, page initial marking, empty file sign, add up to/total temporary variable group;
The operational module that skips, according to the described page initial marking of configuration, the operation of whether skipping, exports data sheet title if skip, and empties aggregation condition character string,
Add up to hurdle operational module, according to the total field mark of configuration, know and parameter, if meet aggregation condition, carry out the total of the amount of money, numeral, output adds up to hurdle,
Data recordin module, according to displacement, the length information of configuration, by the content in described data access character string, splits in the row of data sheet, writes a line item,
Amount to hurdle operational module, according to the total field mark of configuration, know and parameter, output amounts to hurdle,
Generation module, generates corresponding data sheet.
Method and system of the present invention can be applied to every field and industry, especially can be applied in financial relevant industries, such as bank, security, supplementary pension etc.Take banking as example, in banking, have mass data record, conventionally need to, for several ten thousand hundreds of thousands bar records even, according to the different attribute of the different field of each record, carry out calculation process.The method and system of automatically generated data form of the present invention can generate needed data sheet automatically for similar data processing, has greatly improved data processing speed and quality.
Obviously, those skilled in the art should be understood that, each step and modules that above-mentioned present techniques is put in case can be realized with general calculation element, and they can concentrate on single calculation element, or are distributed on the network that a plurality of calculation elements form.Alternatively, they can be realized with the executable program code of calculation element, thereby, they can be stored in memory storage and be carried out by calculation element, and in some cases, can carry out shown or described step with the order being different from herein, or they are made into respectively to each integrated circuit modules, or a plurality of modules in them or step are made into single integrated circuit module realize.Like this, the application is not limited to any specific hardware and software combination.
The foregoing is only the application's preferred embodiment, to those skilled in the art, the application can have various modifications and variations.Within all inventions in the application spirit and principle, any modification of making, be equal to replacement, improvement etc., within all should being included in the application's protection domain.
Claims (4)
1. an automatically generated data report method, is characterized in that, the method comprises the following steps:
Step (1): connection data storehouse, receive input parameter, judge whether to export data sheet;
Step (2): if be judged as output data sheet, open database file, data item parameter is resolved;
Step (3): according to the analysis result to described data item parameter, the Query Result data item of described data sheet is spliced into data access character string, the all data item of described data access character string in described data sheet form, wherein said data item comprises display data item and visit data item, the value rule that configures described display data item is: static strings and demonstration displacement, and the value rule that configures described visit data item is: position and the length of described visit data item in data access character string;
Step (4): the inquiry of described data sheet is dynamically configured as described data item Query Result, time period and described data item an ordering statement;
Step (5): according to the described Query Result data item occurrence of configuration, calling data report processor section, generates corresponding data sheet.
2. method according to claim 1, is characterized in that,
Step judges whether to export data sheet described in (1), be according to major key reading out data database data, obtains that working day, information judged, information comprised and gathered sign, date described working day;
In step (2), resolution data item parameter comprises: resolve index mechanism, resolve subtitle, resolve subfield and add up to parameter, resolve and amount to parameter, resolve currency, resolve the hurdle condition that adds up to, resolve subfield condition, resolve title block, resolution data field data item parameter, resolution data item an ordering statement, the parsing time;
In step (4), to the inquiry of described data sheet, be SQL query statement;
Described in step (5), according to the described Query Result data item occurrence of configuration, calling data report processor section, generates corresponding data sheet, specifically comprises the following steps:
Set up pointer, open pointer;
Loop initialization variable, statistical variable, arrange circulation sign first, end sign, page initial marking, empty file sign, add up to/total temporary variable group;
According to the described page initial marking of configuration, the operation of whether skipping, exports data sheet title if skip, and empties aggregation condition character string;
According to the total field mark of configuration, know and parameter, if meet aggregation condition, carry out the total of the amount of money, numeral, output adds up to hurdle;
According to displacement, the length information in the described data access character string of configuration, by the content in described data access character string, split in the row of data sheet, write a line item;
According to the total field mark of configuration, know and parameter, output amounts to hurdle;
Generate corresponding data sheet.
3. a system for automatically generated data form, is characterized in that, this system comprises with lower module:
Connection data library module, connection data storehouse, receives input parameter, judges whether to export data sheet;
Parameter analysis of electrochemical module, if be judged as output data sheet, opens database file, and data item parameter is resolved;
Configuration data access character string module, according to the analysis result to described data item parameter, the Query Result data item of described data sheet is spliced into data access character string, the all data item of described data access character string in described data sheet form, wherein said data item comprises display data item and visit data item, the value rule that configures described display data item is: static strings and demonstration displacement, and the value rule that configures described visit data item is: position and the length of described visit data item in data access character string;
Enquiry module, is dynamically configured as described data item Query Result, time period and described data item an ordering statement the inquiry of described data sheet;
Data sheet generation module, the data item occurrence according to the described data sheet of configuration, utilizes inter-process communication techniques, and calling data report form processing process, generates corresponding data sheet.
4. system according to claim 3, is characterized in that, in connection data library module, describedly judge whether to export data sheet, be according to major key reading out data database data, obtain that working day, information judged, information comprised and gathered sign, date described working day;
In Parameter analysis of electrochemical module, resolution data item parameter comprises: resolve index mechanism, resolve subtitle, resolve subfield and add up to parameter, resolve and amount to parameter, resolve currency, resolve the hurdle condition that adds up to, resolve subfield condition, resolve title block, resolution data field data item parameter, resolution data item an ordering statement, parsing time;
In enquiry module, to the inquiry of described data sheet, be SQL query statement;
In data sheet generation module, described according to the described Query Result data item occurrence of configuration, calling data report processor section, generates corresponding data sheet, specifically comprises following module:
Pointer module, sets up pointer, opens pointer;
Initialization module, loop initialization variable, statistical variable, arrange circulation sign first, end sign, page initial marking, empty file sign, add up to/total temporary variable group;
The operational module that skips, according to the described page initial marking of configuration, the operation of whether skipping, exports data sheet title if skip, and empties aggregation condition character string;
Add up to hurdle operational module, according to the total field mark of configuration, know and parameter, if meet aggregation condition, carry out the total of the amount of money, numeral, output adds up to hurdle;
Data recordin module, according to displacement, the length information of configuration, by the content in described data access character string, splits in the row of data sheet, writes a line item;
Amount to hurdle operational module, according to the total field mark of configuration, know and parameter, output amounts to hurdle;
Generation module, generates corresponding data sheet.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310612068.0A CN103646049B (en) | 2013-11-26 | 2013-11-26 | The method and system of automatically generated data form |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310612068.0A CN103646049B (en) | 2013-11-26 | 2013-11-26 | The method and system of automatically generated data form |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN103646049A true CN103646049A (en) | 2014-03-19 |
| CN103646049B CN103646049B (en) | 2016-08-17 |
Family
ID=50251263
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310612068.0A Active CN103646049B (en) | 2013-11-26 | 2013-11-26 | The method and system of automatically generated data form |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103646049B (en) |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104036007A (en) * | 2014-06-23 | 2014-09-10 | 北京京东尚科信息技术有限公司 | Method and device for querying distributed databases |
| CN105022628A (en) * | 2015-06-04 | 2015-11-04 | 北京宏远贵德科技有限公司 | Extendable software application platform |
| CN105100025A (en) * | 2014-05-22 | 2015-11-25 | 中兴通讯股份有限公司 | Service distribution method and service distribution system |
| CN105760492A (en) * | 2016-02-18 | 2016-07-13 | 广东睿江云计算股份有限公司 | Data analysis method and device |
| CN106681287A (en) * | 2016-12-06 | 2017-05-17 | 中冶南方（武汉）信息技术工程有限公司 | Method and system for collecting heating furnace DSC data |
| CN108021588A (en) * | 2016-10-28 | 2018-05-11 | 北京京东尚科信息技术有限公司 | A kind of user of Electronic Commerce purchases data integration method and device first |
| CN109933769A (en) * | 2019-03-19 | 2019-06-25 | 浪潮通用软件有限公司 | A kind of report data fast resolving method based on Excel |
| CN110335654A (en) * | 2019-07-03 | 2019-10-15 | 重庆邮电大学 | A kind of information extraction method of electronic health record, system and computer equipment |
| CN111158650A (en) * | 2019-12-25 | 2020-05-15 | 中国建设银行股份有限公司 | Report template, report template and report generation method and device |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1427363A (en) * | 2001-12-19 | 2003-07-02 | 深圳市中兴通讯股份有限公司上海第二研究所 | General report form generation method |
| CN101004758A (en) * | 2007-01-26 | 2007-07-25 | 华为技术有限公司 | Method and corresponding system for creating and obtaining report forms |
| US20120173441A1 (en) * | 2011-01-05 | 2012-07-05 | Google Inc. | Ownership Resolution System |
| CN102810094A (en) * | 2011-05-31 | 2012-12-05 | 中兴通讯股份有限公司 | Report generation method and device |
| CN103034681A (en) * | 2012-11-22 | 2013-04-10 | 用友软件股份有限公司 | Report generation device and report generation method |
| US20130197953A1 (en) * | 2012-01-31 | 2013-08-01 | Oracle International Corporation | Method and system for implementing user reporting |
-
2013
- 2013-11-26 CN CN201310612068.0A patent/CN103646049B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1427363A (en) * | 2001-12-19 | 2003-07-02 | 深圳市中兴通讯股份有限公司上海第二研究所 | General report form generation method |
| CN101004758A (en) * | 2007-01-26 | 2007-07-25 | 华为技术有限公司 | Method and corresponding system for creating and obtaining report forms |
| US20120173441A1 (en) * | 2011-01-05 | 2012-07-05 | Google Inc. | Ownership Resolution System |
| CN102810094A (en) * | 2011-05-31 | 2012-12-05 | 中兴通讯股份有限公司 | Report generation method and device |
| US20130197953A1 (en) * | 2012-01-31 | 2013-08-01 | Oracle International Corporation | Method and system for implementing user reporting |
| CN103034681A (en) * | 2012-11-22 | 2013-04-10 | 用友软件股份有限公司 | Report generation device and report generation method |
Non-Patent Citations (2)
| Title |
|---|
| 张立忠等: "DWT网页模板在Web报表生成中的应用", 《计算机应用与软件》 * |
| 李兴勇等: "复杂报表生成系统实现技术研究", 《计算机应用》 * |
Cited By (13)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105100025A (en) * | 2014-05-22 | 2015-11-25 | 中兴通讯股份有限公司 | Service distribution method and service distribution system |
| CN104036007B (en) * | 2014-06-23 | 2017-12-12 | 北京京东尚科信息技术有限公司 | A kind of distributed networks database query method and device |
| CN104036007A (en) * | 2014-06-23 | 2014-09-10 | 北京京东尚科信息技术有限公司 | Method and device for querying distributed databases |
| CN105022628B (en) * | 2015-06-04 | 2018-09-18 | 北京宏远贵德科技有限公司 | A kind of expansible software application platform |
| CN105022628A (en) * | 2015-06-04 | 2015-11-04 | 北京宏远贵德科技有限公司 | Extendable software application platform |
| CN105760492A (en) * | 2016-02-18 | 2016-07-13 | 广东睿江云计算股份有限公司 | Data analysis method and device |
| CN105760492B (en) * | 2016-02-18 | 2019-10-15 | 广东睿江云计算股份有限公司 | Data analysing method and device |
| CN108021588A (en) * | 2016-10-28 | 2018-05-11 | 北京京东尚科信息技术有限公司 | A kind of user of Electronic Commerce purchases data integration method and device first |
| CN106681287A (en) * | 2016-12-06 | 2017-05-17 | 中冶南方（武汉）信息技术工程有限公司 | Method and system for collecting heating furnace DSC data |
| CN109933769A (en) * | 2019-03-19 | 2019-06-25 | 浪潮通用软件有限公司 | A kind of report data fast resolving method based on Excel |
| CN110335654A (en) * | 2019-07-03 | 2019-10-15 | 重庆邮电大学 | A kind of information extraction method of electronic health record, system and computer equipment |
| CN111158650A (en) * | 2019-12-25 | 2020-05-15 | 中国建设银行股份有限公司 | Report template, report template and report generation method and device |
| CN111158650B (en) * | 2019-12-25 | 2023-06-27 | 中国建设银行股份有限公司 | Report template and report generation method and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN103646049B (en) | 2016-08-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103646049A (en) | Method and system for automatically generating data report | |
| US20230161955A1 (en) | Database model which provides management of custom fields and methods and apparatus therfor | |
| US11755606B2 (en) | Dynamically updated data sheets using row links | |
| US9811604B2 (en) | Method and system for defining an extension taxonomy | |
| US7216340B1 (en) | Analysis data validation tool for use in enterprise architecture modeling with result based model updating | |
| Kamimura et al. | Extracting candidates of microservices from monolithic application code | |
| US10845962B2 (en) | Specifying user interface elements | |
| US7424702B1 (en) | Data integration techniques for use in enterprise architecture modeling | |
| US12079568B2 (en) | Domain-specific language interpreter and interactive visual interface for rapid screening | |
| US7752597B2 (en) | Layered software development and implementation using files | |
| CN103810196A (en) | Method for testing performance of database on basis of business model | |
| CN102067106A (en) | Data quality tracking by determining metric values for child nodes and a parent node | |
| CN102810057A (en) | Log recording method | |
| CN109783346B (en) | Keyword-driven automatic testing method and device and terminal equipment | |
| US11947567B2 (en) | System and method for computing and managing datasets using hierarchical analytics | |
| KR100538547B1 (en) | Data retrieval method and apparatus with multiple source capability | |
| CN101901262A (en) | Object-oriented model-based enterprise database construction and service data display method | |
| US20030110175A1 (en) | Deploying predefined data warehouse process models | |
| US20050216501A1 (en) | System and method of providing and utilizing an object schema to facilitate mapping between disparate domains | |
| CN114168565B (en) | Backtracking test method, device and system of business rule model and decision engine | |
| US20220245125A1 (en) | Dataset multiplexer for data processing system | |
| CN113687827B (en) | Data list generation method, device and equipment based on widget and storage medium | |
| CN104123104B (en) | Daily record control system and method | |
| WO2021240370A1 (en) | Domain-specific language interpreter and interactive visual interface for rapid screening | |
| Zhao | User manual for povmap |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |