CN1614589A

CN1614589A - Report generating system and method

Info

Publication number: CN1614589A
Application number: CN 200310112094
Authority: CN
Inventors: 罗辑; 黄韦道; 徐伟烨
Original assignee: Hongfujin Precision Industry Shenzhen Co Ltd; Hon Hai Precision Industry Co Ltd
Current assignee: Hongfujin Precision Industry Shenzhen Co Ltd; Hon Hai Precision Industry Co Ltd
Priority date: 2003-11-08
Filing date: 2003-11-08
Publication date: 2005-05-11
Anticipated expiration: 2023-11-08
Also published as: CN100412858C

Abstract

A report generating system is operated on the network server and is connected to multiple client end, a databank and at least one external system. The system comprises a data maintenance module for presetting data, a user boundard surface module for managing user's request, a data collection module for collecting data, a data supply module for generating data required by the report, a report generating module for forming report webpage based on dynamic webpage and data supplied by data supply module.

Description

Report generating system and method

[technical field]

The present invention particularly may operate on the webserver about a kind of about a kind of report generating system and method, can dynamically generate form and keep the report generating system and the method for report data comparability according to customer requirements.

[background technology]

Large enterprise's all operations information is loaded down with trivial details, is dispersed in each department, and enterprise headquarters is for realizing the performance analysis purpose, need from each department respectively acquisition of information classify again and gather, work out the performance analysis form at last, waste a large amount of manpowers, financial resources and time.Especially the frequent change of organization structure of enterprise makes the information manageability more not be dispersed in all departments, and the data comparability before and after the change also is difficult to realize, is unfavorable for the performance analysis and the management work of enterprise.Therefore, a typical report generating system not only requires in time, accurately generates various forms automatically, and requires to keep the comparability of each annual data, keeps the unanimity on the statistical standard.Along with Internet technology, the particularly fast development of dynamic web page generation technique, can provide the interactive site design of on-line checking more and more ripe, the system architecture (client only needs a Web browser) of its simple type client (Thin Client Side) obviously is better than having the Distributed Programming of close function, therefore is widely used in each field.

As the 6th, 055, No. 541 patents of the U.S. of bulletin on April 25th, 2000, patent name is " report automatic generatioin system " (Automatic Report Generating System).This patent provides a kind of report automatic generatioin system, can utilize Web browser to carry out interactive operation by the internet.With reference to shown in Figure 1, be the system architecture diagram of the 6th, 055, No. 541 patents of the U.S. " report automatic generatioin system ".This system is made up of client 120 and server end 140, links together by internet/Intranet 160.In client 120 on one side, client computer 180 operation Web browsers.This client computer 180 can be the computing machine of any suitable type, for example Apple computer, IBM compatible and unix station etc.At server end 140 on one side, Web server 200 can be any suitable main frame.This Web server 200 can move the information server (Internet Information Server) 220 of Microsoft, supports dynamic state server webpage framework (Active Server Pages Framework) 240 and script executing engine (Scripting Engine) 260.The request that information server 220 sends according to Web browser uses ASP (Active Server Pages) file 300 to generate hypertext, and (HypertextMarkup Language, HTML) file 280, return to give client 120.

The 6th, 055, No. 541 patent utilization dynamic web page generation techniques of the above-mentioned U.S. generate the CAD design chart automatically, and main deficiency is that the data that comprises in its database is static constant, and application is limited to utilize static data to generate dynamic chart.And it can't satisfy the requirement of form to the data comparability.

[summary of the invention]

Fundamental purpose of the present invention is to provide a kind of report generating system and method, and it operates on the Web server, can dynamically generate form according to customer requirements.

Another object of the present invention is to provide a kind of report generating system and method, it keeps the comparability of report data by the maintenance to organization change.

For achieving the above object, the invention provides a kind of report generating system, it operates on the Web server, link to each other with a plurality of clients, a database and at least one external system, can dynamically generate form according to customer requirements, this system includes: a data maintenance module is used for safeguarding that the report generation process needs default data; One subscriber interface module is used for the leading subscriber request; One Data acquisition, module is used for according to the predefined form data collection of data maintenance module; One data provides module, is made up of a plurality of storing processs that Gong call, and is used for the form request according to the subscriber interface module collection, collects the required data of form that generates from database; One report generation module, the data and the dynamic web page generation technique that utilize data to provide module to provide generate the webpage that contains corresponding report.

The present invention also provides a kind of report form generation method, and it includes following steps: (a) safeguard basic document; (b) Data acquisition; (c) receive the request of user's form; (d) provide the corresponding data of asking form; (e) select the organization change version; (f) generate form.

Report generating system of the present invention and method operate on the Web server, can dynamically generate form according to customer requirements, have improved the efficient of Data acquisition, and the accuracy of this data.In addition, the present invention decomposes, rejects or merge the data before and after the change by the maintenance to business organization change, thereby has guaranteed the comparability of report data, is beneficial to enterprise's comparison and analysis of carrying on the work.

[description of drawings]

Fig. 1 is the system architecture diagram of the 6th, 055, No. 541 patents of the U.S. " report automatic generatioin system ".

Fig. 2 is the network computer system Organization Chart of report generating system of the present invention.

Fig. 3 is the functional block diagram of report generating system of the present invention.

Fig. 4 is the operation process chart of report form generation method of the present invention.

[embodiment]

With reference to shown in Figure 2, for realizing the network computer system Organization Chart of report generating system of the present invention.This network computer system includes a plurality of clients 10, a Web server 30, a report generating system 40, a database server 50, a database 51 and an external system 60.Wherein, a plurality of clients 10, Web server 30 and external system 60 link by a network 20.This network 20 can be internet or Intranet.Web server 30 can be the known suitable type in this field, and client 10 is simple type terminating machines, comes and Web server 30 mutual communications by operation Web browser (not marking).External system 60 is included as and generates any system that form is given information, and can provide the ERP system of many-sided data, also can provide the accounts receivable management system of special data.

Report generating system 40 operates on the Web server 30, dynamically generates form and transmits by network 20 according to customer requirements.This report generating system 40 also can visit long-range external system 60 by network 20, periodically collects to generate the form required information and it is stored in database 51 from external system 60.This database 51 is used for storing various information and the data that the report generation process needs.Report generating system 40 allows client 10 to login Web server 30 to obtain corresponding form by Web browser (not marking).

With reference to shown in Figure 3, be the functional block diagram of report generating system of the present invention.This report generating system 40 includes a data maintenance module 401, a subscriber interface module 402, a Data acquisition, module 403, a data module 404 and a report generation module 405 is provided.

Data maintenance module 401 is used for safeguarding that the report generation process needs default data, mainly comprises: user right, Data acquisition, field, report form template etc.Data maintenance module 401 comprises further that also an organization change safeguards submodule 4011, and this organization change safeguards that submodule 4011 is used to safeguard the structure and the change resume of each organization of enterprise, and according to its change, sets different versions.As the organization structure of the enterprise being divided into three layers, be respectively cause group, cause place, department, no matter which hierarchical structure change, organization change is safeguarded submodule 4011 upgrade in time time and version, and preserves old version in order to calling.But the user also can select version by the direct mode of importing version number to take out of automatically and corresponding version of this time input time.Be the not ease of manageability of avoiding the frequent organization change of enterprise to bring to version, version number can be divided into two joints, and promptly a joint is represented the version number of times, the second joint expression change time.Can represent that as 00320030204 this version is the third edition, the tissue change took place on February 4th, 2003.The version of different times is stored in the database 51.

Subscriber interface module 402 is used for the leading subscriber request, and this user's request includes logging request and form request.When client 10 was logined report generating system 40 by Web browser (not marking), this subscriber interface module 402 provided user's login interface (not marking) to confirm user right, generates corresponding user according to user right again and logins homepage.Logining the user provides a plurality of hyperlink on the homepage, in order to send the request to a plurality of forms.Described form request is meant that the form to having safeguarded sends request in report form template, comprise dynamic operation prediction summary sheet, cause group's profit and loss weight structural table, cost rate and operation cost rate trend, cause group's business revenue comparation and assessment table and the cause group comparation and assessment table etc. of making a profit.Every class form can be selected current form or the history comparative statements same period.

Data acquisition, module 403 is used for according to data maintenance module 401 predefined forms, by network manager's setup parameter, data collection from external system 60 periodically, or collect by the associated user regularly or the data of irregularly uploading, and it is stored in database 51.The source of data can be exemplified below: as the profit-and-loss report of central authorities finance, and the financial data at each cause group or cause place and manage performance prediction, the enterprise of the central enterprise planning target etc. of totally operating.This Data acquisition, module 403 can be write with known various suitable programming language, VB for example, VC, Java etc.The program interface that this Data acquisition, module 403 utilizes external system 60 to be provided is collected corresponding data, and the utilization structure query language (Structured Query Language, SQL) order with data storage in database 51.

Data provides module 404 to be made up of a plurality of storing processs that Gong call, and in order to the form request of collecting according to subscriber interface module 402, collects from database 51 and generates the required data of form, and transfer data to report generation module 405.Storing process is made up of a plurality of Structured Query Language (SQL) orders, and accessible database also obtains database data according to the search criterion in the sql command.When the user needs the history comparative statements same period, and this in period institutional framework change, thereby when having influenced its comparability, data provides module 404 will select the same version of institutional framework, provide the different times data by this version, with data decomposition, rejecting or merging, keep the statistical standard unanimity of comparing data with this.

Data and dynamic web page generation technique that report generation module 405 utilizes data to provide module 404 to be provided generate the webpage that contains corresponding report.This report generation module 405 is defined as a plurality of types with the form request, and (Active ServerPages ASP) writes corresponding ASP file for every kind of form request promptly to utilize the dynamic state server webpage of Microsoft.This report generation module 405 is called the storing process that data provides module 404 by the program in the ASP file.When client 10 is clicked hyperlink on its login homepage, when sending the request to form, corresponding ASP file is promptly dynamically compiled generates the webpage that contains form, and (Hypertext Transfer Protocol, HTTP) client 10 is given in passback by HTML (Hypertext Markup Language).

With reference to shown in Figure 4, be the operation process chart of report form generation method of the present invention.Data maintenance module 401 is safeguarded needs default data in the report generation process, and organization change is safeguarded (step S400).Data acquisition, module 403 is according to data maintenance module 401 predefined forms, by network manager's setup parameter, periodically from external system 60, collect the required data of form that generates, and collect regularly or the data of irregularly uploading, and it is stored in database 51 (step S401) by the user.Client 10 is set up by Web browser (not marking) and the HTTP of report generating system 40 links, and sends logging request and form request (step S402).The form request that data provides module 404 to collect according to subscriber interface module 402 is collected from database 51 and is generated the required data of form, and transfers data to report generation module 405 (step S403).Data provides module 404 to select suitable institutional framework version (step S404) according to the form request simultaneously, when the user needs the history comparative statements same period, and this in period institutional framework change, thereby when having influenced its comparability, data provides module 404 will select the same version of institutional framework, provide the different times data by this version, with data decomposition, rejecting or merging, keep the statistical standard unanimity of comparing data with this.Data and dynamic web page generation technique that report generation module 405 utilizes data to provide module 404 to be provided generate the webpage (step S405) that contains corresponding report.

Claims

1. report generating system, it operates on the webserver, links to each other with a plurality of clients, a database and at least one external system, can dynamically generate form according to customer requirements, it is characterized in that this system includes:

One data maintenance module is used for safeguarding that the report generation process needs default data, comprising:

One organization change is safeguarded submodule, is used for maintenance organization structure and organization change;

One Data acquisition, module is used to collect the data that generates the form needs;

One data provides module, is used for according to customer requirements, and the data that form needs that generates is provided;

One report generation module is used to generate the form of customer requirements.

2. report generating system as claimed in claim 1 is characterized in that, also further includes a subscriber interface module, is used to receive login request of users and form request.

3. report generating system as claimed in claim 1 is characterized in that wherein organization change is safeguarded submodule maintenance organization structure and organization change, is organization change time and the respective version of upgrading in time, and preserves old version in order to calling.

4. report generating system as claimed in claim 3, it is characterized in that, wherein version can be used for needing comparative statements as the user, and this in period institutional framework change, thereby when having influenced its comparability, data provides module will select the same version of institutional framework, provides the different times data by this version, with data decomposition, rejecting or merging, keep the statistical standard unanimity of comparing data with this.

5. report generating system as claimed in claim 1 is characterized in that, data and dynamic web page generation technique that wherein report generation module utilizes data to provide module to provide generate the webpage that contains form.

6. report generating system as claimed in claim 1 is characterized in that, wherein data provide module to be made up of a plurality of storing processs that Gong call, and the database that this storing process visit is above-mentioned is also collected the required data of form that generates.

7. report form generation method, it can dynamically generate form according to customer requirements, this method is implemented by a report generating system, this report generating system operates on the webserver, link to each other with a plurality of clients, a database and at least one external system, can dynamically generate form according to customer requirements, it is characterized in that, this method comprises:

Maintenance organization change data;

Data acquisition;

Receive the request of user's form;

The corresponding data of request form is provided;

Select the organization change version;

Generate form.

8. report form generation method as claimed in claim 7, it is characterized in that, wherein select the organization change version to can be used for needing comparative statements as the user, and this in period institutional framework change, thereby when having influenced its comparability, will select the same version of institutional framework, provide the different times data by this version, with data decomposition, rejecting or merging, keep the statistical standard unanimity of comparing data with this.

9. report form generation method as claimed in claim 7 is characterized in that, wherein data provides by a plurality of storing processs that Gong call and forms, and the database that this storing process visit is above-mentioned is also collected the required data of form that generates.

10. report form generation method as claimed in claim 7, it is characterized in that, wherein generating form is the form that generates respective type according to each request, and the data and the dynamic web page generation technique that promptly utilize data to provide step to provide generate the webpage that contains form.