CN101477654A - Report generation system and method - Google Patents
Report generation system and method Download PDFInfo
- Publication number
- CN101477654A CN101477654A CNA2009100001018A CN200910000101A CN101477654A CN 101477654 A CN101477654 A CN 101477654A CN A2009100001018 A CNA2009100001018 A CN A2009100001018A CN 200910000101 A CN200910000101 A CN 200910000101A CN 101477654 A CN101477654 A CN 101477654A
- Authority
- CN
- China
- Prior art keywords
- report
- information
- mark
- module
- filtering conditional
- 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
Landscapes
- Financial Or Insurance-Related Operations Such As Payment And Settlement (AREA)
Abstract
The invention provides a report generating system and a method, wherein, the method comprises the following steps: acquiring the report mark and the filtering conditional information of the report to be generated, and adding the report mark and the filtering conditional information to a computation queue; invoking report computing element according to the report mark in the computation queue; computing to the correlated report data according to the filtering conditional information; and generating a report according to the computing result. By adopting the report generating system and the method provided by the invention, the computation efficiency of the system can be improved.
Description
Technical field
The present invention relates to data processing and application, more particularly, relate to a kind of report generating system and method.
Background technology
For enterprise, the demand of quick generation and accounting report is arranged all generally.For reducing the form calculated amount, generally adopt the mass data Redundancy Design to come accounting report.That is, in design during form,, the non-critical information field in other form is joined in the current table for reducing operation associated with other form.For example: had table 1 and table 2.
Table 1 key element expenses statement
Numbering | Key element expense title | Key element expense coding |
1 | Worker's emolument | 5009 |
2 | Manufacturing expense | 5008 |
3 | Completion output | 6008 |
4 | Material consumption norm | 6007 |
5 | Amortization charge | 6003 |
Table 2 cost center table
Numbering | The cost center title | Items of cost coding |
1 | Administrative unit | CM001 |
2 | Sky, Lu joint-stock company | CM002 |
3 | The pure company in green source | CM003 |
4 | Sky, Lu group | CM004 |
5 | The public work workshop | CM005 |
Hypothesis needs to increase a key element expense generation information table now, with the specifying information of knowing that cost takes place.For reduce key element expenses statement and cost center the table and key element expense generation information table between operation associated, mass data storehouse Redundancy Design can join the non-critical information field (as the key element expense title in the table, cost center title etc.) in key element expenses statement and the cost center table in the key element expense generation information table, generates the key element expense generation information table as table 3.
Table 3 key element expense generation information table
Numbering | The inventory coding | Key element expense numbering | Key element expense title | Key element expense coding | The cost center numbering | The cost center title | Items of cost coding | The amount of money | Price | ... |
1 | A00001 | 1 | Worker's emolument | 5009 | 2 | Sky, Lu joint-stock company | CM002 | 1000 | 12 | ... |
2 | A00002 | 1 | Worker's emolument | 5009 | 3 | The pure company in green source | CM003 | 2000 | 1 | ... |
3 | A00003 | 3 | Completion output | 6008 | 3 | The pure company in green source | CM003 | 50 | 9 | ... |
4 | A00004 | 4 | Material consumption norm | 6007 | 4 | Sky, Lu group | CM004 | 20 | 7 | ... |
5 | A00005 | 5 | Amortization charge | 6003 | 1 | Administrative unit | CM001 | 100 | 6 | ... |
As from the foregoing, newly-increased key element expense generation information table has increased fields such as key element expense title, key element expense coding, cost center title, items of cost coding, and these fields make data page increase, and memory data output increases.Because the increase of data page when visiting the record of same quantity, needs the data page of visit also to increase, and makes operational efficiency low.And, when maintenance update key element expenses statement and cost center table, the necessary respective field of upgrading synchronously in this key element expense generation information table, thereby the feasible inconvenience of safeguarding.
Summary of the invention
The present invention aims to provide a kind of report generating system and method, can improve running efficiency of system.
For realizing goal of the invention, described report generating system, comprise server and connected at least one client, this server comprises: queue management device, obtain report mark and filtering conditional information, report mark and filtering conditional information are added in the calculating formation from the form to be generated of at least one client; Data processing module calls the form computation module according to the report mark of calculating in the formation, according to filtering conditional information report data is calculated, and generates form according to result of calculation.
This server also can comprise: report mark memory module, storage report mark; Form property store module, storage form attribute information; The result of calculation memory module, storage form result of calculation.
The form attribute information can comprise statement heading information, statement form information and described form computation module.
This client can comprise: the report mark acquisition module, obtain the report mark of form to be generated according to the information of user input; The condition setting module provides the condition setting interface, obtains the filtering conditional information of form according to the information of user's input; Data transmit-receive module is sent to described server with report mark and filtering conditional information, and the form of reception server generation.
This server also can comprise: data transmit-receive module receive report mark and filtering conditional information that client sends, and the form that server is generated is back to client.
According to another aspect of the present invention, provide a kind of report form generation method, having comprised:
Obtain the report mark and the filtering conditional information of form to be generated, report mark and filtering conditional information are joined in the calculating formation; Call the form computation module according to the report mark of calculating in the formation, the corresponding report data are calculated, and generate form according to result of calculation according to filtering conditional information.
This method also can comprise: storage report mark and form attribute information.
The form attribute information can comprise statement heading information, statement form information and described form computation module.
This method also can comprise: the information according to user's input is obtained report mark and filtering conditional information.
This method also comprises: only store form result of calculation and do not store the form that comprises field.
The present invention can improve running efficiency of system.
Description of drawings
Fig. 1 is the structural representation of report generating system of the present invention;
Fig. 2 is the structural representation of report generating system in the one embodiment of the invention;
Fig. 3 is the inner structure synoptic diagram of database among Fig. 2;
Fig. 4 is the process flow diagram of report form generation method in the one embodiment of the invention;
Fig. 5 is the process flow diagram of report form generation method in the another embodiment of the present invention.
Embodiment
Fig. 1 shows report generating system of the present invention, and this system comprises server 100, and the mutual a plurality of clients (client 200, client 300...... client N) of the coupled line data of going forward side by side.
Fig. 2 shows the report generating system in the one embodiment of the invention, comprises server 100 and client 200, wherein:
Server 100 can comprise data transmit-receive module 101, queue management device 102, data processing module 103 and database 104, wherein:
Data transmit-receive module 101 receives report mark and the filtering conditional information that client 200 sends, and the form that server 100 is generated is back to client 200.
Queue management device 102 obtains the report mark and the filtering conditional information of form to be generated from client 200, this report mark and filtering conditional information are joined in the calculating formation, and after form calculating is finished, from calculate formation, remove this report mark and filtering conditional information.
Data processing module 103 calls corresponding form computation module according to the report mark of calculating in the formation, according to filtering conditional information the corresponding report data is calculated, and is generated form according to result of calculation.
Client 200 comprises data transmit-receive module 201, condition setting module 202 and report mark acquisition module 203, wherein:
Data transmit-receive module 201 is sent to server 100 with the report mark and the filtering conditional information of form to be generated, and the form that is generated that returns of reception server 100.
Condition setting module 202 provides the condition setting interface in client 200, obtains the filtering conditional information of form according to the information of user's input.
Report mark acquisition module 203 obtains the report mark of form to be generated according to the information of user's input.
Fig. 2 shows database shown in Figure 1 104.This database 104 comprises report mark memory module 1041, report data memory module 1042 and result of calculation memory module 1043, wherein:
1041 storages of report mark memory module are used for the report mark of the different forms of unique identification.For example, the corresponding unique report mark of key element expenses statement, and corresponding another the unique report mark of cost center table.
Form property store module 1042 storage form attribute informations.In one embodiment, the form attribute information comprises statement heading information, statement form information and form computation module etc.Statement heading information is the title of each form, and for example, the title of key element expenses statement is: " key element expenses statement ", the title of key element expense generation information table is: " key element expense generation information table ".Reporting format information comprises data presentation form and cell formats etc., and every form all has certain statement form, and shows form according to corresponding statement form.The form computation module promptly is used to handle some functions and the method for form arithmetic logic, is used for the corresponding data of form is calculated.
Result of calculation memory module 1043 storage form result of calculations.In one embodiment, obtain corresponding report data, and report data is handled, obtain result of calculation and storage according to filtering conditional information.
Fig. 4 shows the flow process of an embodiment of report form generation method of the present invention, and this method flow is based on system architecture shown in Figure 2, and detailed process is as follows:
Before carrying out following step, server 100 has been stored report mark and form attribute information, and the form attribute information comprises statement heading information, statement form information and form computation module etc.
In step S401, server 100 obtains the report mark and the filtering conditional information of form to be generated from client 200, and report mark and filtering conditional information joined calculates in the formation.
In step S402, server 100 calls the form computation module according to the report mark of calculating in the formation, according to filtering conditional information the corresponding report data is calculated, and is generated form according to result of calculation.
Fig. 5 shows the example of report generation process in the above-mentioned embodiment of the present invention, comprising:
In step S501, client 200 is obtained the report mark and the filtering conditional information of form to be generated according to user's input.In one embodiment, the information that the report mark acquisition module 203 of client 200 is imported according to the user is obtained the report mark of form to be generated, and each form all has a unique report mark, can know the form that the user will generate by report mark.Condition setting module 202 provides the condition setting interface, obtains the filtering conditional information of form according to the information of user's input.Be example with the table 1 in the preamble, table 2 still, stored key element expenses statement and cost center table shown in table 1, table 2 in database 104, condition setting module 202 provides the option (as the option of pull-down) of filtercondition to select for the user.The user can come by the option of this pull-down the filtercondition of form is provided with.For example, the user can select the filtercondition of " key element expense=worker's emolument ".
In step S502, the data transmit-receive module 201 of client 200 is sent to server 100 with report mark and the filtering conditional information of being obtained.
In step S503, the data transmit-receive module of server 100 101 receives report mark and the filtering conditional information that clients 200 send, and 102 of queue management devices join this report mark and filtering conditional information and calculate in the formation.Table 4 is the tables that calculate in the formation, can know the computing mode of form and filtering conditional information etc. from this table.
Table 4
Report mark | The filtercondition numbering | Computing mode |
iRlZX6BMQyOHzQcZoZBFTc5PzmM | 1 | 0 |
Wherein, iRlZX6BMQyOHzQcZoZBFTc5PzmM is the report mark of key element expense generation information table.Filtercondition is numbered the filtercondition of 1 expression " key element expense=worker's emolument ", and promptly in the key element expenses statement, its reference numeral is 1.Computing mode is represented the residing state of this form.In one embodiment, can be provided with 0 for calculating not initial state, 1 for calculating initial state, and 2 for calculating completion status.After having a plurality of clients (client 200,300......N) to submit the report mark of form to be generated to, can this report mark be joined according to the precedence of submitting to and calculate in the formation.Data processing module 103 takes out the report mark of obtaining the earliest and calculates when handling form, avoid a plurality of forms to submit to simultaneously handling and cause system responses slack-off.After calculating was finished, result of calculation can be stored in the result of calculation memory module 1043.
In step S504, data processing module 103 calls the corresponding report computation module according to the report mark of calculating in the formation, and according to filtering conditional information the corresponding report data is calculated.For example, it is related, as shown in table 3 to suppose that worker's emolument is called the inventory of " sky, Lu joint-stock company " and " green source alcohol company " with the cost center name.Data processing module 103 calls the corresponding computation module of this key element expense generation information table according to the report mark in the calculating formation, because its corresponding filtering conditional information is " a key element expense=worker's emolument ", then only need the corresponding data of inventory A0001 and A0002 is calculated.
In step S505, server 100 generates form and stores form result of calculation according to result of calculation, and the report data that generates is returned client 200 shows.For example, after the corresponding data of inventory A0001 and A0002 calculated, as shown in table 5 according to the form that result of calculation generates.
Table 5
Numbering | Key element expense coding | Key element expense title | Items of cost coding | The cost center title | The amount of money |
1 | 5009 | Worker's emolument | CM002 | Sky, Lu joint-stock company | 1000 |
2 | 5009 | Worker's emolument | Subtotal | 1000 |
3 | 5009 | Worker's emolument | CM003 | The pure company in green source | 2000 |
4 | 5009 | Worker's emolument | Subtotal | 2000 | |
5 | Add up to | 3000 |
Wherein, write down the key element expense total charge that satisfies " key element expense=worker's emolument " condition in the resulting result of calculation table.This result of calculation is stored in the result of calculation memory module 1043.Since calculate finish after storage computation result only, do not store the form that comprises above-mentioned all fields, therefore reduced memory space.
Queue management device 102 is removed the report mark and the filtering information of this form after calculating is finished from calculate formation.The data transmit-receive module 101 of server 100 is sent to client 200 with this result of calculation table, and 200 calculating of notice client are finished.The data transmit-receive module 201 of client 200 receives data, shows the form that includes result of calculation that is generated according to statement form information.In last example, the form that client 200 shows is as shown in table 6.
Table 6
After generating this form, when the user of client 200 need call this report data next time, directly submit report mark and filtercondition to, report mark that 100 bases of server get access to and filtering conditional information are taken out corresponding report attribute information and result of calculation, and these data (form attribute information, result of calculation etc.) are sent to client 200, client 200 is according to these data presentation forms, and need not to calculate once more, improved running efficiency of system.
The above only is preferred embodiment of the present invention, not in order to restriction the present invention, all any modifications of being done within the spirit and principles in the present invention, is equal to and replaces and improvement etc., all should be included within protection scope of the present invention.
Claims (10)
1, a kind of report generating system comprises server and connected at least one client, it is characterized in that described server comprises:
Queue management device obtains report mark and filtering conditional information from the form to be generated of described at least one client, and described report mark and filtering conditional information are added in the calculating formation;
Data processing module calls the form computation module according to the report mark of calculating in the formation, according to described filtering conditional information report data is calculated, and generates form according to result of calculation.
2, report generating system according to claim 1 is characterized in that, described server also comprises:
The report mark memory module, the storage report mark;
Form property store module, storage form attribute information;
The result of calculation memory module, storage form result of calculation.
3, report generating system according to claim 2 is characterized in that, described form attribute information comprises statement heading information, statement form information and described form computation module.
4, report generating system according to claim 1 is characterized in that, described client comprises:
The report mark acquisition module obtains the report mark of form to be generated according to the information of user input;
The condition setting module provides the condition setting interface, obtains the filtering conditional information of form according to the information of user's input;
Data transmit-receive module is sent to described server with described report mark and filtering conditional information, and receives the form that described server generates.
5, according to any described report generating system in the claim 1 to 4, it is characterized in that described server also comprises:
Data transmit-receive module receives report mark and filtering conditional information that client sends, and the form that server is generated is back to described client.
6, a kind of report form generation method comprises:
Obtain the report mark and the filtering conditional information of form to be generated, described report mark and filtering conditional information are joined in the calculating formation;
Call the form computation module according to the report mark of calculating in the formation, the corresponding report data are calculated, and generate form according to result of calculation according to described filtering conditional information.
7, report form generation method according to claim 6 is characterized in that, described method also comprises: storage report mark and form attribute information.
8, report form generation method according to claim 7 is characterized in that, described form attribute information comprises statement heading information, statement form information and described form computation module.
9, report form generation method according to claim 6 is characterized in that, also comprises: the information according to user's input is obtained described report mark and filtering conditional information.
10, according to any described report form generation method of claim 6 to 9, it is characterized in that, also comprise: only store form result of calculation and do not store the form that comprises field.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CNA2009100001018A CN101477654A (en) | 2009-01-04 | 2009-01-04 | Report generation system and method |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CNA2009100001018A CN101477654A (en) | 2009-01-04 | 2009-01-04 | Report generation system and method |
Publications (1)
Publication Number | Publication Date |
---|---|
CN101477654A true CN101477654A (en) | 2009-07-08 |
Family
ID=40838362
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CNA2009100001018A Pending CN101477654A (en) | 2009-01-04 | 2009-01-04 | Report generation system and method |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN101477654A (en) |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102467539A (en) * | 2010-11-15 | 2012-05-23 | ***通信集团山东有限公司 | Data sheet calling method and device |
CN102750381A (en) * | 2012-06-28 | 2012-10-24 | 浙江吉利汽车研究院有限公司杭州分公司 | Method for realizing report function in Windchill system and report generation method |
CN103186515A (en) * | 2011-12-28 | 2013-07-03 | 金蝶软件(中国)有限公司 | Data calculation method, system and equipment for spreadsheet |
CN103761219A (en) * | 2014-02-20 | 2014-04-30 | 西双版纳恒创信息科技有限公司 | Dynamic generating method of table |
-
2009
- 2009-01-04 CN CNA2009100001018A patent/CN101477654A/en active Pending
Cited By (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102467539A (en) * | 2010-11-15 | 2012-05-23 | ***通信集团山东有限公司 | Data sheet calling method and device |
CN102467539B (en) * | 2010-11-15 | 2014-09-03 | ***通信集团山东有限公司 | Data sheet calling method and device |
CN103186515A (en) * | 2011-12-28 | 2013-07-03 | 金蝶软件(中国)有限公司 | Data calculation method, system and equipment for spreadsheet |
CN102750381A (en) * | 2012-06-28 | 2012-10-24 | 浙江吉利汽车研究院有限公司杭州分公司 | Method for realizing report function in Windchill system and report generation method |
CN103761219A (en) * | 2014-02-20 | 2014-04-30 | 西双版纳恒创信息科技有限公司 | Dynamic generating method of table |
CN103761219B (en) * | 2014-02-20 | 2017-08-25 | 西双版纳恒创信息科技有限公司 | A kind of dynamic creation method of form |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
US9218379B2 (en) | Method, apparatus, and computer-readable medium for efficiently performing operations on distinct data values | |
US8566341B2 (en) | Continuous aggregation on a data grid | |
CN109710611B (en) | The method of storage table data, the method, apparatus of lookup table data and storage medium | |
CN109241067B (en) | Transaction data management method and device | |
CN101556678A (en) | Processing method of batch processing services, system and service processing control equipment | |
Zhang et al. | A capacitated facility location model with bidirectional flows | |
CN111178830B (en) | Cost accounting method, cost accounting device, computer equipment and storage medium | |
CN110738528B (en) | Rule freight rate preprocessing method and system | |
CN106372822B (en) | Service object reservation time period processing method and device | |
CN101477654A (en) | Report generation system and method | |
CN106844320B (en) | Financial statement integration method and equipment | |
US20230418879A1 (en) | System and method of data transformation | |
Fu et al. | Inventory and production decisions for an assemble-to-order system with uncertain demand and limited assembly capacity | |
CN102222285A (en) | Multi-dimensional data linkage computing device and multi-dimensional data linkage computing method | |
CN110471945A (en) | Processing method, system, computer equipment and the storage medium of alive data | |
CN107656943B (en) | Task query method and server | |
CN102508839B (en) | Data processing device and data processing method | |
CN114238397A (en) | User data processing method, device, equipment, storage medium and program product | |
Lu et al. | Evaluation of manufacturing system redesign with multiple points of product differentiation | |
CN100395752C (en) | Report data collection system and method | |
US20070198994A1 (en) | Document framework | |
CN102999554B (en) | Business data processing method and device | |
EP3486861A1 (en) | Inter-company information sharing system and inter-company information sharing method | |
CN113535727B (en) | Data output method and device of information system and electronic equipment | |
CN116187660A (en) | Order processing method, device, computing equipment and medium |
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 |
Application publication date: 20090708 |