CN101504642A - Report generation system and method - Google Patents
Report generation system and method Download PDFInfo
- Publication number
- CN101504642A CN101504642A CNA2009101293390A CN200910129339A CN101504642A CN 101504642 A CN101504642 A CN 101504642A CN A2009101293390 A CNA2009101293390 A CN A2009101293390A CN 200910129339 A CN200910129339 A CN 200910129339A CN 101504642 A CN101504642 A CN 101504642A
- Authority
- CN
- China
- Prior art keywords
- train value
- module
- value information
- row
- keyword message
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a report generation system, which comprises a setting module and a generation module, wherein the setting module sets column keyword information, column value information as well as correlation between the column keyword information and the column value information, and the generation module generates reports including the column keyword information and the column value information according to the correlation. The invention also discloses a report generation method. According to the report generation system and the method, dynamic change of report columns can be supported so as to reduce the maintenance cost for report generation.
Description
Technical field
The present invention relates to data processing field, particularly a kind of report generating system and method.
Background technology
(Enterprise Resource Planning, ERP) system can not realize the dynamic change of form row to existing Enterprise Resources Plan automatically to the form that generates when generating form.If will change the form column number, then must remodify code could realize, thereby causes the code logic complexity, the maintenance cost height.
Summary of the invention
The purpose of this invention is to provide a kind of report generating system and method for supporting form row dynamic change.
According to an aspect of the present invention, provide a kind of report generating system, comprising: module is set, the row keyword message is set, the association between train value information and row keyword message and the train value information; And generation module, according to the described related form that comprises described row keyword message and described train value information that generates.
According to another aspect of the present invention, provide a kind of report form generation method, comprising: the association between row keyword message, train value information and row keyword message, the train value information is set; According to the described related form that comprises described row keyword message and described train value information that generates.
According to the present invention, can support form row dynamic change, in that the form row be need not to revise code when dynamically changing, reduced maintenance cost.
Description of drawings
Fig. 1 is the structured flowchart of one embodiment of the invention report generating system.
Fig. 2 is the structured flowchart of generation module in the system shown in Figure 1.
Fig. 3 is the schematic flow sheet of one embodiment of the invention report form generation method.
Generate the schematic flow sheet of the form that comprises row keyword message and train value information in Fig. 4 method shown in Figure 3.
Fig. 5 is the data structure diagram that the row key table of module setting is set in the system shown in Figure 1;
Fig. 6 is the data structure diagram that the train value table of module setting is set in the system shown in Figure 1;
Fig. 7 is the data structure diagram that the contingency table of module setting is set in the system shown in Figure 1.
Embodiment
With reference to accompanying drawing, the object of the invention, function and advantage are described further by embodiment.
As shown in Figure 1, report generating system can comprise module 101 and generation module 201 are set.Module 101 is set is located at client 10.Client 10 also can comprise transceiver module 102.Generation module 201 can be located in the server 20.Server 20 also can comprise adjusting module 202 and database 203 (each business datum table in the storage ERP system).For example, one stock control ERP system, its database can be stored following business datum table: (data structure comprises name of material to the material MSDS, the material price, fields such as material production time) and the inventory list table (data structure comprises entry time, the outbound time, inventory locations, fields such as stockpile number) etc.
Wherein, the data structure of row key table as shown in Figure 5.Wherein, the critical field title can be provided with.The critical field title then can be chosen from the business datum table of database 203 storages.For example, by module 101 is set as shown in Table 1 row key table can be set.Wherein, the critical field title of FKEY1 to FKEY3 for being provided with.Critical field title " August 1 " reaches " August 2 " and can choose from inventory list table (entry time) by module 101 is set.Critical field title " name of material " can be chosen from the material MSDS by module 101 is set.
| The critical field title | The critical field title | The Value Data type |
| FKEY1 | August 1 | Numeral |
| FKEY2 | August 2 | Numeral |
| FKEY3 | Name of material | Character string |
Table one
The data structure of train value table as shown in Figure 6.Wherein, the train value field name can be provided with.Train value then can be chosen from the business datum table of database 203 storages.For example, by module 101 is set as shown in Table 2 train value table can be set.Wherein, FDATE1, FDATE2 and FITEMNAME train value field name for being provided with.Train value (for example, 1000,2000 and keyboard etc.) can be chosen from material MSDS (for example, material price and name of material) by module 101 is set.
| The train value field name | Train value |
| FDATE1 | 1000 |
| FDATE2 | 2000 |
| FITEMNAME | Keyboard |
| FDATE1 | 500 |
| FDATE2 | 3000 |
| FITEMNAME | Mouse |
Table two
The data structure of contingency table as shown in Figure 7.It comprises critical field title in the row key table and the train value field name in the train value table.For example, by module 101 is set as shown in Table 3 contingency table can be set.Critical field title in the table one and the train value field name in the table two have been comprised in the table three.
| The critical field title | The train value field name |
| FKEY1 | FDATE1 |
| FKEY2 | FDATE2 |
| FKEY3 | FITEMNAME |
Table three
The information that generation module 201 receives transceiver module 102 transmissions (contains the row keyword message, association between train value information and row keyword message and the train value information), generate the form that comprises described row keyword message and described train value information according to described association, and the form that generates is issued client 10.Generation module 201 is based on table one, and table two and table three can generate form as shown in Table 4.
| Sequence number | Name of material | August 1 | August 2 |
| 1 | Keyboard | 1000 | 2000 |
| 2 | Mouse | 500 | 3000 |
Table four
When adjusting module 202 is modified at the row header of the form that generates, to making amendment by the row keyword message that is provided with in the row key table that module 101 was provided with and was stored in database 203.And when the train value of the form that generates is modified, to making amendment by the train value information that is provided with in the train value table that module 101 was provided with and was stored in database 203.Thus, can keep the data of database 203 storages and the data consistent in the form.Database 203 is preserved row keyword message and the train value information of adjusting through adjusting module 202.
As shown in Figure 2, generation module 201 comprises first-born one-tenth module 2011 of row and train value generation module 2012.Be listed as first-born one-tenth module 2011 generates form according to the row keyword message that module 10 settings are set row header.For example, be listed as first-born one-tenth module 2011 and can add up the item number of critical field title, in the form that will generate, increase corresponding columns according to obtaining item number then, and the critical field title in the row key table is filled up to the row head of form, thereby generate the row header of form.Train value generation module 2012 is according to row keyword message and the association between the train value information (for example, passing through contingency table) that module 101 is provided with being set and the train value of the train value information generation form that module 101 is provided with being set.For example, train value generation module 2012 can be filled up to the train value in the train value table in the form according to contingency table, thereby realizes the generation of form.
Below in conjunction with Fig. 3 flow process according to the report form generation method of one embodiment of the present invention is described exemplarily, this method can realize by system shown in Figure 1, comprising:
Step S1 is provided with module 101 row keyword message and train value information is set, and related between row keyword message and the train value information.
Step S3, generation module 201 generate the form that comprises row keyword message and train value information according to the association that is provided with.
As shown in Figure 4, step S3 can comprise again:
Step S31, generation module 201 generate the row header of form according to the row keyword message that is provided with.
Step S32, generation module 201 generate the train value of form according to the train value information related and that be provided with between row keyword message, the train value information.
Above-mentioned report form generation method also can comprise:
Step S2, row keyword message and train value information that database 203 storage is provided with, and related between row keyword message and the train value information.
When step S4, adjusting module 202 are modified at the row header of the form that generates, the row keyword message of database 203 storages is made amendment; And/or when the train value of the form that generates is modified, the train value information of database 203 storages is made amendment.
The foregoing description is a preferred implementation of the present invention; but embodiments of the present invention are not restricted to the described embodiments; other any do not deviate from change, the modification done under spirit of the present invention and the principle, substitutes, combination, simplify; all should be the substitute mode of equivalence, be included within protection scope of the present invention.
Claims (8)
1. report generating system comprises:
Module is set, the row keyword message is set, the association between train value information and row keyword message and the train value information; And
Generation module is according to the described related form that comprises described row keyword message and described train value information that generates.
2. system according to claim 1, described generation module comprises:
Be listed as first-born one-tenth module, generate the row header of form according to the described row keyword message that the module setting is set;
The train value generation module is provided with the association of module setting and the train value that the described train value information that the module setting is set generates form according to described relation.
3. system according to claim 2 also comprises:
Adjusting module when the row header of the form of described generation is modified, is made amendment to the described row keyword message that the module setting is set; And/or when the train value of the form of described generation is modified, the described train value information that the module setting is set is made amendment.
4. system according to claim 3 also comprises:
Database, storage is provided with row keyword message and the train value information that module is provided with, or at adjusting module to after set row keyword message of module and/or train value information be set make amendment, row keyword message after the memory modify and/or train value information.
5. report form generation method comprises:
Association between row keyword message, train value information and row keyword message, the train value information is set;
According to the described related form that comprises described row keyword message and described train value information that generates.
6. method according to claim 5, described generation form comprises:
Generate the row header of form according to the row keyword message of described setting;
Generate the train value of form according to the train value information of the related and described setting between row keyword message, the train value information.
7. method according to claim 6 also comprises:
Store the row keyword message and the train value information of described setting.
8. method according to claim 7 also comprises:
When the row header of the form that generates is modified, the row keyword message of storage is made amendment; And/or when the train value of the form that generates is modified, the train value information of storage is made amendment.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2009101293390A CN101504642B (en) | 2009-03-23 | 2009-03-23 | Report generation system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2009101293390A CN101504642B (en) | 2009-03-23 | 2009-03-23 | Report generation system and method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101504642A true CN101504642A (en) | 2009-08-12 |
| CN101504642B CN101504642B (en) | 2011-04-20 |
Family
ID=40976892
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2009101293390A Active CN101504642B (en) | 2009-03-23 | 2009-03-23 | Report generation system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101504642B (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102184099A (en) * | 2011-04-15 | 2011-09-14 | 北京高森明晨信息科技有限公司 | Method, device and system used for configuring and generating application software report forms |
| CN103020750A (en) * | 2012-11-19 | 2013-04-03 | 北京数码大方科技股份有限公司 | Process report generation method and device |
| CN103678413A (en) * | 2012-09-25 | 2014-03-26 | 金蝶软件（中国）有限公司 | Method and device for displaying dynamic column of report |
| CN105005849A (en) * | 2015-06-29 | 2015-10-28 | 用友优普信息技术有限公司 | Process labor cost generating method and apparatus based on ERP system |
| CN105447068A (en) * | 2014-11-18 | 2016-03-30 | 国网山东省电力公司 | SAP system based dynamic report generation method and system |
| CN105893615A (en) * | 2016-04-27 | 2016-08-24 | 厦门市美亚柏科信息股份有限公司 | Owner feature attribute excavation method based on mobile phone forensics data and system thereof |
| CN109165838A (en) * | 2018-08-16 | 2019-01-08 | 郑州云海信息技术有限公司 | A kind of method of handling of goods and materials, ERP system and storage medium |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102467704A (en) * | 2010-11-10 | 2012-05-23 | 金蝶软件（中国）有限公司 | Method and system for generating data table of just-in-time inventory management |
-
2009
- 2009-03-23 CN CN2009101293390A patent/CN101504642B/en active Active
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102184099A (en) * | 2011-04-15 | 2011-09-14 | 北京高森明晨信息科技有限公司 | Method, device and system used for configuring and generating application software report forms |
| CN103678413A (en) * | 2012-09-25 | 2014-03-26 | 金蝶软件（中国）有限公司 | Method and device for displaying dynamic column of report |
| CN103678413B (en) * | 2012-09-25 | 2017-07-28 | 金蝶软件（中国）有限公司 | The methods of exhibiting and device of dynamic column of report |
| CN103020750A (en) * | 2012-11-19 | 2013-04-03 | 北京数码大方科技股份有限公司 | Process report generation method and device |
| CN105447068A (en) * | 2014-11-18 | 2016-03-30 | 国网山东省电力公司 | SAP system based dynamic report generation method and system |
| CN105005849A (en) * | 2015-06-29 | 2015-10-28 | 用友优普信息技术有限公司 | Process labor cost generating method and apparatus based on ERP system |
| CN105893615A (en) * | 2016-04-27 | 2016-08-24 | 厦门市美亚柏科信息股份有限公司 | Owner feature attribute excavation method based on mobile phone forensics data and system thereof |
| CN105893615B (en) * | 2016-04-27 | 2019-06-14 | 厦门市美亚柏科信息股份有限公司 | Owner's characteristic attribute method for digging and its system based on Mobile Phone Forensics data |
| CN109165838A (en) * | 2018-08-16 | 2019-01-08 | 郑州云海信息技术有限公司 | A kind of method of handling of goods and materials, ERP system and storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101504642B (en) | 2011-04-20 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101504642B (en) | Report generation system and method | |
| Fukao | Explaining J apan's Unproductive Two Decades | |
| Tassey | Competing in advanced manufacturing: The need for improved growth models and policies | |
| CA2497742A1 (en) | Real-time aggregation of data within an enterprise planning environment | |
| CN102567345A (en) | Method and device for generating bookkeeping voucher | |
| CN103019693A (en) | System and method for generating user interface | |
| US20120023445A1 (en) | Managing extension projects with repository based tagging | |
| CN101697123A (en) | Method and device for modifying interface layout in ERP system and ERP system | |
| CN102682108B (en) | Row and line mixed database storage method | |
| CN102567539A (en) | Intelligent WEB report implementation method and intelligent WEB report implementation system | |
| CN103246651A (en) | Method and system for data inputting | |
| CN102141992A (en) | Method for storing and querying multidimensional database | |
| CN106649729A (en) | Log running method and system, client and server | |
| CN102609488A (en) | Client, data query method of client, server and data query system | |
| CN110473080A (en) | A kind of report processing method, device and computer equipment | |
| CN104111994A (en) | Label data screening method and device based on mixed data source | |
| CN102110142A (en) | Method for dynamically expanding personnel transaction in human resource management information system | |
| US20140229222A1 (en) | Integrated project planning and management application | |
| CN103257987A (en) | Rule-based distributed log service implementation method | |
| Gao et al. | The challenges of coal phaseout: coal plant development and foreign finance in Indonesia and Vietnam | |
| US20040143588A1 (en) | Database model system and method | |
| CN111026756A (en) | Method for dynamically generating form and associated query | |
| CN103177008B (en) | Method and system used for generating and executing structured query language (SQL) statement | |
| CN101814064B (en) | Establishment method of report template, report generation method and report system | |
| CN102467527B (en) | Working desktop showing system and method and application server thereof |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |