CN101751436A - Method and system for generating reports - Google Patents

Abstract

The invention provides a method and device for generating reports to solve the problems of complex operation and data query errors in the prior art when querying data of multiple reports. The following method is described through the embodiment: for the selected main report, the corresponding relationship between the area in the main report and the preset query condition is set, and the query condition is used to determine the data in the associated report from the database; The query command that specifies the main report area is issued, and the query condition corresponding to the main report area specified by the query command is obtained according to the corresponding relationship; the data in the associated report is determined from the database according to the obtained query condition, and then the associated report is generated according to the data. report. The corresponding devices are given in the examples. According to the technical scheme of the invention, the report data query operation can be simplified and data query errors can be avoided.

Description

A method and device for generating reports

technical field

The present invention relates to the technical field of business technical support, in particular to a method and device for generating reports.

Background technique

At present, there are many methods and systems for generating reports. For example, the following method is disclosed in a Chinese patent application document with the application number CN01139172.3: grab report data from the data source; structure the data suitable for the form Description; select report format data items as required; use inter-process communication technology to call the general form processing process, and generate report files from the captured report data according to the content of the selected form data items.

Another example is that the general report production device disclosed in a Chinese patent application document with the application number CN200710173359.9 includes: a database for storing data source data; a data source definition file generation module for defining the location of the data source; a report file generation module, Generate report files; report server, store data source definition files and report files; login module, for users to log in to report server; Pass it to the report file; read the interface module, form a general input control according to the parameters, and receive the user's choice; the data source push module pushes the data source data stored in the database to the report file according to the user's choice, so as to generate the final data provided to the report file. Login user's report file.

According to the technical solution disclosed in the above-mentioned patent and other technical solutions in the prior art, when performing data query in multiple reports, in order to determine the data in the report from the database, query conditions need to be set before each query, and the operation It is cumbersome, and may cause inconsistencies in the query results of the same type of data in different reports due to improper setting of query conditions, resulting in data query errors.

Contents of the invention

The main purpose of the present invention is to provide a method and device for generating reports, so as to solve the problems of complex operation and data query errors in the prior art when querying data of multiple reports.

In order to solve the above problems, the present invention provides the following technical solutions:

A method of generating a report comprising:

For the selected main report, the corresponding relationship between the area in the main report and the preset query condition is set, and the query condition is used to determine the data in the associated report from the database;

receiving a query command specifying a main report area issued by a user, and obtaining a query condition corresponding to the main report area specified by the query command according to the corresponding relationship;

Determine the data in the associated report from the database according to the obtained query conditions, and then generate an associated report based on the data.

A device for generating reports, comprising:

The first storage module is used to save the corresponding relationship between the areas in the set main report and the preset query conditions, and the query conditions are used to determine the data in the associated report from the database;

A determination module, configured to receive a query command for specifying a main report area issued by a user, and obtain a query condition corresponding to the main report area specified by the query command according to the corresponding relationship;

The generation module is used to determine the data in the associated report from the database according to the determined query condition of the associated report, and then generate the associated report according to the data.

According to the technical scheme of the present invention, a corresponding relationship is established between the area of the main report and the query condition of the associated report, and the data acquisition of the associated report and the generation of the associated report are realized by selecting the area in the main report, so that the query of the associated report It can be realized by selecting the area in the main report, and the data query of the associated report can be performed only by presenting the main report, so there is no need to set the query condition every time the associated report is queried, and the operation is relatively simple; and because the query of the associated report The conditions are pre-set, and the query conditions can be pre-tested and confirmed to be correct, so it can ensure that the correct query conditions are given when performing data query of the associated report, thereby ensuring the correctness of the data query.

Description of drawings

Fig. 1 is the method flowchart in the embodiment of the present invention;

Fig. 2 is a schematic diagram of a main report and an associated report in an embodiment of the present invention;

Fig. 3 is a schematic structural diagram of a report generation device in an embodiment of the present invention.

Detailed ways

In order to simplify the operation of data query of multiple reports and avoid data query errors, in the embodiment of the present invention, an associated report is generated according to the corresponding relationship between the main report and the settings, as shown in Figure 1 specifically, including the following steps:

Step 11: Set the main report query conditions.

Step 12: Obtain the main report data from the database according to the query conditions of the main report.

In the above two steps, the data that meets the set query conditions are taken out from the database. The query conditions can be a description of the data category, that is, the query conditions are met if the data category belongs to the description. The data category is pre-set according to the content of the report be set. As shown in Figure 2, Table A 21 is the main report. For example, the description of the data category is: "Statistical period: January 2008, area: Dongcheng District, index name: number of users; index value", which meets the requirements of the data category The data is: "1,275 households", so the data is obtained from the database.

Step 13: Generate a main report according to the obtained main report data.

Multiple query conditions can be set in step 11, and multiple data can be obtained correspondingly in step 12, so the main report generated in step 13 also contains multiple items, and the report can be output according to the specified table structure, for example, " "Statistical Period", "Area", "Number of Users" and "Indicator Value" are set as the header, and the corresponding description and the obtained data table are used as the content. The main report output according to this structure is shown in Figure 2. Table A 21 . The interface of the main report can be realized by using publicly available codes or controls. For example, java EXCEL API can be used to provide a table format design interface similar to EXCEL, and the designed table format can be saved in the report definition library in the form of XML files, etc. Realize WYSIWYG report format definition and storage function.

After the above three steps, the main report is obtained, and then the main report is set in the following steps, so that the associated report can be obtained according to the main report. In the application, you can also select an existing report, use it as the main report, and then perform the settings in the following steps.

Step 14: Set query conditions for associated reports. Similar to the query condition of the main report, the query condition of the associated report is used to determine the data in the associated report from the database. The data of the main report can also come from the database, that is, the database contains the data source of the main report. The query condition of the associated report may be the category of the associated report data, and the category is preset. For example, Table B 24 is an associated report, and the data category can be described as: "statistical period: January 2008, region: Dongcheng District, financial subject: all subjects, new customers: all new customers", then the data that meets this category is : "201, 312...".

Step 15: Set the corresponding relationship between the areas in the main report and the query conditions of the associated report. In this step, the range in the main report can be one or more cells of the main report. For example, the cell 22 can be set to correspond to the query conditions of the related report B table 24, and multiple cells 23 can also be set to correspond to the query conditions of the related report B table 24. Take setting the corresponding relationship between Cell 22 and the query conditions of Table 24 of the related report B as an example, the corresponding relationship can be described as: "Cell 22--Statistical Period: January 2008; Area: Dongcheng District; Financial Subject : all subjects; new customers; old customers".

Step 16: Determine the query conditions of the associated report. Specifically, according to the area selected in the main report, the query conditions of the associated report are determined according to the corresponding relationship set in step 15. In this step, an area is selected in the main report, which can be selected through the operation of the terminal device, for example, clicking the area set in the main report with a mouse. To this end, the optional area should be preset in the main report, and the corresponding relationship is further set in step 15 for this area, for example, cell 22 is set as optional, and the cell is set in step 15 the corresponding relationship. Then in step 16, when the cell is clicked, it is selected. At this time, according to the corresponding relationship between cell 22 and associated report B table 24 "cell 22--statistical period: January 2008; area: Dongcheng District; financial Subject: all subjects; new customers; old customers" to determine the query conditions, specifically: "statistical period: January 2008; area: Dongcheng District; financial subjects: all subjects; new customers; old customers", that is, the query statistical period is required It is the number of new customers and old customers in January 2008, the area is Dongcheng District, and the financial subjects are all subjects.

Step 17: Obtain associated report data from the database according to the determined associated report query conditions. Taking the query condition "statistical period: January 2008; region: Dongcheng District; financial subjects: all subjects; new customers; old customers" as an example, the statistical period obtained from the database is January 2008, the region is Dongcheng District, The financial subject is the number of new customers and old customers of all subjects, and its values are shown in the cells in box 25 in Figure 2 respectively. The associated report and the main report can be generated based on the same database, so the database in this step can be the database containing the data source of the main report, and the associated report data is obtained from the database in this step.

Step 18: Generate an associated report according to the data obtained in step 17. In this step, before generating the associated report, you can first set the format of the associated report, including various header information and the color of the table, and then fill the data into the corresponding cells. In this step, the data can be further counted and added to the report according to the preset statistical rules, such as the values in the cells in the right column 26 and the values in the cells in the bottom row 27 in the table B 24 .

After step 18 is completed, the association statement B table 24 is obtained. In the application, table B 24 can be saved in the database and a unique report number can be assigned to it, and then the corresponding relationship between the cell 22 in table A 21 and the number of table B 24 can be saved, when the table A 21 is selected When the cell 22 of , determine the serial number of the B table 24 according to the corresponding relationship, and then search the report with the serial number in the database to obtain the B table 24.

In addition, for the main report A table 21, its other cells can also have the corresponding relationship with the associated report like the cell 22. According to the method similar to the method of obtaining the associated report B table 24, the single table can be obtained according to the cell 28 Joint Form C Form 29.

According to the method in the embodiment of the present invention, the corresponding device for generating a report is shown in FIG. 3 . The report generation device 30 in FIG. 3 is used to generate a report, which includes a first storage module 31 , a determination module 32 and a generation module 33 . The first storage module 31 is used to save the corresponding relationship between the areas in the set main report and the preset query conditions, and the query conditions are used to determine the data in the associated report from the database; Each area in the report saves the corresponding relationship between the set area and the preset associated report query conditions. The determining module 32 is configured to receive a query command specifying a main report area issued by a user, and obtain a query condition corresponding to the main report area specified by the query command according to the corresponding relationship. The generating module 33 is used to determine the data in the associated report from the database according to the determined query condition of the associated report, and then generate the associated report according to the data.

The first storage module 31 is further used to store the category of the associated report data, so the determining module 32 is further used to determine the data belonging to the category from the database according to the category of the associated report data.

On the basis of the report generation device 30, a second storage module can also be added to save the set main report query conditions. In this way, the generation module 33 is further used to fill in the data in the associated report form according to the set associated report format. The location of the get associated report.

According to the technical scheme of the present invention, a corresponding relationship is established between the area of the main report and the query condition of the associated report, and the data acquisition of the associated report and the generation of the associated report are realized by selecting the area in the main report, so that the query of the associated report It can be realized by selecting the area in the main report, and the data query of the associated report can be performed only by presenting the main report, so there is no need to set the query condition every time the associated report is queried, and the operation is relatively simple; and because the query of the associated report The conditions are pre-set, and the query conditions can be pre-tested and confirmed to be correct, so it can ensure that the correct query conditions are given when performing data query of the associated report, thereby ensuring the correctness of the data query.

Obviously, those skilled in the art can make various changes and modifications to the present invention without departing from the spirit and scope of the present invention. Thus, if these modifications and variations of the present invention fall within the scope of the claims of the present invention and their equivalent technologies, the present invention also intends to include these modifications and variations.

Claims (10)

1. a method that generates form is characterized in that, comprising:

For the main form of choosing, zone in the main form and the corresponding relation between the default querying condition are set, described querying condition is used for determining data in the related form from database;

The querying command in main form zone that received appointment that the user sends obtains the querying condition corresponding to main form zone of this querying command appointment according to described corresponding relation;

Determine that according to the querying condition that obtains the data in the related form generate related form according to these data then from database.

2. method according to claim 1 is characterized in that, the zone in the described main form comprises the one or more cells in the main form.

3. method according to claim 1 and 2 is characterized in that, described main form comprises a plurality of zones; Describedly zone in the main form is set and the corresponding relation between the default querying condition comprises for the regional in the main form, the corresponding relation between this zone and the querying condition of presetting is set.

4. method according to claim 1 and 2 is characterized in that described querying condition comprises the classification of related report data;

The querying condition that described basis obtains determines that from database the data in the related form comprise: according to the classification of related report data, determine to belong to such other data from database.

5. method according to claim 1 and 2 is characterized in that described database comprises the data source of described main form;

The querying condition that described basis obtains determines that from database the data in the related form comprise:

According to the querying condition that obtains, from the database of the data source that comprises main form, obtain the data in the related form.

6. method according to claim 1 and 2 is characterized in that, further comprises before the related form of described generation: the form that related form is set;

The related form of described generation comprises according to the related statement form that arranges, the data in the related form is inserted corresponding position obtain related form.

7. a device that generates form is characterized in that, comprising:

Corresponding relation between first memory module, the zone of the main form that be used for to preserve arranges and default querying condition, described querying condition are used for the data in the definite related form of database;

Determination module be used for to receive the querying command in the main form of the appointment zone that the user sends, and draws the querying condition corresponding to main form zone of this querying command appointment according to described corresponding relation;

Generation module is used for determining that from database the data in the related form generate related form according to these data then according to the related report query conditions of determining.

8. device according to claim 7 is characterized in that, described first memory module is further used for the corresponding relation between this zone that arranges corresponding to each the zone preservation in the main form and the querying condition of the presetting.

9. according to claim 7 or 8 described devices, it is characterized in that described first memory module is further used for preserving the classification of related report data;

Then described determination module is further used for the classification according to related report data, determines to belong to such other data from database.

10. according to claim 7 or 8 described devices, it is characterized in that, also comprise second memory module, be used for preserving the form of the related form that arranges;

Described generation module is further used for the data in the related form being inserted corresponding position obtaining related form according to the related statement form that arranges.

Images