CN102810094A - Report generation method and device - Google Patents
Report generation method and device Download PDFInfo
- Publication number
- CN102810094A CN102810094A CN2011101452356A CN201110145235A CN102810094A CN 102810094 A CN102810094 A CN 102810094A CN 2011101452356 A CN2011101452356 A CN 2011101452356A CN 201110145235 A CN201110145235 A CN 201110145235A CN 102810094 A CN102810094 A CN 102810094A
- Authority
- CN
- China
- Prior art keywords
- report
- data
- source data
- user
- template
- 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
Images
Abstract
The invention discloses a report generation method and a report generation method device. The report generation method comprises the following steps: acquiring the storage mode of the source data of the report; calling the interface which corresponds to the storage mode to acquire the source data of the report; and generating the report by using the source data of the report and the template of the report. Due to the adoption of the report generation method and device, the problems of single mode of source of data processed by the existing report system and low efficiency of the report system are overcome, and the processing efficiency of the report system is improved.
Description
Technical field
The present invention relates to the communications field, in particular to a kind of report form generation method and device.
Background technology
In large-scale application; Structure of report is complicated; Its Data Source is varied, and the personnel component of using form simultaneously is more complicated also, goes up the leader and time all possibly use form to general employee; Simultaneously for everyone oneself own use habit and focal point are arranged all, this just has higher requirement to the fusion of form, the management and the control of form to reporting system.
Fig. 1 is the structured flowchart according to the reporting system of correlation technique; As shown in Figure 1; Reporting system mainly is made up of form selected cell 12, data-carrier store 18, report generation unit 14, form display unit 16 these four parts; All report form templates of form selected cell 12 display data rams offer the user and select; The formwork style information that data-carrier store 18 is preserved form; Report generation unit 14 is connected to database 19, and form model and the data in the database 19 selected according to the user generate concrete form; Form display unit 16 shows the form that generates.
There is following defective in reporting system in the correlation technique: existing reporting system can only be handled the data that are stored in the database, and the Data Source mode that reporting system is handled is more single, thereby causes the reporting system efficiency ratio lower.
Summary of the invention
Fundamental purpose of the present invention is to provide a kind of report form generation method and device; Can only handle the data that are stored in the database to solve above-mentioned existing reporting system at least; The Data Source mode that reporting system is handled is more single, thereby causes the low problem of reporting system efficiency ratio.
According to an aspect of the present invention, a kind of report form generation method is provided, has may further comprise the steps: the storage mode that obtains the form source data; Call the corresponding interface of storage mode and obtain the form source data; Use form source data and report form template to generate form.
Preferably, the storage mode of form source data comprises one of following: database, file, data model.
Preferably; The storage mode of source data is a file; The interface that calls the storage mode correspondence obtains the form source data and comprises: the adapter function that calls the corresponding interface of file obtains the form source data from file; Wherein, the adapter function is used for the data memory format of Study document, and obtains the form source data according to data memory format; The storage mode of source data is a data model, and the interface that calls the storage mode correspondence obtains the form source data and comprises: the query term that obtains data model according to report form template; Calling the corresponding interface of data model uses query term from data model, to obtain the form source data.
Preferably, using form source data and report form template to generate form comprises: use form source data and report form template to generate no pattern form; Use no pattern form and the report style that gets access to generate form.
Preferably, before the report style that uses no pattern form and get access to generates form, also comprise: receive the definition of user report style.
Preferably, before using form source data and report form template generation form, also comprise: obtain the key word of user's input, and obtain the corresponding report form template of key word; Perhaps, obtain user's used report form template.
Preferably; Said method also comprises: use tree structure to preserve user's used key word of ID, user and/or system-key; Wherein, the used key word of user and/or the system-key of tree structure preservation are used for when user entered keyword, pointing out.
According to a further aspect in the invention, a kind of report generation device is provided, has comprised: first acquisition module is used to obtain the storage mode of form source data; Calling module is used to call the corresponding interface of storage mode and obtains the form source data; First generation module is used to use form source data and report form template to generate form.
Preferably; Calling module comprises: first processing module; When the storage mode that is used for source data was file, the adapter function that calls the corresponding interface of file obtained the form source data from file, wherein; The adapter function is used for the data memory format of Study document, and obtains the form source data according to data memory format; Or
Calling module comprises: second acquisition module, when the storage mode that is used for source data is data model, obtain the query term of data model according to report form template; Second processing module is used for calling the corresponding interface of data model and uses query term to obtain the form source data from data model.
Preferably, first generation module comprises: second generation module is used to use form source data and report form template to generate no pattern form; The 3rd generates module, is used to use no pattern form and the report style that gets access to generate form.
Preferably, said apparatus also comprises: the 3rd acquisition module is used to obtain the key word of user's input, and obtains the corresponding report form template of key word; Perhaps, the 4th acquisition module is used to obtain user's used report form template.
Through the present invention, adopt the storage mode that obtains the form source data; Call the corresponding interface of storage mode and obtain the form source data; Use form source data and report form template to generate form; Solve reporting system and can only handle the data that are stored in the database; The Data Source mode that reporting system is handled is more single; Thereby cause the problem of the low problem of reporting system efficiency ratio, and then reached the effect that improves the reporting system treatment effeciency.
Description of drawings
Accompanying drawing described herein is used to provide further understanding of the present invention, constitutes the application's a part, and illustrative examples of the present invention and explanation thereof are used to explain the present invention, do not constitute improper qualification of the present invention.In the accompanying drawings:
Fig. 1 is the structured flowchart according to the reporting system of correlation technique;
Fig. 2 is the process flow diagram according to the report form generation method of the embodiment of the invention;
Fig. 3 is the structured flowchart according to the report generation device of the embodiment of the invention;
Fig. 4 is the preferred construction block diagram according to the report generation device of the embodiment of the invention;
Fig. 5 is the structured flowchart of reporting system according to the preferred embodiment of the invention;
Fig. 6 is the process flow diagram based on the implementation method of the reporting system of user behavior analysis according to the embodiment of the invention;
Fig. 7 is that the data source according to the embodiment of the invention is the process flow diagram of generative process of the report data of database;
Fig. 8 is that the data source according to the embodiment of the invention is the process flow diagram of generative process of the report data of file; And
Fig. 9 is that the data source according to the embodiment of the invention is the process flow diagram of generative process of the report data of data model.
Embodiment
Hereinafter will and combine embodiment to specify the present invention with reference to accompanying drawing.Need to prove that under the situation of not conflicting, embodiment and the characteristic among the embodiment among the application can make up each other.
Present embodiment provides a kind of report form generation method, and Fig. 2 is the process flow diagram according to the report form generation method of the embodiment of the invention, and is as shown in Figure 2, and this method comprises the steps:
Step S202: the storage mode that obtains the form source data;
Step S204: call the corresponding interface of storage mode and obtain the form source data;
Step S206: use form source data and report form template to generate form.
Pass through above-mentioned steps; At first obtain the storage mode of form source data, go to obtain the form source data according to the corresponding interface of storage mode then, thereby can go to obtain the form source data through interface corresponding to different storage modes; Overcome and to have handled the data that are stored in the database in the correlation technique; The Data Source mode that reporting system is handled is more single, thereby causes the lower problem of reporting system efficiency ratio, has improved the treatment effeciency of reporting system.
Preferably, it is one of following that the storage mode that obtains the form source data comprises: database, file, data model.Through the preferred embodiment, expanded the source mode of the source data of reporting system processing.
Preferably; When the storage mode of source data is file; Can adopt different modes to call the corresponding interface of storage mode and obtain the form source data, provide preferred embodiment a kind of in the present embodiment: the adapter function that calls the corresponding interface of file obtains the form source data from file, wherein; The adapter function is used for the data memory format of Study document, and obtains the form source data according to data memory format.Through the preferred embodiment, obtain the form source data in the dissimilar files through adapter function with supporting interface corresponding to different files, realized that reporting system directly calls the data in the file, improved the efficient of messaging system.
Preferably; When the storage mode of source data is data model; Can adopt different modes to call the corresponding interface of storage mode and obtain the form source data, provide preferred embodiment a kind of in the present embodiment: the query term that obtains data model according to report form template; Calling the corresponding interface of data model uses query term from data model, to obtain the form source data.Pass through the preferred embodiment; Obtain the query term of data model through the message template region; Calling interface obtains the form source data then; Realized that reporting system calls the form source data that storage mode is a data model, and can call the relevant form source data in a plurality of forms, improved the efficient and the practicality of reporting system.
Preferably, using form source data and report form template to generate form comprises: use form source data and report form template to generate no pattern form; Use no pattern form and the report style that gets access to generate form.Through the preferred embodiment, at first generate no pattern form, generate form according to the report style that gets access to then, realized requiring to generate report style according to user's personalization, improved the dirigibility of reporting system.
Preferably, before the report style that uses no pattern form and get access to generates form, also comprise: receive the definition of user report style.Through the preferred embodiment, can define report style in advance according to the user and generate form, embodied the personalization of report generation, improved user experience.
Preferably, before using form source data and report form template generation form, can obtain Reports module, describe in the face of two kinds of embodiments down through numerous embodiments.
Mode one: obtain the key word of user's input, and obtain the corresponding report form template of key word.
Mode two: the used report form template that obtains the user.
Mode one removes to locate report form template according to the key word of user's input, has saved the time of searching report form template, and mode two is obtained the used report form template of user, goes to confirm report form template according to user's use habit, has embodied the human oriented design of reporting system.
Preferably; Said method also comprises: use tree structure to preserve user's used key word of ID, user and/or system-key; Wherein, the used key word of user and/or the system-key of tree structure preservation are used for when user entered keyword, pointing out.Through the preferred embodiment, adopt the tree structure canned data, convenient search is to user's relevant information.
The embodiment of the invention provides a kind of report generation device, and this device can be used to realize above-mentioned report form generation method.Fig. 3 is the structured flowchart according to the report generation device of the embodiment of the invention, and is as shown in Figure 3, and this device comprises: first acquisition module 32, calling module 34 and first generation module 36 are elaborated in the face of said structure down:
First acquisition module 32 is used to obtain the storage mode of form source data; Calling module 34 is connected to first acquisition module 32, is used to call the corresponding interface of storage mode that first acquisition module 32 gets access to and obtains the form source data; First generation module 36 is connected to calling module 34, and the form source data and the report form template that are used to use calling module 34 to get access to generate form.
Fig. 4 is the preferred construction block diagram according to the report generation device of the embodiment of the invention, and is as shown in Figure 4, and calling module 34 comprises: first processing module 342; Or second acquisition module 344 and second processing module 346; First generation module 36 comprises: second generation module 362 and the 3rd generates module 364, and said apparatus also comprises: the 3rd acquisition module 42 or the 4th acquisition module 44 are described in detail in the face of said structure down:
Calling module 34 comprises: first processing module 342; When the storage mode that is used for source data is file; The adapter function that calls the corresponding interface of file obtains the form source data from file; Wherein, the adapter function is used for the data memory format of Study document, and obtains the form source data according to data memory format.
Calling module 34 comprises: second acquisition module 344, when the storage mode that is used for source data is data model, obtain the query term of data model according to report form template; Second processing module 346 is connected to second acquisition module 344, is used for calling the query term that the corresponding interface of data model uses second acquisition module 344 to get access to and obtains the form source data from data model.
First generation module 36 comprises: second generation module 362 is used to use form source data and report form template to generate no pattern form; The 3rd generates module 364, is connected to second generation module 362, is used to use second generation module 362 no pattern form that generates and the report style that gets access to generate form.
Preferably, said apparatus also comprises: the 3rd acquisition module 42 is used to obtain the key word of user's input, and obtains the corresponding report form template of key word; Perhaps, the 4th acquisition module 44 is used to obtain user's used report form template.
Need to prove that the message generating apparatus of describing among the device embodiment is corresponding to above-mentioned method embodiment, its concrete implementation procedure had been carried out detailed description in method embodiment, repeat no more at this.
To combine instance to describe below:
Embodiment one
Present embodiment provides a kind of reporting system, and present embodiment has combined the foregoing description and preferred implementation wherein, and Fig. 5 is the structured flowchart of reporting system according to the preferred embodiment of the invention; As shown in Figure 5, this system comprises: form search unit 51, report generation unit 52; User behavior analysis unit 53, report data storage area 54, form authority unit 55; Form display unit 56, this reporting system links to each other with database 57, data model 58, handles the wherein data of the correspondence of storage; Also can link to each other, handle the data of other forms such as text, face said structure down and be described in detail through other formatted files 60 such as adapter 59 and texts:
Form search unit 51: the search inputting interface is provided, with the title of input keyword matching form, the row title of form (if analytical statement then the tolerance in the matched data model), obtain and show the Report List that satisfies condition, the key word of recording user input.
Report generation unit 52: generate a no pattern form according to data sources such as form request that search module returned and the data model in the binding data storer, peripheral database, model data, files.
User behavior analysis unit 53: the ID of obtaining in the search module, the keyword message of input, user-selected report messages are preserved in this unit, and to content analysis processing, when user search, can help the user to locate form rapidly; It is privately owned form that the form that display unit generated is preserved in this unit; This helps to reduce user's operation and can satisfy the customization requirement of user to form.
Report data storage area 54: storage report form template, no pattern form and report style.Wherein, report form template: defined structure, form content sources mode, the type of form, the report parameter of form, this part is used to generate fixedly form, and template can also can be through the specialized system maintenance management through hand-coding.Report style: definition report style, the background that comprises report style, theme, font, field formatization, whether be shown as information such as icon, this partial content can be a hand-coding, also can pass through the specialized system maintenance management.
Form authority unit 55: the maintenance to the authority of content in form model, the form is provided; Simultaneously when search to Query List, when showing form the content of showing is controlled, thereby guarantee that form is used safely.
Form display unit 56: selection to report style is provided, dynamic refresh display effect when pattern is selected to change, provides report parameter reset, can preserve structure of report, report style as privately owned form.
Database 57: the data source of form (report data is kept in the database usually)
Peripheral data model 58: defined the relational model (concerning between data dimension and the data metric) of analytical statement, this part is nonessential for great majority are used.
Adapter 59: it is mutual to obtain preservation information hereof to realize that reporting system and file carry out.
Other formatted file 60 such as text: preserve data source hereof, through with adapter carry out report generation alternately.
Pass through the preferred embodiment; Introduce in the present embodiment search module simplified user's operating process, support the several data source help to the integrated of multiple business and expansion; Be separated through report style and report form template simultaneously and satisfy user's individual demand, record, analysis, guides user behavior make the easy to operate of form and have hommization.
Embodiment two
Present embodiment provides a kind of generation method of reporting system, and present embodiment has combined the foregoing description and preferred implementation wherein, and present embodiment is handled report data based on user behavior analysis, and this method may further comprise the steps:
Step 1: through manual mode or specialist tools is reporting system definition report form template; Create report style through manual mode or specialist tools.
Step 2: the User login system, obtain ID.
Step 3: according to ID, the historical key word input condition of inquiring user, obtain the forward key word of system queries, help the user to import with this.
Step 4: the form that obtains the key word of user input, satisfies condition according to keyword query; Obtain ID, the Report List that obtains is filtered, and be shown on the interface selective.
Step 5: the keyword message of preserving ID and input.
Step 6: obtain the form that the user selects, be submitted to the report generation unit to the report form template after being provided with.
Step 7: generate no pattern form according to data source information such as the Reports module sign of selecting or data model form, binding data storehouse, files.
Step 8: obtain the report style information of user's selection and generate final displaying result according to the pattern that the user selects.
Step 9: for satisfying users ' individualized requirement, the user can reselect pattern or Reparametrization.
Step 10: the user preserves revising content.
Through this preferred embodiment, realized that quick location form, number of ways generate form, the simple and convenient form of checking, preserve user's use habit, make reporting system better be dissolved in the large-scale application and let the use of form become convenient and have hommization.
Embodiment three
Present embodiment provides a kind of reporting system; Present embodiment has combined the foregoing description and preferred implementation wherein; Present embodiment provides a kind of report data generation method, and the step in the present embodiment is handled based on the module in the reporting system shown in Figure 5.
Form search unit 51 provides simple search interface, Advanced Search interface, and this unit can adopt following three kinds of modes for the user service to be provided.
Mode one: after the User login system, this unit obtains ID, from user behavior analysis unit 53, obtains user's historical Keyword List, obtains the forward focus speech of current system input simultaneously, imports key word with assisting users.
Mode two:, then mate key word and report name, the data rows title of form, the metric title in the data model of input if the user is chosen as simple search; If what the user selected is Advanced Search, then use each key word in the Advanced Search that specific part is filtered.
Mode three: the Report List that obtains is realized filtering through authority module, in Query List, shows the Report List that obtains; The key word of preserving user's input is in user behavior analysis unit 53.
No pattern form of report messages generation that report generation unit 52 is selected through obtaining the user.
Preferably, can adopt following mode to handle corresponding to three kinds of data sources:
(1) data source is a database:
Data source derives from database in the report form template that the user selects, then obtain earlier template the data source script, connect database carry out script, according to field that defines in the report form template and expression formula generate report data, its implementation procedure is specifically as shown in Figure 6.
(2) data source is a file:
Data source derives from file in the report form template that the user selects, if file layout definition standard (can visit) through database-driven, its implementation procedure and deal with data source be class database seemingly; If file layout more complicated; Then need realize an adapter for the type file; Adapter is accomplished the command request of instrument is handled (obtain the row name list that comprises in the file, obtain the tabulation of row field type, certain row filtered, obtain the result set of file); System generates report data according to field that defines in the template and expression formula again, and its implementation procedure is as shown in Figure 8.
(3) data source is a data model:
User-selected report data source derives from data model; Report generation unit 52 is converted into the discernible queried for items of data model according to define field in the template and expression formula; Send queried for items and query term then and give " data model "; " data model " generates corresponding data according to request, returns to 52 backs, report generation unit to data and generates final report data, and its implementation procedure is as shown in Figure 9.
Form authority unit 55 is used to control the form and the form content of user-accessible.This unit can everyly carry out control of authority through following three kinds:
Mode one: definition authority items, exercisable form of authority items or form content.
Mode two: definition user and the authority project that is had.
Mode three: when the user asks form, obtain this user's authority items earlier according to ID, obtain all exercisable Report Lists according to authority items again, and return to the user.
Form display unit 56 has the form and the privately owned report capability of displaying of showing current inquiry; Operation interface is showed the report style that current system can use, and dynamically generates form according to the pattern that the user selects, and operation interface provides the resetting of report parameter, the current form of checking is preserved the privately owned form as this user.
User behavior analysis unit 53 is connected to form display unit 56 and form search unit 51, through alternately to realize preservation and the analysis to user profile.Particularly, the interactive processing mode of this module comprises following dual mode:
(1) mutual with form search module 51.
The definition tree is preserved user profile; A node in the corresponding tree of each user; There is a tabulation to be used to preserve this user's historical key word input condition on the user node, preserves all key words and identify the access times of each key word with tree; The User login system; After getting access to ID, system is the query history keyword message from the user profile tree, if do not exist; Then in this tree, set up this user's record; Keyword List is obtained in inquiry in the key tree then, and when in the user entered keyword when a part of, search module can mate automatically like this; After this user submitted search to, system was inserted into user's input information in the user profile tree in this user key words tabulation as key word; If there is not corresponding key word in the key tree, then increase this key word in tree, and its initial query number of times is set is 1, if exist, then the inquiry times of key word from increasing 1.
(2) mutual with form display unit 56.
Through the selected report style of a tree type (collection of similar IE) leading subscriber, Reports module and report parameter information; When the User login system; System obtains form according to ID from this tree; And at the shortcut of showing the interface display form, the user can this fast opens this form through direct double-click; At form display unit 56, the user is saved in this tree report style and the parameter that sets.
Embodiment four
Present embodiment provides a kind of report processing method based on user behavior analysis, and Fig. 6 is the process flow diagram based on the implementation method of the reporting system of user behavior analysis according to the embodiment of the invention, and as shown in Figure 6, this method comprises:
Step S602: after the User login system, obtain user's identification information.
Step S604: the privately owned Report List and the historical key word of this user that obtain the user according to user's sign.Check the form that the user collects through selecting privately owned form; During user entered keyword, historical key word is used for the assisting users input.
Step S606: the keyword message according to user's input is carried out query manipulation, shows the Report List that satisfies condition.
Step S608: obtain the user and select report form type,, then do not need to handle if selected report form type is a report form template; If selected report form type is a data model, the editing operation to this form then is provided, and is converted into the discernible report form template of system to editor's form.Obtain user's form and select template, obtain external data source, generate the form of no pattern.
Step S610: obtain the report style of user's selection and generate final report style effect.
Step S612: the form to revising is preserved the privately owned form as the user.
Embodiment five
Present embodiment provides a kind of report data generation method; Present embodiment has combined the foregoing description and preferred implementation wherein; In the present embodiment, data source derives from database, and Fig. 7 is that the data source according to the embodiment of the invention is the process flow diagram of generative process of the report data of database; As shown in Figure 7, this method comprises:
Step S702: obtain the report data source and carry out script.
Step S704: connect database, carry out corresponding script.
Step S706: obtain the data field and the expression formula that define in the report form template.
Step S708: generate corresponding value according to data field and expression formula.
Step S710: generate report data.
Embodiment six
Present embodiment provides a kind of report data generation method; Present embodiment has combined the foregoing description and preferred implementation wherein; In the present embodiment, data source derives from file report datas such as text, and Fig. 8 is that the data source according to the embodiment of the invention is the process flow diagram of generative process of the report data of file; As shown in Figure 8, this method comprises:
Step S802: obtain the form source and carry out script.
Step S804: judge whether file has custom adapter, if judged result is for being execution in step S806, otherwise execution in step S808.
Step S806: call the adapter access file.
Step S808: call the database mode access file.
Step S810: field or expression formula according to template definition generate corresponding value.
Step S812: generate report data.
Embodiment seven
Present embodiment provides a kind of report data generation method, and present embodiment has combined the foregoing description and preferred implementation wherein, and in the present embodiment, data source derives from file report datas such as text.
File beginning in the present embodiment is " fb48ce13-d4c1-4571-9d79-d9a463a2a1b1 "; Then be every capable field quantity (4 bytes; Character type)+write down line number (4 bytes in the file; Character type)+field 1 length (4 bytes, character type)+field 1 value .... field n length (4 bytes, character type)+field n value ...; The first line data form is: character length (4 bytes, character type+field_name; Data-type...) the form synoptic diagram is as shown in table 1 below:
Table 1 data layout synoptic diagram
Satisfy shown in the theing contents are as follows of file of this data layout:
fb48ce13-d4c1-4571-9d79-d9a463a2a1b1000400040009operid；int0016opername；varcharO007age；int0016phonenum；varchar000450000004john000224000850000001000450010005lilin000223000850000024000450020005james00022600131580000011111
Report form template formal definition in the present embodiment is represented as follows:
Table 2 report form template form signal table
| Employee number | Employee's name | Age | Telephone number |
| $operid | $opername | $age | $phonenum |
In the present embodiment, between file and reporting system, introduce adapter, the standard interface that this adapter completion system provides realizes that the configuration function of this interface is as shown in table 3 below.
Table 3 interface function configuration signal table
In the present embodiment, reporting system calls GetFieldNameList to interface message processor (IMP) and obtains the field title, and its tabulation of obtaining is as shown in table 4 below:
Table 4 obtains field title signal table
| The field sequence number | The field title |
| 1 | operid |
| 2 | Opername |
| 3 | age |
| 4 | phonenum |
Reporting system calls GetData to interface message processor (IMP) and obtains data list, and its tabulation of obtaining is as shown in table 5 below:
The data signal table that table 5 gets access to
| operid | Opername | age | phonenum |
| 5000 | john | 24 | 50000001 |
| 5001 | lilin | 23 | 50000024 |
| 5002 | james | 26 | 1580000011111 |
Reporting system is according to the field information of template definition and the information of obtaining from interface message processor (IMP), and it is as shown in table 6 below to generate report data:
Table 6 report data signal table
| Employee number | Employee's name | Age | Telephone number |
| 5000 | john | 24 | 50000001 |
| 5001 | lilin | 23 | 50000024 |
| 5002 | james | 26 | 1580000011111 |
Need to prove; If file structure more regular (between first behavior field row name, field and the field with < tab>symbol separate, second row between last behavior data, the each row of data with the separation of < tab>symbol, separate with the carriage return character between going and going); This mode can be directly through the database mode visit, and its data generating procedure is consistent with the database generative process.
Through present embodiment, can avoid in reporting system realizing reading file content and handling, the content that can increase complexity and the increase of system only is applicable to the file of this special format, can not be applicable to other formatted file.
Embodiment eight
Present embodiment provides a kind of report data generation method, and present embodiment has combined the foregoing description and preferred implementation wherein, and in the present embodiment, data source derives from data model.Fig. 9 is that the data source according to the embodiment of the invention is the process flow diagram of generative process of the report data of data model, and as shown in Figure 9, this method comprises:
Step S902: obtain user request information.
Step S904: according to report form template, be converted into the query term of data model.
Step S906: send query requests and obtain the query term data to data model.
Step S908: in data model, generate data.
Step S910: generate message data.
Embodiment nine
Present embodiment provides a kind of report data generation method, and present embodiment has combined the foregoing description and preferred implementation wherein, and in the present embodiment, data source derives from data model.
Data model in the present embodiment is for selling and retail information, and the inside includes a product inquiry theme, this inquiry theme as " product ", the query term that the inside comprises is as shown in table 7:
Table 7 query term signal table
| Sequence number | Query term |
| 1 | Product type |
| 2 | Name of product |
| 3 | Cost |
| 4 | Explanation |
| 5 | Date of manufacture |
Also defined in the present embodiment a name be called " the product details " and report form template, Data Source is from data model, each Field Definition information of its template is as shown in table 8 below:
Table 8 template field definition information signal table
| Name of product | Product type | Cost | Date of manufacture | Explanation |
| $Name | $Type | $CostPrice | $MakeTime | $Description |
In the present embodiment, when carrying out this template of requesting query, " " module is converted into current template field, querying condition the discernible form of data model and submits to data model generation unit.For example this system realizes being converted into the query requests to query term as shown in the table to report form template, and initiates the data query request to data model:
Table 9 query term signal table
| Template field | Query term |
| $Name | Name of product |
| $Type | Product category |
| $CostPrice | Cost |
| $MakeTime | Date of manufacture |
| $Description | Explanation |
Data model generates the report data of correspondence as shown in table 10 below according to the information of report form template definition.
Table 10 report data signal table
Data model returns to the data that generate " data generating unit " formation report data as shown in table 11 below.
Table 11 report data signal table
| Name of product | Product type | Cost (unit) | Date of manufacture | Explanation |
| Perfumed soap | Commodity | 2.00 | 20101101 | Commodity |
| …… | …… | …… | …… | …… |
Embodiment ten
Present embodiment provides a kind of report form generation method, and present embodiment has combined the foregoing description and preferred implementation wherein.This method comprises:
Step 1: suppose that current Zhang San has landed system, land the back system and obtain its sign 0001.
Step 2: when he imported " words " in the search edit box, the search edit box was listed " telephone traffic form "; After confirming input; Search module is searched according to " telephone traffic form " key word realization form, from Report List, finds form 1, form 2, form 3, form 4 these several forms, filters through authority again; Finally have only form 1, form 2, form 3 meet the demands.
Step 3: " the user behavior analysis module " in user list in increase the record of 0001 sign; And in 0001 sign, increase a tabulation; Be inserted into " telephone traffic form " in this tabulation, and key word is the access times 5 of " telephone traffic form " in the modification Keyword List.
Step 4: it is " telephone traffic is by employee's statistical report form " that the supposition user selects form, in the report generation unit, according to the Template Information of form and the form of a no pattern of database information generation.
Step 5: in the data display module, list pattern 1,2 two kinds of patterns of pattern in the report style tabulation, when the user selects wherein a kind of pattern; Show that form is according to selecting pattern to show; When the user selects to preserve form, then can in the user behavior analysis module, create one tree, increase by 0001 node; And in 0001 node, create one tree, in the tree of creating, preserve the user and select pattern, report form template, report parameter information.
Report form template title in the present embodiment is as shown in table 12 below:
Table 12 report form template title signal table
| The form sequence number | Report name |
| Form 1 | Telephone traffic is by teams and groups' statistical report form |
| Form 2 | Telephone traffic is by employee's statistical report form |
| Form 3 | Telephone traffic is statistical report form monthly |
| Form 4 | Telephone traffic is by a day statistical report form |
| Form 5 | Call loss amount statistical report form |
| Form 6 | Complain a type statistical report form |
The employee information signal table that table 13 system preserves
| Employee's job number | Employee's name |
| 0001 | Zhang San |
| 0002 | Li Si |
Information signal table in the table 14 form authority module
| Authority items | Can operate form |
| Authority 1 | Form 1, form 2, form 5, form 6 |
| Authority 2 | Form 3, form 4 |
Table 15 employee institute ownership limit information
| Employee's job number | Authority items |
| 0001 | Authority 1 |
| 0002 | Authority 2 |
Table 16 report style information
Table 17 Keyword List
| Sequence number | Key word | Access times |
| 1 | Form | 100 |
| 2 | The telephone traffic form | 4 |
| 3 | Statistical report form | 20 |
Need to prove; Can in computer system, carry out in the step shown in the process flow diagram of accompanying drawing such as a set of computer-executable instructions; And; Though logical order has been shown in process flow diagram, in some cases, can have carried out step shown or that describe with the order that is different from here.
Pass through the foregoing description; A kind of report form generation method and device are provided; Through obtaining the storage mode of form source data, go to obtain the form source data according to the corresponding interface of storage mode then, thereby can go to obtain the form source data through interface corresponding to different storage modes; Overcome and to have handled the data that are stored in the database in the correlation technique; The Data Source mode that reporting system is handled is more single, thereby causes the lower problem of reporting system efficiency ratio, has improved the treatment effeciency of reporting system.
Obviously; It is apparent to those skilled in the art that above-mentioned each module of the present invention or each step can realize that they can concentrate on the single calculation element with the general calculation device; Perhaps be distributed on the network that a plurality of calculation element forms; Alternatively, they can be realized with the executable program code of calculation element, carried out by calculation element thereby can they be stored in the memory storage; Perhaps they are made into each integrated circuit modules respectively, perhaps a plurality of modules in them or step are made into the single integrated circuit module and realize.Like this, the present invention is not restricted to any specific hardware and software combination.
The above is merely the preferred embodiments of the present invention, is not limited to the present invention, and for a person skilled in the art, the present invention can have various changes and variation.All within spirit of the present invention and principle, any modification of being done, be equal to replacement, improvement etc., all should be included within protection scope of the present invention.
Claims (11)
1. report form generation method is characterized in that may further comprise the steps:
Obtain the storage mode of form source data;
Call the corresponding interface of said storage mode and obtain said form source data;
Use said form source data and report form template to generate form.
2. method according to claim 1 is characterized in that, it is one of following that the storage mode of said form source data comprises:
Database, file, data model.
3. method according to claim 2 is characterized in that,
The storage mode of said source data is a file; The said interface that calls said storage mode correspondence obtains said form source data and comprises: the adapter function that calls the corresponding interface of said file obtains said form source data from said file; Wherein, Said adapter function is used for analyzing the data memory format of said file, and obtains said form source data according to said data memory format; Or
The storage mode of said source data is a data model, and the said interface that calls said storage mode correspondence obtains said form source data and comprises: the query term that obtains said data model according to said report form template; Calling the corresponding interface of said data model uses said query term from said data model, to obtain said form source data.
4. according to each described method in the claim 1 to 3, it is characterized in that, use said form source data and said report form template to generate form and comprise:
Use said form source data and said report form template to generate no pattern form;
Use said no pattern form and the report style that gets access to generate form.
5. method according to claim 4 is characterized in that, before the report style that uses said no pattern form and get access to generates form, also comprises: receive the definition of user to report style.
6. method according to claim 1 is characterized in that, before using said form source data and report form template generation form, also comprises:
Obtain the key word of user's input, and obtain the corresponding report form template of said key word; Perhaps,
Obtain said user's used report form template.
7. method according to claim 6 is characterized in that, also comprises:
Use tree structure to preserve said user's ID, the used key word of said user and/or system-key; Wherein, the used key word of said user and/or the said system-key of said tree structure preservation are used for when said user entered keyword, pointing out.
8. report generation device is characterized in that comprising:
First acquisition module is used to obtain the storage mode of form source data;
Calling module is used to call the corresponding interface of said storage mode and obtains said form source data;
First generation module is used to use said form source data and report form template to generate form.
9. device according to claim 8 is characterized in that, said calling module comprises:
First processing module; When the storage mode that is used for said source data is file; The adapter function that calls the corresponding interface of said file obtains said form source data from said file; Wherein, said adapter function is used for analyzing the data memory format of said file, and obtains said form source data according to said data memory format; Or
Second acquisition module when storage mode that is used for said source data is data model, obtains the query term of said data model according to said report form template; Second processing module is used for calling the corresponding interface of said data model and uses said query term to obtain said form source data from said data model.
10. according to Claim 8 or 9 described devices, it is characterized in that said first generation module comprises:
Second generation module is used to use said form source data and said report form template to generate no pattern form;
The 3rd generates module, is used to use said no pattern form and the report style that gets access to generate form.
11. device according to claim 8 is characterized in that, also comprises:
The 3rd acquisition module is used to obtain the key word of user's input, and obtains the corresponding report form template of said key word;
Perhaps,
The 4th acquisition module is used to obtain said user's used report form template.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011101452356A CN102810094A (en) | 2011-05-31 | 2011-05-31 | Report generation method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2011101452356A CN102810094A (en) | 2011-05-31 | 2011-05-31 | Report generation method and device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102810094A true CN102810094A (en) | 2012-12-05 |
Family
ID=47233801
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2011101452356A Pending CN102810094A (en) | 2011-05-31 | 2011-05-31 | Report generation method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102810094A (en) |
Cited By (19)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103530394A (en) * | 2013-10-22 | 2014-01-22 | 金蝶软件（中国）有限公司 | Method and device for report data expansion |
| CN103605801A (en) * | 2013-12-05 | 2014-02-26 | 用友软件股份有限公司 | Method and system for managing documents data |
| CN103646049A (en) * | 2013-11-26 | 2014-03-19 | 中国银行股份有限公司 | Method and system for automatically generating data report |
| CN104361040A (en) * | 2014-10-29 | 2015-02-18 | 中国建设银行股份有限公司 | Method and device for customized query |
| CN104424305A (en) * | 2013-09-04 | 2015-03-18 | 航天信息软件技术有限公司 | Method and device for on-line automatic data filling and reporting |
| CN104516864A (en) * | 2013-09-30 | 2015-04-15 | 北大方正集团有限公司 | Report generating method and report generating device |
| CN104572813A (en) * | 2014-11-26 | 2015-04-29 | 国家电网公司 | Report generation method and device |
| CN104750714A (en) * | 2013-12-30 | 2015-07-01 | 中国银联股份有限公司 | File generation system and method |
| CN105138504A (en) * | 2015-09-07 | 2015-12-09 | 北京恒华伟业科技股份有限公司 | Report generation method and report engine |
| CN105354309A (en) * | 2015-11-09 | 2016-02-24 | 浙江中之杰软件技术有限公司 | Report management system |
| CN105718495A (en) * | 2015-08-21 | 2016-06-29 | 哈尔滨安天科技股份有限公司 | Exporting method and system of database hierarchical HTML (Hypertext Markup Language) statement |
| CN105760370A (en) * | 2014-12-14 | 2016-07-13 | 云南电力调度控制中心 | Plug-in type report framework technology |
| CN105808538A (en) * | 2014-12-29 | 2016-07-27 | 深圳云之家网络有限公司 | Method and device for generating mobile report form |
| CN106970952A (en) * | 2017-03-09 | 2017-07-21 | 浙江中诚工程管理科技有限公司 | Report form generation method and system |
| CN108681674A (en) * | 2018-04-23 | 2018-10-19 | 平安科技（深圳）有限公司 | Reports module creation method, device, computer installation and storage medium |
| CN109255065A (en) * | 2018-09-18 | 2019-01-22 | 郑州云海信息技术有限公司 | A kind of method and reporting system of report form processing |
| CN109815433A (en) * | 2019-01-11 | 2019-05-28 | 平安科技（深圳）有限公司 | Method and device, storage medium and electronic equipment is locally stored in browser |
| CN111324579A (en) * | 2020-03-10 | 2020-06-23 | 畅捷通信息技术股份有限公司 | ERP file query method, system, terminal and storage medium |
| WO2020125463A1 (en) * | 2018-12-19 | 2020-06-25 | 益萃网络科技（中国）有限公司 | Report generation method and apparatus, computer device, and computer readable storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6377993B1 (en) * | 1997-09-26 | 2002-04-23 | Mci Worldcom, Inc. | Integrated proxy interface for web based data management reports |
| CN101308490A (en) * | 2008-04-28 | 2008-11-19 | 北京航空航天大学 | Dynamic report generation method and platform |
| CN101650711A (en) * | 2009-08-18 | 2010-02-17 | 深圳市科陆电子科技股份有限公司 | Method for generating report |
| CN101661460A (en) * | 2009-09-18 | 2010-03-03 | 上海宝信软件股份有限公司 | Method and device for generating management system report |
-
2011
- 2011-05-31 CN CN2011101452356A patent/CN102810094A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US6377993B1 (en) * | 1997-09-26 | 2002-04-23 | Mci Worldcom, Inc. | Integrated proxy interface for web based data management reports |
| CN101308490A (en) * | 2008-04-28 | 2008-11-19 | 北京航空航天大学 | Dynamic report generation method and platform |
| CN101650711A (en) * | 2009-08-18 | 2010-02-17 | 深圳市科陆电子科技股份有限公司 | Method for generating report |
| CN101661460A (en) * | 2009-09-18 | 2010-03-03 | 上海宝信软件股份有限公司 | Method and device for generating management system report |
Non-Patent Citations (1)
| Title |
|---|
| 李航: "复杂数据源报表模型的研究与实现", 《信息科技辑》 * |
Cited By (22)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104424305A (en) * | 2013-09-04 | 2015-03-18 | 航天信息软件技术有限公司 | Method and device for on-line automatic data filling and reporting |
| CN104516864A (en) * | 2013-09-30 | 2015-04-15 | 北大方正集团有限公司 | Report generating method and report generating device |
| CN103530394A (en) * | 2013-10-22 | 2014-01-22 | 金蝶软件（中国）有限公司 | Method and device for report data expansion |
| CN103646049A (en) * | 2013-11-26 | 2014-03-19 | 中国银行股份有限公司 | Method and system for automatically generating data report |
| CN103646049B (en) * | 2013-11-26 | 2016-08-17 | 中国银行股份有限公司 | The method and system of automatically generated data form |
| CN103605801B (en) * | 2013-12-05 | 2017-01-11 | 用友网络科技股份有限公司 | Method and system for managing documents data |
| CN103605801A (en) * | 2013-12-05 | 2014-02-26 | 用友软件股份有限公司 | Method and system for managing documents data |
| CN104750714A (en) * | 2013-12-30 | 2015-07-01 | 中国银联股份有限公司 | File generation system and method |
| CN104361040A (en) * | 2014-10-29 | 2015-02-18 | 中国建设银行股份有限公司 | Method and device for customized query |
| CN104572813B (en) * | 2014-11-26 | 2019-02-26 | 国家电网公司 | A kind of report generation method and device |
| CN104572813A (en) * | 2014-11-26 | 2015-04-29 | 国家电网公司 | Report generation method and device |
| CN105760370A (en) * | 2014-12-14 | 2016-07-13 | 云南电力调度控制中心 | Plug-in type report framework technology |
| CN105808538A (en) * | 2014-12-29 | 2016-07-27 | 深圳云之家网络有限公司 | Method and device for generating mobile report form |
| CN105718495A (en) * | 2015-08-21 | 2016-06-29 | 哈尔滨安天科技股份有限公司 | Exporting method and system of database hierarchical HTML (Hypertext Markup Language) statement |
| CN105138504A (en) * | 2015-09-07 | 2015-12-09 | 北京恒华伟业科技股份有限公司 | Report generation method and report engine |
| CN105354309A (en) * | 2015-11-09 | 2016-02-24 | 浙江中之杰软件技术有限公司 | Report management system |
| CN106970952A (en) * | 2017-03-09 | 2017-07-21 | 浙江中诚工程管理科技有限公司 | Report form generation method and system |
| CN108681674A (en) * | 2018-04-23 | 2018-10-19 | 平安科技（深圳）有限公司 | Reports module creation method, device, computer installation and storage medium |
| CN109255065A (en) * | 2018-09-18 | 2019-01-22 | 郑州云海信息技术有限公司 | A kind of method and reporting system of report form processing |
| WO2020125463A1 (en) * | 2018-12-19 | 2020-06-25 | 益萃网络科技（中国）有限公司 | Report generation method and apparatus, computer device, and computer readable storage medium |
| CN109815433A (en) * | 2019-01-11 | 2019-05-28 | 平安科技（深圳）有限公司 | Method and device, storage medium and electronic equipment is locally stored in browser |
| CN111324579A (en) * | 2020-03-10 | 2020-06-23 | 畅捷通信息技术股份有限公司 | ERP file query method, system, terminal and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102810094A (en) | Report generation method and device | |
| CN108733681B (en) | Information processing method and device | |
| CN102521416B (en) | Data correlation query method and data correlation query device | |
| US9753960B1 (en) | System, method, and computer program for dynamically generating a visual representation of a subset of a graph for display, based on search criteria | |
| CN101971165A (en) | Graphic representations of data relationships | |
| CN111506621B (en) | Data statistical method and device | |
| CN108664509B (en) | Method, device and server for ad hoc query | |
| JP5535062B2 (en) | Data storage and query method for time series analysis of weblog and system for executing the method | |
| CN110716952A (en) | Multi-source heterogeneous data processing method and device and storage medium | |
| CN103605848A (en) | Method and device for analyzing paths | |
| JP2019040598A5 (en) | ||
| CN107766396A (en) | resource data management method and device | |
| CN115905630A (en) | Graph database query method, device, equipment and storage medium | |
| CN111190965B (en) | Impromptu relation analysis system and method based on text data | |
| CN105138643A (en) | Patent retrieval system and retrieval method thereof | |
| CN111414361A (en) | Label data storage method, device, equipment and readable storage medium | |
| CN104572932A (en) | Method and device for determining interest label | |
| US20160364426A1 (en) | Maintenance of tags assigned to artifacts | |
| CN105068879B (en) | A kind of method and device searched target and subscribed to | |
| CN104050264A (en) | Method and device for generating SQL statement | |
| US9542457B1 (en) | Methods for displaying object history information | |
| JPH11134361A (en) | Information presenting device and method therefor | |
| CN108241624B (en) | Query script generation method and device | |
| GB2520993A (en) | Indexing presentation slides | |
| CN101405727A (en) | Management of statistical views in a database system |
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: 20121205 |