1. Technical Field
Embodiments of the present disclosure relate to report management systems and methods, and more particularly to a system and method for generating a product report.
2. Description of Related Art
Various product information systems are employed in manufacturing plants to maintain product quality. Product information may be held or stored in different information systems located in various departments, such as production departments, sales departments, and warehouses of a factory.
Because product information is kept in different locations, it is necessary for users to gather product information from various departments to generate a product report. However, there may be a need to adjust relationships between columns of the product report or to adjust attributes of the columns, but is difficult to do so as some columns of the product report are in fixed form.
Therefore, an effective system and method for generating a product report is desired to overcome the above-described shortcomings.
All of the processes described below may be embodied in, and fully automated via, functional codes modules executed by one or more general purpose processors. The codes modules may be stored in any type of computer-readable medium or other computer storage device. Some or all of the methods may alternatively be embodied in specialized computer hardware or communication apparatus.
The setting module 10 is configured for setting a plurality of columns for different product reports and attributes of each of the columns. The attributes of the columns may include a column name, a column type, and a data source. The column type includes a text type, a date type, and so on. As shown in
The selecting module 12 is configured for selecting one or more columns for a product report to be generated from the set columns for generating a product report according to user's requirements. In one embodiment, if the plant column and the part number column are requested to generate the product report, the selecting module 12 then selects the plant column and the part number column from the set columns.
The allocating module 14 is configured for allocating a serial number for each of the selected columns according to relationships between the selected columns defined by a user. For example, if the user defines that the part number column is subordinate to the plant column, the allocating module 14 allocates a serial number “1” to the plant column, and allocates a serial number “2” to the part number column.
The executing module 16 is configured for generating a control object for each of the selected columns in sequence according to sequence of the allocated serial numbers. The control object is defined according to the column type of each of the selected columns, and may be a text control box, or a date control box. For example, assuming that the plant column is allocated the serial number “1,” and the part number column is allocated the serial number “2,” then the control object for the plant column is generated before generating another control object for the part number column. As explained above in
The generating module 18 is configured for searching product data of the selected columns in the data storage system 2 according to the data sources and the relationships between the selected columns, and for generating the product report by integrating all the control objects of the selected columns according to the searched product data. For example, a plant “A” manufactures a particular product having a part number “B,” the generating module 18 searches product data of the plant “A” in the data source of the plant column and searches product data of the part number “B” in the data source of the part number column. Because the part number column is subordinate to the plant column, the generating module 18 searches the product data of the part number “B” which is subordinate to the plant “A.”
The displaying module 20 is configured for displaying the generated product report on the monitor 3.
In block S30, the setting module 10 sets a plurality of columns for different products report and attributes of each of the columns. The attributes of each of the columns may include a column name, a column type, and a data source.
In block S32, in order to generate a report, the selecting module 12 selects one or more columns for a product report to be generated from the set columns.
In block S34, when a user defines relationships between the selected columns, the allocating module 14 allocates a serial number for each of the selected columns according to the relationships.
In block S36, the executing module 16 sequentially generates a control object for each of the selected columns according to the attributes of each of the selected columns in the same sequence as the serial numbers. In one embodiment, the plant column is allocated a serial number “1”, and the part number column is allocated a serial number “2”, so the control object for the plant column is generated before generating another control object for the part number column.
In block S38, the generating module 18 searches product data of the selected columns in the data storage system 2 according to the data sources of the selected columns and the relationships between the selected columns.
In block S40, the generating module 18 generates the product report by integrating all the control objects of the selected columns according to the searched data.
In block S42, the displaying module 20 displays the generated product report on the monitor 3.
Although certain inventive embodiments of the present disclosure have been specifically described, the present disclosure is not to be construed as being limited thereto. Various changes or modifications may be made to the present disclosure without departing from the scope and spirit of the present disclosure.
Number | Date | Country | Kind |
---|---|---|---|
200710203326.4 | Dec 2007 | CN | national |