CN101719120A - Method for dynamically generating and processing report data - Google Patents
Method for dynamically generating and processing report data Download PDFInfo
- Publication number
- CN101719120A CN101719120A CN201010300871A CN201010300871A CN101719120A CN 101719120 A CN101719120 A CN 101719120A CN 201010300871 A CN201010300871 A CN 201010300871A CN 201010300871 A CN201010300871 A CN 201010300871A CN 101719120 A CN101719120 A CN 101719120A
- Authority
- CN
- China
- Prior art keywords
- report
- processing
- report data
- data
- user
- 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
Abstract
The invention relates to a processing technology of report data, in particular to a method for dynamically generating and processing report data, aiming at the problems that the report generating manner is constant and the file format is not universal in the prior art. In the invention, a user self-definition report manner and a database value mode are adopted to realize the automatic generation of the report. The method for dynamically generating and processing the report data comprises the following steps of: a, defining the report manner by a user; b. defining the report database value mode by the user; c, operating and processing in an EXCEL and displaying the processing result of the report data; and d, saving the displayed processing result of the report data as a standard form. The invention solving the problems that the manner is constant and the film format is not universal in report generation, thereby ensuring that the user can effectively, flexibly and conveniently take values from the appointed database to automatically generate a corresponding report file with a universal format. The invention is used for making various data reports and report data analysis.
Description
Technical field
The present invention relates to the report data treatment technology, particularly a kind of method of carrying out report generation and data processing according to user definition.
Background technology
It is a data processing technique that application is very general that the computing machine report data is handled, and people can utilize computing machine that some data in production and the life are analyzed, and are made into various statistical report forms.Traditional report output all is to adopt the mode of form to carry out, and generally is in the operational process of application program data to be directly inputted in the corresponding form.The form of its output can be the webpage, XML form Excel form of browser etc., and prior art all is that the mode of disposable generation realizes when adopting operation, generates specific form, the pattern relative fixed of form at a certain series products.Its major defect is a report file form disunity, generally can not open and handle with general spreadsheet; Perhaps promptly allow to open, table style can not reach the form of user expectation, can't satisfy the various needs of user.The form that generates according to existing method does not have extensibility, does not possess versatility, is unfavorable for the follow-up processing again of report data yet.If the change report style also needs the update software source code, serious depended software provider not only can not directly use for the user in time, and revises source code cost height, and is inconvenient to safeguard.
Summary of the invention
Technical matters to be solved by this invention just provides a kind of method for dynamically generating and processing report data, adopts the user independently to define report style and database value mode, realizes the automatic generation of form.
The present invention solve the technical problem, and the technical scheme of employing is that method for dynamically generating and processing report data may further comprise the steps:
A, user definition report style;
B, user definition report database value mode;
C, operation and processing in electrical form show the report data result;
D, the report form processing result who shows is saved as criteria table.
Further, step c comprises:
C1, the report data result is carried out multidimensional analysis handle;
The report style and/or the report database value mode of c2, modification definition.
Concrete, described criteria table comprises XML form, Excel form.
The invention has the beneficial effects as follows, having solved in the report generation pattern effectively fixes and the uncurrent problem of file layout, thereby make the user can be efficiently, flexibly, easily by data designated storehouse value, generate the report file of corresponding general format automatically.
Embodiment
Describe technical scheme of the present invention in detail below in conjunction with embodiment.
Method for dynamically generating and processing report data of the present invention, report style and database value mode independently define by the user, and in operational process, the user can carry out analyzing and processing to the data result, revise report style or database value mode, also can revise report style and database value mode simultaneously, have the Efficient and Flexible characteristics.
Embodiment
After setting up database, carry out following steps:
The first step is according to the suitable report style of data structure definition;
Second step, definition report database value mode;
The 3rd step, the connected reference database, and obtain corresponding primary data and in electrical form, handle; The user can have multiple mode to realize in this process, such as message transmission of data base querying, file polling, user-defined format etc., display result data in form if desired, then the data of gathering are reprocessed, for example carry out statistical study, sue for peace, ask calculating such as average, display process result then;
In this step, the user can carry out multidimensional analysis to the report data result and handle, and handles as common 2-D data structured data.The 2-D data structure refers to have the set of the tuple of same alike result, and its most important characteristic is that the attribute of all tuples must be the same.Such as relational data table, bivariate table or the like.The 2-D data structure is a custom data version, the data of report display are corresponding consistent with the form of form, and just the same with form have a row and column structure, and the data organization that this data structure helps form is the parameter input, so that in the importing form, form the form content.The user can also be in this step, and the report style of modification definition, report database value mode etc. make it satisfy the requirement that actual statement analysis is handled.
The 4th step, result is imported criteria table, as the Excel table, finish report form processing.
Claims (3)
1. method for dynamically generating and processing report data may further comprise the steps:
A, user definition report style;
B, user definition report database value mode;
C, operation and processing in electrical form show the report data result;
D, the report form processing result who shows is saved as criteria table.
2. method for dynamically generating and processing report data according to claim 1 is characterized in that step c comprises:
C1, the report data result is carried out multidimensional analysis handle;
The report style and/or the report database value mode of c2, modification definition.
3. method for dynamically generating and processing report data according to claim 1 and 2 is characterized in that, described criteria table comprises XML form, Excel form.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201010300871A CN101719120A (en) | 2010-01-28 | 2010-01-28 | Method for dynamically generating and processing report data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201010300871A CN101719120A (en) | 2010-01-28 | 2010-01-28 | Method for dynamically generating and processing report data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101719120A true CN101719120A (en) | 2010-06-02 |
Family
ID=42433694
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201010300871A Pending CN101719120A (en) | 2010-01-28 | 2010-01-28 | Method for dynamically generating and processing report data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101719120A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102129449A (en) * | 2010-01-15 | 2011-07-20 | 微软公司 | Dynamic expansion of data calculation scopes |
| CN102346052A (en) * | 2010-08-04 | 2012-02-08 | 芜湖力创华羿电子科技有限公司 | System and method for detecting equipment state |
| CN105138497A (en) * | 2015-07-13 | 2015-12-09 | 深圳市永兴元科技有限公司 | Report uploadingmethod in report system and report system |
| CN107241227A (en) * | 2017-06-29 | 2017-10-10 | 济南浪潮高新科技投资发展有限公司 | A kind of configuration of network data form and generation method |
| CN113051881A (en) * | 2021-04-02 | 2021-06-29 | 北京神州数字科技有限公司 | Report display method based on parameter configuration |
-
2010
- 2010-01-28 CN CN201010300871A patent/CN101719120A/en active Pending
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102129449A (en) * | 2010-01-15 | 2011-07-20 | 微软公司 | Dynamic expansion of data calculation scopes |
| CN102129449B (en) * | 2010-01-15 | 2015-09-16 | 微软技术许可有限责任公司 | The dynamic expansion of data computer capacity |
| CN102346052A (en) * | 2010-08-04 | 2012-02-08 | 芜湖力创华羿电子科技有限公司 | System and method for detecting equipment state |
| CN105138497A (en) * | 2015-07-13 | 2015-12-09 | 深圳市永兴元科技有限公司 | Report uploadingmethod in report system and report system |
| CN107241227A (en) * | 2017-06-29 | 2017-10-10 | 济南浪潮高新科技投资发展有限公司 | A kind of configuration of network data form and generation method |
| CN107241227B (en) * | 2017-06-29 | 2020-04-14 | 浪潮集团有限公司 | Configuration and generation method of network data report |
| CN113051881A (en) * | 2021-04-02 | 2021-06-29 | 北京神州数字科技有限公司 | Report display method based on parameter configuration |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101719120A (en) | Method for dynamically generating and processing report data | |
| CN104699803B (en) | It is a kind of to meet that more bores report and submit the XBRL compiling and assembling methods of requirement | |
| CN105843945A (en) | Report generation method and system | |
| JP2010518516A5 (en) | ||
| CN106776962A (en) | A kind of general Excel data import multiple database physical table methods | |
| CN110276059B (en) | Dynamic report processing method and device | |
| AU2017322114A8 (en) | Real-time document filtering systems and methods | |
| Kessler et al. | Relax: A webbased execution and learning tool for relational algebra | |
| CN107943863B (en) | Agile modeling method and system based on business intelligence | |
| CN202929672U (en) | Traditional Chinese medicine quality safety traceable supervisory system | |
| CN110674163A (en) | Heterogeneous data query system and method based on BS framework | |
| Wang et al. | Performance assessment of peanut production in China | |
| CN104951565A (en) | XML configuration maintenance method and system based on memory database | |
| Valencia Parra et al. | CHAMALEON: framework to improve data wrangling with complex data | |
| CN103631767A (en) | Automatic generation method of universal data report | |
| CN104765800A (en) | Big data based efficient search method | |
| CN106570119A (en) | Device for quickly obtaining product information and method for obtaining product information | |
| CN109710241A (en) | A kind of visual data model arranging system and method for combination | |
| CN102508990A (en) | Online game data updating method | |
| CN101256487A (en) | Method for representation of service rule facing to component | |
| CN101604311A (en) | Breaking away industrial configuration software database interface is realized the method for historical data report | |
| Fang et al. | A diagnosis optimization system for grain processing based on multiple data analysis algorithms | |
| CN111143356A (en) | Report retrieval method and device | |
| CN104866485A (en) | Method for downloading mass data on data platform | |
| Chen et al. | Does a Digital Health Application Could Be the Supplement to the Influenza Surveillance 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 | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Open date: 20100602 |