CN105138504A - Report generation method and report engine - Google Patents
Report generation method and report engine Download PDFInfo
- Publication number
- CN105138504A CN105138504A CN201510563784.3A CN201510563784A CN105138504A CN 105138504 A CN105138504 A CN 105138504A CN 201510563784 A CN201510563784 A CN 201510563784A CN 105138504 A CN105138504 A CN 105138504A
- Authority
- CN
- China
- Prior art keywords
- data
- report
- cell
- form cell
- filled
- 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 embodiment of the invention provides a report generation method and a report engine. The report generation method includes the steps that a report generation request submitted by a user is received and includes a report type; according to report types corresponding to all preset report templates, the report template corresponding to the report type is extracted; the report template comprises multiple report cells for filling data, and the report cells are provided with data identification and a data processing format of the filled data; for all the report cells, corresponding data are extracted from a data source according to the set data identification of the report cells, and the report cells are filled with the extracted data; the filled data are processed according to the set data processing format of the report cells to generate a report; the generated report is fed back to the user. By means of the report generation method, the report can be automatically generated, the workload related to report generation is reduced, and the management function of the report engine is completed.
Description
Technical field
The present invention relates to report form processing technical field, be specifically related to a kind of report form generation method and Report Engine.
Background technology
Form can, by the form such as form, chart display data, be applied wider under the scene such as data statistics, report; Report generation refers to data form being needed display, is packed into the process of report form template, various informative due to form, also there is diversified report form template at present.
Report form template primarily of Report Engine (Report Engine can form server exist) management, when user wishes generating report forms, can to the corresponding report form template of Report Engine request, data stuffing enters in asked report form template by user again; Can find out, Report Engine mainly supports the storage administration of report form template at present, and the generative process of form is main still based on the operation of user's padding data, and Report Engine also cannot support the automatic generation to form.
Based on this, existing report generation process Problems existing is: the management function of Report Engine imperfection, and cannot realize the automatic generation of form, the workload causing report generation to relate to is larger.
Summary of the invention
In view of this, the embodiment of the present invention provides a kind of report form generation method and Report Engine, to improve the management function of Report Engine, realizes the automatic generation of form, reduces the workload that report generation relates to.
For achieving the above object, the embodiment of the present invention provides following technical scheme:
A kind of report form generation method, comprising:
Receive the report generation request that user submits to, described report generation request comprises report form type;
The report form type corresponding according to preset each report form template, extracts the corresponding report form template of described report form type; Described report form template comprises the form cell of multiple padding data, and form cell arranges Data Identification and the data processing form of padding data to some extent;
For each form cell, from data source, extract corresponding data according to the Data Identification that described form cell is arranged, and be packed into described form cell;
According to the data processing form that described form cell is arranged, the data of described filling are processed, generating report forms;
Generated form is fed back to described user.
Wherein, described data source stores data to be filled and Data Identification corresponding to data to be filled;
The described Data Identification arranged according to described form cell extracts corresponding data and comprises from described data source:
According to the Data Identification that described form cell is arranged, from described data source, extract the to be filled data corresponding with described Data Identification, the data to be filled extracted are the data being packed into described form cell.
Wherein, described report generation request also comprises: the information of instruction generating report forms data source used; Described data source is corresponding to the information of described instruction generating report forms data source used.
Wherein, described data processing form comprises: data conversion format;
The described data processing form arranged according to described form cell, carries out process to the data of described filling and comprises:
According to the data conversion format that described form cell is arranged, the data of described filling are carried out to the conversion of data layout.
Wherein, described data processing form comprises: function formula;
The described data processing form arranged according to described form cell, carries out process to the data of described filling and comprises:
According to the function formula that described form cell is arranged, functional operation is carried out to the data of described filling.
The embodiment of the present invention also provides a kind of Report Engine, comprising:
Request receiving module, for receiving the report generation request that user submits to, described report generation request comprises report form type;
Report form template extraction module, for the report form type that each report form template according to preset is corresponding, extracts the corresponding report form template of described report form type; Described report form template comprises the form cell of multiple padding data, and form cell arranges Data Identification and the data processing form of padding data to some extent;
Data stuffing module, for for each form cell, extracts corresponding data according to the Data Identification that described form cell is arranged, and is packed into described form cell from data source;
Data processing module, for the data processing form arranged according to described form cell, processes the data of described filling, generating report forms;
Form feedback module, for feeding back to described user by generated form.
Wherein, described data source stores data to be filled and Data Identification corresponding to data to be filled;
Described data stuffing module comprises:
Data determination unit to be filled, for the Data Identification arranged according to described form cell, from described data source, extract the to be filled data corresponding with described Data Identification, the data to be filled extracted are the data being packed into described form cell.
Wherein, described report generation request also comprises: the information of instruction generating report forms data source used;
Described Report Engine also comprises:
Data source determination module, for determining the data source corresponding to the information of described instruction generating report forms data source used.
Wherein, described data processing form comprises: data conversion format;
Described data processing module comprises:
Format conversion unit, for the data conversion format arranged according to described form cell, carries out the conversion of data layout to the data of described filling.
Wherein, described data processing form comprises: function formula;
Described data processing module comprises:
Function arithmetic unit, for the function formula arranged according to described form cell, carries out functional operation to the data of described filling.
Based on technique scheme, the report form generation method that the embodiment of the present invention provides, comprising: receive the report generation request that user submits to, described report generation request comprises report form type; The report form type corresponding according to preset each report form template, extracts the corresponding report form template of described report form type, and described report form template comprises the form cell of multiple padding data, and form cell arranges Data Identification and the data processing form of padding data to some extent; For each form cell, from data source, extract corresponding data according to the Data Identification that described form cell is arranged, and be packed into described form cell; According to the data processing form that described form cell is arranged, the data of described filling are processed, generating report forms; Generated form is fed back to described user.Can find out, the form cell that the embodiment of the present invention is report form template arranges Data Identification and the data processing form of institute's padding data, by the Data Identification that form cell is arranged, corresponding data can be extracted from data source, realize data automatically inserting to report form template, the data processing form arranged by form cell, the automatic process of form cell institute padding data can be realized, complete the process of automatic filling data and automatic data processing in report form template, realize the automatic generation of form; Due to the report form generation method that the embodiment of the present invention provides, the automatic generation of form can be realized, therefore can reduce the workload that report generation relates to, and improve the management function of Report Engine.
Accompanying drawing explanation
In order to be illustrated more clearly in the embodiment of the present invention or technical scheme of the prior art, be briefly described to the accompanying drawing used required in embodiment or description of the prior art below, apparently, accompanying drawing in the following describes is only embodiments of the invention, for those of ordinary skill in the art, under the prerequisite not paying creative work, other accompanying drawing can also be obtained according to the accompanying drawing provided.
The process flow diagram of the report form generation method that Fig. 1 provides for the embodiment of the present invention;
The schematic diagram of form cell in the report form template that Fig. 2 provides for the embodiment of the present invention;
Another process flow diagram of the report form generation method that Fig. 3 provides for the embodiment of the present invention;
A process flow diagram again of the report form generation method that Fig. 4 provides for the embodiment of the present invention;
The another process flow diagram of the report form generation method that Fig. 5 provides for the embodiment of the present invention;
The structured flowchart of the Report Engine that Fig. 6 provides for the embodiment of the present invention;
The structured flowchart of the data stuffing module that Fig. 7 provides for the embodiment of the present invention;
Another structured flowchart of the Report Engine that Fig. 8 provides for the embodiment of the present invention;
The structured flowchart of the data processing module that Fig. 9 provides for the embodiment of the present invention;
Another structured flowchart of the data processing module that Figure 10 provides for the embodiment of the present invention;
The structured flowchart of the form feedback module that Figure 11 provides for the embodiment of the present invention.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, be clearly and completely described the technical scheme in the embodiment of the present invention, obviously, described embodiment is only the present invention's part embodiment, instead of whole embodiments.Based on the embodiment in the present invention, those of ordinary skill in the art, not making the every other embodiment obtained under creative work prerequisite, belong to the scope of protection of the invention.
The process flow diagram of the report form generation method that Fig. 1 provides for the embodiment of the present invention, the method can be applicable in Report Engine, can be arranged in server in Report Engine; In embodiments of the present invention, Report Engine can receive the report generation request that user submits to, and based on described report generation request, Report Engine can generate corresponding form automatically, and form is fed back to user, thus promotes the management function of Report Engine; The process of Report Engine automatic report generation can be as shown in Figure 1;
With reference to Fig. 1, the report form generation method that the embodiment of the present invention provides can comprise the steps:
The report generation request that step S100, reception user submit to, described report generation request comprises report form type;
Optionally, the embodiment of the present invention can provide report generation interface, and this report generation interface can be arranged in client, by user operation report generation interface, realizes the submission of report generation request to Report Engine;
Concrete, report generation interface can provide the option of multiple report form type, a corresponding report form template of report form type, user can select the current report form type needing the form generated from the option of provided multiple report form type, and carries user-selected report form type in the report generation request sending to Report Engine;
Client can have the interface with Report Engine interaction data, can realize the data interaction between client and Report Engine by this interface, as report generation request uploads submission to server.
Step S110, the report form type corresponding according to preset each report form template, extract the corresponding report form template of described report form type; Described report form template comprises the form cell of multiple padding data, and form cell arranges Data Identification and the data processing form of padding data to some extent;
Report Engine ALARA Principle report model, and the report form type that preset each report form template is corresponding, a report form type may correspond to a report form template; After Report Engine receives the report generation request of user's submission, report generation request can be resolved, determine the report form type of carrying in report generation request, and then extracting report form template corresponding to this report form type, the report form template extracted is the current report form template needing the form generated to use; The current data stuffing needing the form generated to use is entered in extracted report form template, and handles accordingly, then can realize the generation of form;
In embodiments of the present invention, report form template has the form cell of multiple padding data, and a form cell can fill at least one data; Optionally, Fig. 2 shows the schematic diagram of form cell in report form template, as shown in Figure 2, has multiple form cell 2 inserting data, can refer in report form template 1; Be only a kind of optional placement signal of form cell shown in Fig. 2, the embodiment of the present invention does not get rid of the form cell of otherwise layout;
Optionally, the mark of form cell in report form template can the row, column of form cell represent;
In the embodiment of the present invention, padding data in report form template, can think padding data in the form cell of report form template; For realizing the automatic generation of form, the embodiment of the present invention can be the Data Identification that form cell arranges institute's padding data, and to the data processing form that filled data process;
By the Data Identification set by form cell, Report Engine can realize the automatic filling of corresponding data, and by the data processing form set by form cell, Report Engine can realize the process of institute's padding data, and the automatic generation for form provides basis.
Step S120, for each form cell, from data source, extract corresponding data according to the Data Identification that described form cell is arranged, and be packed into described form cell;
Optionally, data source can be specified by user; Data source also can be preset data source, and the mode in initialize data source can be a preset data source of report form template, when carrying out data stuffing to a report form template, can extract data from the preset data source of this report form template; The mode in initialize data source also can be preset uniform data source, when carrying out data stuffing for any report form template, all can extract data from preset uniform data source;
Optionally, data source can be the database of client this locality, and Report Engine, by capturing the data in local data base, realizes extracting the data corresponding to the Data Identification that form cell is arranged in data source; Optionally, data source also can be network data base, and Report Engine can exist data interaction interface with this network data base, realizes extracting the data corresponding to the Data Identification that form cell is arranged in data source;
For making Report Engine can identify the data that need be filled in form cell from data source, the mode that the embodiment of the present invention stores data for data source need be adjusted accordingly; Optionally, in embodiments of the present invention, data source is not only simple storage data to be filled, also needs to store Data Identification corresponding to data to be filled, namely can store data to be filled and Data Identification corresponding to data to be filled in data source;
Optionally, Data Identification can refer to the type of data, and the embodiment of the present invention can arrange the data type of institute's padding data in form cell, thus in data source, extract the data corresponding to the data type that form cell is arranged;
For distinguishing different data, Data Identification also can be the specific identifier of setting, a specific identifier may correspond at least one data, thus the data corresponding to the specific identifier that form cell is arranged can be extracted in data source, to realize more, precision data is to the filling of form cell, and specific identifier can customize setting.
Step S130, the data processing form arranged according to described form cell, process the data of described filling, generating report forms;
Data processing form is the foundation processed the data of filling in form cell; Data processing form can be data conversion format, realizes the conversion between data in different formats; Data processing form also can be function formula, to realize the functional operation of padding data in form cell; Data processing form also can be Graphic Exchanging form, to realize the conversion of data respective graphical in form cell according to the data of filling, realizes the graphic representation of data;
The huge number of data processing form, the visual actual needs setting of the embodiment of the present invention, does not clearly limit for data processing form;
In form cell, be packed into data, and after processing filled data, the data stuffing of report form template, processing procedure can be thought and completed, and the corresponding form of report generation request that user submits to generates;
Step S140, generated form is fed back to described user.
Optionally, because in report form template, the quantity of form cell is more, the situation of searching the form cell less than corresponding data in data source may be there is, for the form cell searched in data source less than corresponding data, the embodiment of the present invention can think that this form cell can not padding data, also there is not the follow-up process processed filled data, the content of this form cell can be empty.
The report form generation method that the embodiment of the present invention provides, comprising: receive the report generation request that user submits to, described report generation request comprises report form type; The report form type corresponding according to preset each report form template, extracts the corresponding report form template of described report form type, and described report form template comprises the form cell of multiple padding data, and form cell arranges Data Identification and the data processing form of padding data to some extent; For each form cell, from data source, extract corresponding data according to the Data Identification that described form cell is arranged, and be packed into described form cell; According to the data processing form that described form cell is arranged, the data of described filling are processed, generating report forms; Generated form is fed back to described user.Can find out, the form cell that the embodiment of the present invention is report form template arranges Data Identification and the data processing form of institute's padding data, by the Data Identification that form cell is arranged, corresponding data can be extracted from data source, realize the automatic filling of data to report form template, the data processing form arranged by form cell, the automatic process of form cell institute padding data can be realized, complete the process of automatic filling data and automatic data processing in report form template, realize the automatic generation of form; Due to the report form generation method that the embodiment of the present invention provides, the automatic generation of form can be realized, therefore can reduce the workload that report generation relates to, and improve the management function of Report Engine.
Optionally, data source can store data to be filled and Data Identification corresponding to data to be filled; The embodiment of the present invention can extract the to be filled data corresponding with the Data Identification that form cell is arranged from data source, realizes the automatic filling of data to form cell;
Corresponding, Fig. 3 shows another process flow diagram of the report form generation method that the embodiment of the present invention provides, and with reference to Fig. 3, the method can comprise:
The report generation request that step S200, reception user submit to, described report generation request comprises report form type;
Step S210, the report form type corresponding according to preset each report form template, extract the corresponding report form template of described report form type; Described report form template comprises the form cell of multiple padding data, and form cell arranges Data Identification and the data processing form of padding data to some extent;
Step S220, for each form cell, according to the Data Identification that described form cell is arranged, from data source, extract the to be filled data corresponding with described Data Identification, the data to be filled extracted are the data being packed into described form cell; Wherein, described data source stores data to be filled and Data Identification corresponding to data to be filled;
Optionally, on the one hand, described data source can be specified by user, user specifies generating report forms data source used by report generation interface, and producing the information of instruction generating report forms data source used, the information of this instruction generating report forms data source used together can be carried on report form type and be sent in the report generation request of Report Engine; Corresponding, described report generation request, except comprising report form type, also can comprise the information of instruction generating report forms data source used;
Report Engine is after reception report generation request, the information of described report form type and described instruction generating report forms data source used can be parsed from described report generation request, thus extract corresponding report form template according to described report form type, and determine the data source corresponding to the information of described instruction generating report forms data source used, to extract the to be filled data corresponding with the Data Identification that described form cell is arranged from determined data source;
Optionally, on the other hand, described data source may also be the preset data source corresponding to extracted report form template.
Step S230, the data processing form arranged according to described form cell, process the data of described filling, generating report forms;
Step S240, generated form is fed back to described user.
Optionally, data processing form can comprise data conversion format; Accordingly, can be that corresponding Data Format Transform is carried out to data to the process of form cell institute padding data;
Fig. 4 shows a process flow diagram again of the report form generation method that the embodiment of the present invention provides, and with reference to Fig. 4, the method can comprise:
The report generation request that step S300, reception user submit to, described report generation request comprises report form type;
Step S310, the report form type corresponding according to preset each report form template, extract the corresponding report form template of described report form type; Described report form template comprises the form cell of multiple padding data, and form cell arranges Data Identification and the data conversion format of padding data to some extent;
Step S320, for each form cell, from data source, extract corresponding data according to the Data Identification that described form cell is arranged, and be packed into described form cell;
Optionally, the specific implementation of step S320 can as shown in Fig. 3 corresponding part.
Step S330, the data conversion format arranged according to described form cell, carry out the conversion of data layout, generating report forms to the data of described filling;
Step S340, generated form is fed back to described user.
Optionally, data conversion format as the conversion on date, the conversion etc. of unit; Be converted to example with unit, the data that the Data Identification that a certain form cell is arranged is corresponding are 100 centimetres, and the data conversion format that this form cell is arranged is for centimetre being converted to rice; Then Report Engine can extract the corresponding data (100 centimetres) of the Data Identification that arranges to this form cell from data source, after being packed into this form cell, the data conversion format that Report Engine can be arranged according to this form cell, be converted to 1 meter by 100 centimetres, the conversion realizing unit is unified.
Optionally, data processing form can comprise function formula; Accordingly, can be that corresponding functional operation is carried out to data to the process of form cell institute padding data;
Fig. 5 shows the another process flow diagram of the report form generation method that the embodiment of the present invention provides, and with reference to Fig. 5, the method can comprise:
The report generation request that step S400, reception user submit to, described report generation request comprises report form type;
Step S410, the report form type corresponding according to preset each report form template, extract the corresponding report form template of described report form type; Described report form template comprises the form cell of multiple padding data, and form cell arranges Data Identification and the function formula of padding data to some extent;
Step S420, for each form cell, from data source, extract corresponding data according to the Data Identification that described form cell is arranged, and be packed into described form cell;
Optionally, the specific implementation of step S420 can as shown in Fig. 3 corresponding part.
Step S430, the function formula arranged according to described form cell, carry out functional operation, generating report forms to the data of described filling;
Step S440, generated form is fed back to described user.
Optionally, function formula can be add, subtract, the mathematical formulae such as multiplication and division; Following is example, and when generating the form of certain school student's height, the data that the Data Identification that a certain form cell is arranged is corresponding are 3 years each student's height of one class, and the function formula that this form cell is arranged is calculating 3 years student's average heights of a class; Then Report Engine according to the Data Identification (corresponding with 3 years student's height of one class) of this form cell setting, can be extracted 3 years each student's height of one class, and is packed into this form cell from student's height data source in this school; With the function formula that this form cell is arranged, according to filled three years each student's height of one class, 3 years student's average heights of a class can be calculated.
Optionally, data processing form also can be comprise data conversion format, sum functions formula; When processing the data that form cell is filled, can process the data that form cell is filled according to data conversion format sum functions formula respectively.
Optionally, data processing form also can be Graphic Exchanging form, the Graphic Exchanging form that Report Engine can be arranged according to form cell, the data of filling in form cell is expressed in patterned mode.
Optionally, be convenient to for making user read the form generated, Report Engine can support the conversion of the file layout to institute's generating report forms; Corresponding, after generating report forms, the file layout of form can be converted to specified format by the embodiment of the present invention, this specified format can be arranged by user, specified format is as forms such as PDF, Excel, Word, after the file layout of form can be converted to specified format by the embodiment of the present invention, then feed back to user.
The report form generation method that the embodiment of the present invention provides, can realize the automatic generation of form, reduce the workload that report generation relates to, the perfect management function of Report Engine.
Be introduced the Report Engine that the embodiment of the present invention provides below, Report Engine described below can corresponding reference mutual to above-described report form generation method.
The structured flowchart of the Report Engine that Fig. 6 provides for the embodiment of the present invention, this Report Engine can be arranged in server, and with reference to Fig. 6, this Report Engine can comprise:
Request receiving module 100, for receiving the report generation request that user submits to, described report generation request comprises report form type;
Report form template extraction module 200, for the report form type that each report form template according to preset is corresponding, extracts the corresponding report form template of described report form type; Described report form template comprises the form cell of multiple padding data, and form cell arranges Data Identification and the data processing form of padding data to some extent;
Data stuffing module 300, for for each form cell, extracts corresponding data according to the Data Identification that described form cell is arranged, and is packed into described form cell from data source;
Data processing module 400, for the data processing form arranged according to described form cell, processes the data of described filling, generating report forms;
Form feedback module 500, for feeding back to described user by generated form.
Optionally, described data source can store data to be filled and Data Identification corresponding to data to be filled; Corresponding, Fig. 7 shows a kind of alternate configurations of the data stuffing module 300 that the embodiment of the present invention provides, and with reference to Fig. 7, data stuffing module 300 can comprise:
Data determination unit 310 to be filled, for the Data Identification arranged according to described form cell, from described data source, extract the to be filled data corresponding with described Data Identification, the data to be filled extracted are the data being packed into described form cell.
Optionally, described data source can be specified by user; Corresponding, described report generation request also comprises: the information of instruction generating report forms data source used; Fig. 8 shows another structured flowchart of the Report Engine that the embodiment of the present invention provides, and shown in composition graphs 6 and Fig. 8, this Report Engine can also comprise:
Data source determination module 600, for determining the data source corresponding to the information of described instruction generating report forms data source used.
Optionally, described data processing form can comprise: data conversion format; Corresponding, Fig. 9 shows a kind of alternate configurations of the data processing module 400 that the embodiment of the present invention provides, and with reference to Fig. 9, data processing module 400 can comprise:
Format conversion unit 410, for the data conversion format arranged according to described form cell, carries out the conversion of data layout to the data of described filling.
Optionally, described data processing form can comprise function formula; Corresponding, Figure 10 shows the another kind of alternate configurations of the data processing module 400 that the embodiment of the present invention provides, and with reference to Figure 10, data processing module 400 can comprise:
Function arithmetic unit 420, for the function formula arranged according to described form cell, carries out functional operation to the data of described filling.
Optionally, Report Engine also can support the conversion of the file layout to institute's generating report forms; Corresponding, Figure 11 shows a kind of alternate configurations of the form feedback module 500 that the embodiment of the present invention provides, and with reference to Figure 11, form feedback module 500 can comprise:
File format conversion unit 510, for being converted to specified format by the file layout of form;
Feedback unit 520, for feeding back to user by the form being converted to specified format.
The Report Engine that the embodiment of the present invention provides, can realize the automatic generation of form, reduce the workload that report generation relates to, the perfect management function of Report Engine.
In this instructions, each embodiment adopts the mode of going forward one by one to describe, and what each embodiment stressed is the difference with other embodiments, between each embodiment identical similar portion mutually see.For device disclosed in embodiment, because it corresponds to the method disclosed in Example, so description is fairly simple, relevant part illustrates see method part.
Professional can also recognize further, in conjunction with unit and the algorithm steps of each example of embodiment disclosed herein description, can realize with electronic hardware, computer software or the combination of the two, in order to the interchangeability of hardware and software is clearly described, generally describe composition and the step of each example in the above description according to function.These functions perform with hardware or software mode actually, depend on application-specific and the design constraint of technical scheme.Professional and technical personnel can use distinct methods to realize described function to each specifically should being used for, but this realization should not thought and exceeds scope of the present invention.
The software module that the method described in conjunction with embodiment disclosed herein or the step of algorithm can directly use hardware, processor to perform, or the combination of the two is implemented.Software module can be placed in the storage medium of other form any known in random access memory (RAM), internal memory, ROM (read-only memory) (ROM), electrically programmable ROM, electrically erasable ROM, register, hard disk, moveable magnetic disc, CD-ROM or technical field.
To the above-mentioned explanation of the disclosed embodiments, professional and technical personnel in the field are realized or uses the present invention.To be apparent for those skilled in the art to the multiple amendment of these embodiments, General Principle as defined herein can without departing from the spirit or scope of the present invention, realize in other embodiments.Therefore, the present invention can not be restricted to these embodiments shown in this article, but will meet the widest scope consistent with principle disclosed herein and features of novelty.
Claims (10)
1. a report form generation method, is characterized in that, comprising:
Receive the report generation request that user submits to, described report generation request comprises report form type;
The report form type corresponding according to preset each report form template, extracts the corresponding report form template of described report form type; Described report form template comprises the form cell of multiple padding data, and form cell arranges Data Identification and the data processing form of padding data to some extent;
For each form cell, from data source, extract corresponding data according to the Data Identification that described form cell is arranged, and be packed into described form cell;
According to the data processing form that described form cell is arranged, the data of described filling are processed, generating report forms;
Generated form is fed back to described user.
2. report form generation method according to claim 1, is characterized in that, described data source stores data to be filled and Data Identification corresponding to data to be filled;
The described Data Identification arranged according to described form cell extracts corresponding data and comprises from described data source:
According to the Data Identification that described form cell is arranged, from described data source, extract the to be filled data corresponding with described Data Identification, the data to be filled extracted are the data being packed into described form cell.
3. report form generation method according to claim 1, is characterized in that, described report generation request also comprises: the information of instruction generating report forms data source used; Described data source is corresponding to the information of described instruction generating report forms data source used.
4. the report form generation method according to claim 1-3, is characterized in that, described data processing form comprises: data conversion format;
The described data processing form arranged according to described form cell, carries out process to the data of described filling and comprises:
According to the data conversion format that described form cell is arranged, the data of described filling are carried out to the conversion of data layout.
5. the report form generation method according to claim 1-3, is characterized in that, described data processing form comprises: function formula;
The described data processing form arranged according to described form cell, carries out process to the data of described filling and comprises:
According to the function formula that described form cell is arranged, functional operation is carried out to the data of described filling.
6. a Report Engine, is characterized in that, comprising:
Request receiving module, for receiving the report generation request that user submits to, described report generation request comprises report form type;
Report form template extraction module, for the report form type that each report form template according to preset is corresponding, extracts the corresponding report form template of described report form type; Described report form template comprises the form cell of multiple padding data, and form cell arranges Data Identification and the data processing form of padding data to some extent;
Data stuffing module, for for each form cell, extracts corresponding data according to the Data Identification that described form cell is arranged, and is packed into described form cell from data source;
Data processing module, for the data processing form arranged according to described form cell, processes the data of described filling, generating report forms;
Form feedback module, for feeding back to described user by generated form.
7. Report Engine according to claim 6, is characterized in that, described data source stores data to be filled and Data Identification corresponding to data to be filled;
Described data stuffing module comprises:
Data determination unit to be filled, for the Data Identification arranged according to described form cell, from described data source, extract the to be filled data corresponding with described Data Identification, the data to be filled extracted are the data being packed into described form cell.
8. Report Engine according to claim 6, is characterized in that, described report generation request also comprises: the information of instruction generating report forms data source used;
Described Report Engine also comprises:
Data source determination module, for determining the data source corresponding to the information of described instruction generating report forms data source used.
9. the Report Engine according to any one of claim 6-8, is characterized in that, described data processing form comprises: data conversion format;
Described data processing module comprises:
Format conversion unit, for the data conversion format arranged according to described form cell, carries out the conversion of data layout to the data of described filling.
10. the Report Engine according to any one of claim 6-8, is characterized in that, described data processing form comprises: function formula;
Described data processing module comprises:
Function arithmetic unit, for the function formula arranged according to described form cell, carries out functional operation to the data of described filling.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510563784.3A CN105138504A (en) | 2015-09-07 | 2015-09-07 | Report generation method and report engine |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510563784.3A CN105138504A (en) | 2015-09-07 | 2015-09-07 | Report generation method and report engine |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105138504A true CN105138504A (en) | 2015-12-09 |
Family
ID=54723855
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510563784.3A Pending CN105138504A (en) | 2015-09-07 | 2015-09-07 | Report generation method and report engine |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105138504A (en) |
Cited By (30)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105653205A (en) * | 2015-12-25 | 2016-06-08 | 浪潮(北京)电子信息产业有限公司 | User request processing method and system |
| CN105760172A (en) * | 2016-03-02 | 2016-07-13 | 浪潮软件集团有限公司 | Statement generation method based on itext |
| CN105843784A (en) * | 2016-03-18 | 2016-08-10 | 中国银行股份有限公司 | Statement generation method and device |
| CN106022896A (en) * | 2016-06-07 | 2016-10-12 | 中国建设银行股份有限公司 | Transaction statistics report generation method and system |
| CN106202018A (en) * | 2016-07-12 | 2016-12-07 | 精硕世纪科技（北京）有限公司 | Excel report-generating method and device |
| CN106886484A (en) * | 2017-02-22 | 2017-06-23 | 郑州云海信息技术有限公司 | Report form generation method and device based on sea of clouds system |
| CN107122344A (en) * | 2017-05-24 | 2017-09-01 | 中国农业银行股份有限公司 | A kind of report-generating method and system |
| CN107133205A (en) * | 2017-05-04 | 2017-09-05 | 山东浪潮云服务信息科技有限公司 | A kind of cloud form component implementation method and device based on data, services |
| CN107391550A (en) * | 2017-06-06 | 2017-11-24 | 广东广业开元科技有限公司 | A kind of report form generation method and system based on big data mould plate technique |
| CN107506185A (en) * | 2017-08-07 | 2017-12-22 | 海闻科技有限公司 | A kind of data parsing and method for exhibiting data and system |
| CN107608950A (en) * | 2016-07-11 | 2018-01-19 | 陈鹏 | A kind of method for generating electronic report forms |
| CN108132925A (en) * | 2017-12-15 | 2018-06-08 | 中盈优创资讯科技有限公司 | A kind of report file generation method and device |
| WO2018149373A1 (en) * | 2017-02-16 | 2018-08-23 | 平安科技（深圳）有限公司 | File interaction method and system, and terminal device and medium |
| CN108829653A (en) * | 2018-05-04 | 2018-11-16 | 山东中创软件工程股份有限公司 | A kind of generation method of report, device, equipment and medium |
| CN105843785B (en) * | 2016-03-22 | 2019-03-19 | 南京大学 | A kind of data self accounting report generation method of embedded organization and administration level |
| CN109657214A (en) * | 2018-09-27 | 2019-04-19 | 深圳壹账通智能科技有限公司 | Report form generation method, device, terminal and storage medium |
| CN110069453A (en) * | 2017-09-30 | 2019-07-30 | 北京国双科技有限公司 | Operation/maintenance data treating method and apparatus |
| CN110109980A (en) * | 2019-04-04 | 2019-08-09 | 广州供电局有限公司 | Regular inspection material generation method, device, computer equipment and storage medium |
| CN110119414A (en) * | 2019-05-11 | 2019-08-13 | 成都银光软件有限公司 | Dining room information report management system and method |
| CN110232175A (en) * | 2019-05-08 | 2019-09-13 | 深圳中大环保科技创新工程中心有限公司 | Generation method, device and the computer equipment of sea island resources balance sheet |
| CN110232176A (en) * | 2019-05-08 | 2019-09-13 | 深圳中大环保科技创新工程中心有限公司 | Generation method, device and the computer equipment of gulf area resource balance sheet |
| CN110807056A (en) * | 2019-10-28 | 2020-02-18 | 长城计算机软件与系统有限公司 | Excel-based report processing method, Excel-based report processing device, Excel-based report processing medium and electronic equipment |
| CN110866383A (en) * | 2019-10-15 | 2020-03-06 | 中国直升机设计研究所 | Interactive electronic data list generation method and system |
| CN110941948A (en) * | 2019-10-14 | 2020-03-31 | 益萃网络科技（中国）有限公司 | Document interface display method, device, equipment and storage medium |
| CN111158650A (en) * | 2019-12-25 | 2020-05-15 | 中国建设银行股份有限公司 | Report template, report template and report generation method and device |
| CN111523295A (en) * | 2019-01-17 | 2020-08-11 | 北京沃东天骏信息技术有限公司 | Data rendering method, device, medium and electronic equipment |
| CN112131843A (en) * | 2020-09-02 | 2020-12-25 | 苏宁云计算有限公司 | Business report generation method and device, computer equipment and storage medium |
| CN112836479A (en) * | 2020-12-30 | 2021-05-25 | 佛山欧神诺云商科技有限公司 | Data report generation method, system and storage device |
| CN113220754A (en) * | 2021-05-21 | 2021-08-06 | 中国农业银行股份有限公司 | Method, device, equipment, storage medium and program product for processing report data |
| CN117649105A (en) * | 2023-11-27 | 2024-03-05 | 国网江苏省电力有限公司扬州供电分公司 | Substation work ticket intelligent ticket filling method and system based on RPA process automation |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101122899A (en) * | 2007-09-18 | 2008-02-13 | 杭州华三通信技术有限公司 | Report generation method and device |
| CN101661460A (en) * | 2009-09-18 | 2010-03-03 | 上海宝信软件股份有限公司 | Method and device for generating management system report |
| CN102810094A (en) * | 2011-05-31 | 2012-12-05 | 中兴通讯股份有限公司 | Report generation method and device |
| CN103034553A (en) * | 2012-12-20 | 2013-04-10 | 厦门亿力吉奥信息科技有限公司 | Intelligent verification algorithm, method and device for report designer |
| CN103778234A (en) * | 2014-01-26 | 2014-05-07 | 北京恒华伟业科技股份有限公司 | Report form generating method and device |
| CN104317839A (en) * | 2014-10-10 | 2015-01-28 | 北京国双科技有限公司 | Method and device for generating report form template |
| CN104778241A (en) * | 2015-04-08 | 2015-07-15 | 北京京东尚科信息技术有限公司 | Report generation method and system |
-
2015
- 2015-09-07 CN CN201510563784.3A patent/CN105138504A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101122899A (en) * | 2007-09-18 | 2008-02-13 | 杭州华三通信技术有限公司 | Report generation method and device |
| CN101661460A (en) * | 2009-09-18 | 2010-03-03 | 上海宝信软件股份有限公司 | Method and device for generating management system report |
| CN102810094A (en) * | 2011-05-31 | 2012-12-05 | 中兴通讯股份有限公司 | Report generation method and device |
| CN103034553A (en) * | 2012-12-20 | 2013-04-10 | 厦门亿力吉奥信息科技有限公司 | Intelligent verification algorithm, method and device for report designer |
| CN103778234A (en) * | 2014-01-26 | 2014-05-07 | 北京恒华伟业科技股份有限公司 | Report form generating method and device |
| CN104317839A (en) * | 2014-10-10 | 2015-01-28 | 北京国双科技有限公司 | Method and device for generating report form template |
| CN104778241A (en) * | 2015-04-08 | 2015-07-15 | 北京京东尚科信息技术有限公司 | Report generation method and system |
Non-Patent Citations (1)
| Title |
|---|
| 刘炳文等: "《Visual Basic程序设计 数据库篇》", 30 June 1999, 《人民邮电出版社》 * |
Cited By (35)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105653205A (en) * | 2015-12-25 | 2016-06-08 | 浪潮(北京)电子信息产业有限公司 | User request processing method and system |
| CN105760172A (en) * | 2016-03-02 | 2016-07-13 | 浪潮软件集团有限公司 | Statement generation method based on itext |
| CN105843784A (en) * | 2016-03-18 | 2016-08-10 | 中国银行股份有限公司 | Statement generation method and device |
| CN105843785B (en) * | 2016-03-22 | 2019-03-19 | 南京大学 | A kind of data self accounting report generation method of embedded organization and administration level |
| CN106022896A (en) * | 2016-06-07 | 2016-10-12 | 中国建设银行股份有限公司 | Transaction statistics report generation method and system |
| CN107608950A (en) * | 2016-07-11 | 2018-01-19 | 陈鹏 | A kind of method for generating electronic report forms |
| CN106202018A (en) * | 2016-07-12 | 2016-12-07 | 精硕世纪科技（北京）有限公司 | Excel report-generating method and device |
| WO2018149373A1 (en) * | 2017-02-16 | 2018-08-23 | 平安科技（深圳）有限公司 | File interaction method and system, and terminal device and medium |
| CN106886484A (en) * | 2017-02-22 | 2017-06-23 | 郑州云海信息技术有限公司 | Report form generation method and device based on sea of clouds system |
| CN107133205A (en) * | 2017-05-04 | 2017-09-05 | 山东浪潮云服务信息科技有限公司 | A kind of cloud form component implementation method and device based on data, services |
| CN107122344A (en) * | 2017-05-24 | 2017-09-01 | 中国农业银行股份有限公司 | A kind of report-generating method and system |
| CN107122344B (en) * | 2017-05-24 | 2020-09-18 | 中国农业银行股份有限公司 | Report generation method and system |
| CN107391550A (en) * | 2017-06-06 | 2017-11-24 | 广东广业开元科技有限公司 | A kind of report form generation method and system based on big data mould plate technique |
| CN107506185A (en) * | 2017-08-07 | 2017-12-22 | 海闻科技有限公司 | A kind of data parsing and method for exhibiting data and system |
| CN110069453A (en) * | 2017-09-30 | 2019-07-30 | 北京国双科技有限公司 | Operation/maintenance data treating method and apparatus |
| CN108132925A (en) * | 2017-12-15 | 2018-06-08 | 中盈优创资讯科技有限公司 | A kind of report file generation method and device |
| CN108829653A (en) * | 2018-05-04 | 2018-11-16 | 山东中创软件工程股份有限公司 | A kind of generation method of report, device, equipment and medium |
| CN109657214A (en) * | 2018-09-27 | 2019-04-19 | 深圳壹账通智能科技有限公司 | Report form generation method, device, terminal and storage medium |
| CN111523295A (en) * | 2019-01-17 | 2020-08-11 | 北京沃东天骏信息技术有限公司 | Data rendering method, device, medium and electronic equipment |
| CN110109980B (en) * | 2019-04-04 | 2021-08-31 | 广东电网有限责任公司广州供电局 | Method and device for generating scheduled inspection material, computer equipment and storage medium |
| CN110109980A (en) * | 2019-04-04 | 2019-08-09 | 广州供电局有限公司 | Regular inspection material generation method, device, computer equipment and storage medium |
| CN110232175A (en) * | 2019-05-08 | 2019-09-13 | 深圳中大环保科技创新工程中心有限公司 | Generation method, device and the computer equipment of sea island resources balance sheet |
| CN110232176A (en) * | 2019-05-08 | 2019-09-13 | 深圳中大环保科技创新工程中心有限公司 | Generation method, device and the computer equipment of gulf area resource balance sheet |
| CN110119414A (en) * | 2019-05-11 | 2019-08-13 | 成都银光软件有限公司 | Dining room information report management system and method |
| CN110941948A (en) * | 2019-10-14 | 2020-03-31 | 益萃网络科技（中国）有限公司 | Document interface display method, device, equipment and storage medium |
| CN110941948B (en) * | 2019-10-14 | 2024-02-23 | 浙江坤盈科技有限公司 | Document interface display method, device, equipment and storage medium |
| CN110866383A (en) * | 2019-10-15 | 2020-03-06 | 中国直升机设计研究所 | Interactive electronic data list generation method and system |
| CN110866383B (en) * | 2019-10-15 | 2023-09-19 | 中国直升机设计研究所 | Interactive electronic data list generation method and system |
| CN110807056A (en) * | 2019-10-28 | 2020-02-18 | 长城计算机软件与系统有限公司 | Excel-based report processing method, Excel-based report processing device, Excel-based report processing medium and electronic equipment |
| CN111158650A (en) * | 2019-12-25 | 2020-05-15 | 中国建设银行股份有限公司 | Report template, report template and report generation method and device |
| CN112131843A (en) * | 2020-09-02 | 2020-12-25 | 苏宁云计算有限公司 | Business report generation method and device, computer equipment and storage medium |
| CN112836479A (en) * | 2020-12-30 | 2021-05-25 | 佛山欧神诺云商科技有限公司 | Data report generation method, system and storage device |
| CN113220754A (en) * | 2021-05-21 | 2021-08-06 | 中国农业银行股份有限公司 | Method, device, equipment, storage medium and program product for processing report data |
| CN117649105A (en) * | 2023-11-27 | 2024-03-05 | 国网江苏省电力有限公司扬州供电分公司 | Substation work ticket intelligent ticket filling method and system based on RPA process automation |
| CN117649105B (en) * | 2023-11-27 | 2024-05-31 | 国网江苏省电力有限公司扬州供电分公司 | Substation work ticket intelligent ticket filling method based on RPA flow automation |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105138504A (en) | Report generation method and report engine | |
| US11222178B2 (en) | Text entity extraction method for extracting text from target text based on combination probabilities of segmentation combination of text entities in the target text, apparatus, and device, and storage medium | |
| TWI663553B (en) | Method and device for generating contract | |
| CN105447174B (en) | A kind of report generation method and device | |
| CN100442289C (en) | Map information system and map information processing method and program | |
| US20130174024A1 (en) | Method and device for converting document format | |
| CN105488073A (en) | Method and device for generating report header | |
| US11934774B2 (en) | Systems and methods for generating social assets from electronic publications | |
| EP3617910A1 (en) | Method and apparatus for displaying textual information | |
| CN104077462A (en) | Antique digital model three-dimensional marking method | |
| CN112686015A (en) | Chart generation method, device, equipment and storage medium | |
| CN107515866B (en) | Data operation method, device and system | |
| CN111274626B (en) | Engineering investigation data processing system | |
| CN112818457A (en) | BIM (building information modeling) model intelligent generation method and system based on CAD (computer-aided design) drawing | |
| CN116630468A (en) | Two-dimensional drawing generation method and device, storage medium and electronic equipment | |
| CN109697211B (en) | Method and system for processing cross table derived data and computer readable storage medium | |
| CN113342921B (en) | Resource cataloging method and device | |
| CN102375859B (en) | Method and equipment for processing information | |
| CN105590241A (en) | Self-adaptive electronic bill implementation method and system | |
| CN111401023B (en) | Report generation method, report generation device, server and storage medium | |
| CN116402521B (en) | Cross-border supply chain commodity tracing method and system based on blockchain | |
| CN105095538B (en) | The dimensionally-optimised system and method for connector | |
| CN114419194A (en) | Method for generating collocation image and electronic equipment | |
| CN117744615A (en) | Form data processing method and device, electronic equipment and readable storage medium | |
| CN113095051B (en) | Method, device, computer equipment and storage medium for generating response mark enterprise report |
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: 20151209 |