CN110728123A - Report generation method, system and related equipment - Google Patents
Report generation method, system and related equipment Download PDFInfo
- Publication number
- CN110728123A CN110728123A CN201910973627.8A CN201910973627A CN110728123A CN 110728123 A CN110728123 A CN 110728123A CN 201910973627 A CN201910973627 A CN 201910973627A CN 110728123 A CN110728123 A CN 110728123A
- Authority
- CN
- China
- Prior art keywords
- report
- objects
- mapping
- report template
- type
- 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
- 238000000034 method Methods 0.000 title claims abstract description 40
- 238000013507 mapping Methods 0.000 claims abstract description 95
- 238000012163 sequencing technique Methods 0.000 claims abstract description 30
- 238000004590 computer program Methods 0.000 claims description 13
- 238000010586 diagram Methods 0.000 description 7
- 230000006870 function Effects 0.000 description 6
- 230000007774 longterm Effects 0.000 description 6
- 230000008569 process Effects 0.000 description 6
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 238000004891 communication Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000012545 processing Methods 0.000 description 2
- 230000001413 cellular effect Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000013506 data mapping Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
- 238000000926 separation method Methods 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Images
Classifications
-
- Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
- Y02—TECHNOLOGIES OR APPLICATIONS FOR MITIGATION OR ADAPTATION AGAINST CLIMATE CHANGE
- Y02P—CLIMATE CHANGE MITIGATION TECHNOLOGIES IN THE PRODUCTION OR PROCESSING OF GOODS
- Y02P90/00—Enabling technologies with a potential contribution to greenhouse gas [GHG] emissions mitigation
- Y02P90/30—Computing systems specially adapted for manufacturing
Abstract
The embodiment of the invention provides a report generation method, a report generation system and related equipment, which are used for realizing the automation of reports and improving the office efficiency. The method provided by the embodiment of the invention comprises the following steps: acquiring first-type item codes in all selected cell objects in a first report template, and sequencing all the first-type item codes according to the sequence of the selected cell objects corresponding to the first-type item codes; obtaining storage formula objects in selected cell objects in a second report template, and sequencing the storage formula objects according to the selected sequence of the corresponding cell objects, wherein the editing controls of the first report template and the second report template are different; taking the first-class item codes and storage formula objects with the same sequencing serial number as a group of associated objects, and completing the mapping operation of each group of associated objects; and taking the report template after the mapping operation of each group of associated objects is completed as a mapping report.
Description
Technical Field
The present invention relates to the field of data processing technologies, and in particular, to a method, a system, and a related device for generating a report.
Background
The report on the computer is mainly characterized by dynamic data and diversified formats, and realizes the complete separation of report data and report formats, so that a user can only modify data or only modify formats. The common report categories include EXCEL report, golden butterfly EAS report, and other reports, and the corresponding edit controls are also different.
In the existing scheme, when contents need to be copied in different types of reports, due to the difference of controls, a new report generation mode is often manually input item by item or copied and pasted, if a large number of report items exist, a large amount of manpower and time are needed to input project data, and when a large number of data are manually input, an input error is easy to occur.
With the pursuit of enterprises on office efficiency, the report automatic generation technology becomes more and more important, and a form data mapping method for automatically generating reports is necessary to improve office efficiency and reduce errors and errors caused by human factors.
Disclosure of Invention
The embodiment of the invention provides a report generation method, a report generation system and related equipment, which are used for realizing the automation of reports and improving the office efficiency.
A first aspect of the embodiments of the present invention provides a report generation method, including:
acquiring first-type item codes in all selected cell objects in a first report template, and sequencing all the first-type item codes according to the sequence of the selected cell objects corresponding to the first-type item codes;
obtaining storage formula objects in selected cell objects in a second report template, and sequencing the storage formula objects according to the selected sequence of the corresponding cell objects, wherein the editing controls of the first report template and the second report template are different;
using the first-class item codes and storage formula objects with the same sequencing sequence number as a group of associated objects, and completing the mapping operation of each group of associated objects, wherein the mapping operation comprises the following steps: mapping fields in the first type item codes and storage formula objects in the same group of associated objects to different cells in the same row in the report template;
and taking the report template after the mapping operation of each group of associated objects is completed as a mapping report.
Optionally, as a possible implementation manner, the report generation method in the embodiment of the present invention further includes:
changing the background color of each selected cell in the first report template to be different from each unselected cell;
and setting the background color of the tables in each row in the mapping report to ensure that the color of the table in each row is consistent with the color of the cell in the first report template corresponding to the first type of item code in the row.
Optionally, as a possible implementation manner, the report generation method in the embodiment of the present invention further includes:
acquiring the project name corresponding to each first type project code from the first report template;
and filling the item name corresponding to each first-type item code in the line in which each first-type item code is located in the mapping report.
Optionally, as a possible implementation manner, the report generation method in the embodiment of the present invention further includes:
and inquiring the statistical value of the current period corresponding to each first-type project code, and filling the statistical value of the current period corresponding to each first-type project code in the line of each first-type project code in the mapping report.
Optionally, as a possible implementation manner, the storage formula object in the embodiment of the present invention includes a second type item encoding field, a report item name field, and a fetch type field.
A second aspect of the present invention provides a report generation system, including:
the first obtaining unit is used for obtaining first-type item codes in all selected cell objects in a first report template, and sequencing all the first-type item codes according to the selected sequence of the cell objects corresponding to the first-type item codes, wherein editing controls of the first report template and the second report template are different;
the second obtaining unit is used for obtaining the storage formula objects in the selected cell objects in the second report template and sequencing the storage formula objects according to the sequence of the selected cell objects corresponding to the storage formula objects;
a mapping unit, configured to use the first-class item codes and storage formula objects with the same sorting order number as a pair of associated objects, and complete a mapping operation of each associated object, where the mapping operation includes: mapping fields in the first type item codes and the storage formula objects in the same associated object to different cells in the same row in the report template; and taking the report template after the mapping operation of each group of associated objects is completed as a mapping report.
Optionally, as a possible implementation manner, the report generating system in the embodiment of the present invention further includes:
the first setting unit is used for changing the background color of each selected cell in the first report template so as to distinguish each unselected cell;
and the second setting unit is used for setting the background color of the tables in each row in the mapping report to ensure that the color of the table in each row is consistent with the color of the cell in the first report template corresponding to the first type of item code in the row.
Optionally, as a possible implementation manner, the report generating system in the embodiment of the present invention further includes:
the third obtaining unit is used for obtaining the project name corresponding to each first type project code from the first report template;
and the filling unit is used for filling the item name corresponding to each first-type item code in the line where the first-type item code is located in the mapping report.
A third aspect of an embodiment of the present application provides a computer device, where the computer device includes a processor, and the processor is configured to implement the steps of the report generation method according to any one of the first aspect and the first aspect when executing a computer program stored in a memory.
A fourth aspect of embodiments of the present application provides a computer-readable storage medium having a computer program stored thereon, wherein: the computer program, when executed by a processor, implements the steps of the report generation method according to any one of the first aspect and the first aspect.
According to the technical scheme, the embodiment of the invention has the following advantages:
in the embodiment of the invention, after the first-class item codes and the sequencing thereof in the selected cell objects in the first report template and the storage formula objects and the sequencing thereof in the selected cell objects in the second report template are obtained, the first-class item codes and the storage formula objects with the same sequencing serial number can be automatically used as a group of associated objects, and the mapping operation of each group of associated objects is completed.
Drawings
FIG. 1 is a schematic diagram of an embodiment of a report generation method according to an embodiment of the present invention;
FIG. 2 is a diagram illustrating a mapping template in an embodiment of a report generation method according to the present invention;
FIG. 3 is a schematic diagram of an EAS template in an embodiment of a report generation method according to the present invention;
FIG. 4 is a diagram illustrating a mapping report in an embodiment of a report generation method according to the present invention;
FIG. 5 is a schematic diagram of an embodiment of a report generation system according to the embodiment of the present invention;
FIG. 6 is a diagram of a computer device according to an embodiment of the present invention.
Detailed Description
The embodiment of the invention provides a report generation method, a report generation system and related equipment, which are used for realizing the automation of reports and improving the office efficiency.
In order to make the technical solutions of the present invention better understood, the technical solutions in the embodiments of the present invention will be clearly and completely described below with reference to the drawings in the embodiments of the present invention, and it is obvious that the described embodiments are only a part of the embodiments of the present invention, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present invention.
The terms "first," "second," "third," "fourth," and the like in the description and in the claims, as well as in the drawings, are used for distinguishing between similar elements and not necessarily for describing a particular sequential or chronological order. It will be appreciated that the data so used may be interchanged under appropriate circumstances such that the embodiments described herein may be practiced otherwise than as specifically illustrated or described herein. Furthermore, the terms "comprises," "comprising," and "having," and any variations thereof, are intended to cover a non-exclusive inclusion, such that a process, method, system, article, or apparatus that comprises a list of steps or elements is not necessarily limited to those steps or elements expressly listed, but may include other steps or elements not expressly listed or inherent to such process, method, article, or apparatus.
For convenience of understanding, a specific process in the embodiment of the present invention is described below, and referring to fig. 1, an embodiment of a report generation method in the embodiment of the present invention may include:
101. acquiring first-type item codes in all selected cell objects in a first report template, and sequencing all the first-type item codes according to the sequence of the selected cell objects corresponding to the first-type item codes;
in the existing scheme, under the condition of more report items, a large amount of manpower and time are needed to repeatedly input item data when a new report is generated each time. In order to avoid repeated entry for multiple times, one or more first report templates may be preset as templates, and a common first-type item code (a character string used for indicating a user index) and/or an index name may be entered in the first report template. When a new report is created, the report generation system can select one or more first-type item codes used from the first report template according to the operation of a user. For example, according to the sequential clicking operation of the user, the first-type item codes in the selected cell objects in the first report template are identified and acquired, and the first-type item codes are sequenced according to the sequence of the selected cell objects corresponding to the first-type item codes.
102. Obtaining storage formula objects in the selected cell objects in the second report template, and sequencing the storage formula objects according to the sequence of the selected cell objects corresponding to the storage formula objects;
in practical application, the enterprise report data is often stored in report software (e.g., golden butterfly EAS report) provided by a third-party software provider, that is, in a heterogeneous system, data is often extracted from the third-party report software when generating a new report, and since the item name and the item code in the third-party report software are often different from those in the first report, the first-type item code in the first report template and the item code in the third-party report software need to be associated and mapped. In the embodiment of the invention, the common storage formula objects in the third-party report software can be input into the second report template in advance for the user to quickly select. The first report template is different from the editing control of the second report template, and the storage formula object stores the filter conditions and parameters which can uniquely position a certain cell in the third-party report.
Optionally, as a possible implementation, the storage formula object may store therein: second type item code field, report item name field, and access type field. The second type item code field is different from the item code in the third-party report software of the first type item code.
After the cells in the first report template are selected in sequence, the user can select the cells in the second report template according to the same sequence according to the mapping relation report generation system of each item code in the first type of item code and each storage formula object in the second report template. The report generation system can identify and acquire the storage formula objects in the selected cell objects in the second report template from the second report template according to the sequential clicking operation of the user.
103. Taking the first-class item codes and storage formula objects with the same sequencing serial number as a group of associated objects, and completing the mapping operation of each group of associated objects;
because the user selects the cells in the second report template in sequence according to the mapping relation between the item codes in the first type of item codes and the formula objects stored in the second report template in the same sequence, the first type of item codes and the formula objects stored in the second report template are in one-to-one correspondence.
The report generation system can take the first-class item codes and storage formula objects with the same sequencing serial number as a group of associated objects and complete the mapping operation of each group of associated objects, wherein the mapping operation comprises the following steps: and mapping fields in the first type item codes and the storage formula objects in the same group of associated objects to different cells in the same row in the report template.
104. And taking the report template after the mapping operation of each group of associated objects is completed as a mapping report.
And taking the report template after the mapping operation of each group of associated objects is completed as a mapping report.
In the embodiment of the invention, after the first-class item codes and the sequencing thereof in the selected cell objects in the first report template and the storage formula objects and the sequencing thereof in the selected cell objects in the second report template are obtained, the first-class item codes and the storage formula objects with the same sequencing serial number can be automatically used as a group of associated objects, and the mapping operation of each group of associated objects is completed, so that the automatic generation of the report is realized, and the office efficiency is improved. Secondly, the common project codes are input into the first report template, diversified combination can be carried out according to the requirements of users, and the practicability is improved.
Optionally, as a possible implementation manner, in the embodiment of the present invention, in order to prompt a user to avoid repeated mapping, the background color of each selected cell in the first report template may be identified differently, specifically: changing the background color of each selected cell in the first report template to be different from each unselected cell; setting the background color of the tables in each row in the mapping report, and enabling the color of the tables in each row to be consistent with the color of the cells in the first report template corresponding to the first type of item codes in the row.
Optionally, as a possible implementation manner, in the embodiment of the present invention, in order to facilitate a user to check the correctness of the mapping, the project name corresponding to the first type of project code may also be filled in the mapping report, which specifically includes:
acquiring the project name corresponding to each first type project code from the first report template;
and filling the item name corresponding to each first-type item code in the line in which each first-type item code is located in the mapping report.
Optionally, as a possible implementation manner, in the embodiment of the present invention, in practical application, the statistical value corresponding to each item code changes along with the statistical period, so as to facilitate a user to look up the statistical value of the current period corresponding to each item code, and the statistical value of the current period corresponding to the first type of item code may also be filled in the mapping report, which specifically includes: and inquiring the statistical value of the current period corresponding to each first-type project code, and filling the statistical value of the current period corresponding to each first-type project code in the line where each first-type project code is located in the mapping report. The statistical value of the current period corresponding to the first type of project code is stored in the report software provided by the third-party software provider, and the report generation system can extract the statistical value of the current period from the report software provided by the third-party software provider according to the storage formula object corresponding to the first type of project code.
It should be understood that, in various embodiments of the present invention, the sequence numbers of the above steps do not mean the execution sequence, and the execution sequence of each step should be determined by its function and inherent logic, and should not constitute any limitation on the implementation process of the embodiments of the present invention.
For convenience of understanding, referring to fig. 2 to 4, the report generation method in the embodiment of the present invention will be described below with reference to a specific application example.
It should be understood that the following embodiments are only described by taking the long-term reporting template (as shown in fig. 2) under the long-term reporting software and the EAS template (as shown in fig. 3) under the golden butterfly EAS report as examples, and other reports, such as reports in EXCEL or other financial systems, may also be used in practical applications, and are not limited herein.
In the embodiment, a KDSpread (golden butterfly EAS report basic control) tool is used to open a long-term report template (a first report template) and an EAS template (a second report template), and then a mouse is used to select report items in the long-term report template and report items of the EAS template for one-to-one comparison, so as to automatically generate mapping records, thereby achieving the purpose of automatically generating mapping reports.
Triggering the auxiliary selection box through a key, selecting a long-term report template and an EAS template, selecting (single selection or mouse dragging and multi-selection) report items in the long-term report template, then pressing a keyboard alt key and selecting the report items in the EAS template by using a left mouse key, and then loosening the keyboard alt key. The system will generate a mapping record and set the background color of the selected cell to be a color different from the unselected cells as a mapped flag, as shown in fig. 2, in six steps as follows:
a. according to the cells selected by the report template (first report template) of the user for a long time, acquiring the index values (first-class item codes) and the index names (item names corresponding to the first-class item codes) in the cells according to the selection sequence, storing the index values and the index names in the cells in the C object, and storing the cell objects in the B object, wherein the sequence of the index values in the graph 2 is as follows: JS11Z01D00081, JS11Z01D00080, JS11Z01C00036, JS11Z01C 00035;
b. according to the unit cells selected by the user in the EAS template, acquiring an ITEM (DITEM) storage formula object stored in a unit cell userObject object according to a selection sequence, wherein the storage formula object comprises an EAS item coding field, an EAS item name field and a figure taking type field (namely a data type of data which can be filled in), sequentially storing the selection sequence of the unit cells corresponding to the object in an object A, and sequentially storing the unit cell objects in an object B according to the selection sequence, for example, as shown in FIG. 3, wherein the sequence of the selected unit cells is △ commission fee and commission fee income, △ premium income, △ interest income and business income;
c. acquiring a storage formula object according to the sequence of the object A and acquiring an EAS (electronic article surveillance) report item code, a report item name and a figure fetching type from the storage formula object, acquiring information such as an index value, an index name and the like according to the sequence of the object C, putting mapping information such as the report item code, the report item name, the figure fetching type and the like into corresponding cell objects in a mapping template, and displaying corresponding mapping information when a user selects a cell;
d. setting background color information in cell object information stored in the B object as a preset color to be distinguished from unselected cells;
e. using the index value and the storage formula object with the same sequencing sequence number as a group of associated objects, and completing the mapping operation of each group of associated objects, wherein the mapping operation comprises the following steps: mapping the index values in the same group of associated objects and the fields in the storage formula objects to different cell mapping templates in the same row in the report template to generate a mapping report, as shown in fig. 4;
f. and acquiring the statistical value of the current period corresponding to the report code EAS report item code in the EAS system according to the EAS report item code and the report code in the mapping data.
In the embodiment, the mapping template and the report items of the EAS template are visually displayed through the kdsread tool, and the mapping data of the report items are generated through simple mouse and keyboard operations, so that the labor and time cost are saved, a user can randomly combine index values in the report template for a long time according to the requirement, and the practicability is improved.
Referring to fig. 5, an embodiment of the present application further provides a report generating system, which is characterized by including:
a first obtaining unit 501, configured to obtain first-type item codes in each selected cell object in the first report template, and sort the first-type item codes according to the sequence in which the cell objects corresponding to the first-type item codes are selected;
a second obtaining unit 502, configured to obtain storage formula objects in the selected cell objects in the second report template, and sort the storage formula objects according to the order in which the corresponding cell objects are selected, where the edit controls of the first report template are different from the edit controls of the second report template;
the mapping unit 503 is configured to use the first-class item codes and storage formula objects with the same sorting order number as a pair of associated objects, and complete mapping operations of the associated objects, where the mapping operations include: mapping fields in the first type item codes and the storage formula objects in the same associated object to different cells in the same row in the report template; and taking the report template after the mapping operation of each group of associated objects is completed as a mapping report.
Optionally, as a possible implementation manner, the report generating system in the embodiment of the present invention may further include:
a first setting unit 504, configured to change a background color of each selected cell in the first report template to distinguish each cell from each cell that is not selected;
the second setting unit 505 is configured to set a background color of each row of tables in the mapping report, so that the color of each row of tables is consistent with the color of the cells in the first report template corresponding to the first type item code of the row.
Optionally, as a possible implementation manner, the report generating system in the embodiment of the present invention may further include:
a third obtaining unit 506, configured to obtain, from the first report template, a project name corresponding to each first-type project code;
and the filling unit 507 is configured to fill the item name corresponding to each first-type item code in the line where each first-type item code is located in the mapping report.
In the embodiment of the invention, after acquiring the first-class item codes and the sequence thereof in the selected cell objects in the first report template and the storage formula objects and the sequence thereof in the selected cell objects in the second report template, the report generation system can automatically take the first-class item codes and the storage formula objects with the same sequence number as a group of associated objects and complete the mapping operation of the groups of associated objects, thereby realizing the automatic generation of reports and improving the office efficiency.
It is clear to those skilled in the art that, for convenience and brevity of description, the specific working processes of the above-described systems, apparatuses and units may refer to the corresponding processes in the foregoing method embodiments, and are not described herein again.
Fig. 6 is a schematic diagram illustrating only a portion related to an embodiment of the present application for convenience of description, and please refer to a method portion of the embodiment of the present application for details not disclosed. Referring to fig. 6, the computer device 6 includes: memory 610, processor 620, wired or wireless network module 630, and computer programs stored in the memory and executable on the processor. The processor, when executing the computer program, implements the steps in the above-described embodiments of the report generating method, such as steps 101 to 104 shown in fig. 1. Alternatively, the processor, when executing the computer program, implements the functions of each module or unit in the above-described device embodiments.
In some of the embodiments of the application, the processor, when executing the computer program stored in the memory, implements the steps of:
acquiring first-type item codes in all selected cell objects in a first report template, and sequencing all the first-type item codes according to the sequence of the selected cell objects corresponding to the first-type item codes;
obtaining storage formula objects in the selected cell objects in the second report template, and sequencing the storage formula objects according to the selected sequence of the corresponding cell objects, wherein the editing controls of the first report template and the second report template are different;
using the first-class item codes and storage formula objects with the same sequencing sequence number as a group of associated objects, and completing the mapping operation of each group of associated objects, wherein the mapping operation comprises the following steps: mapping fields in the first type item codes and storage formula objects in the same group of associated objects to different cells in the same row in the report template;
and taking the report template after the mapping operation of each group of associated objects is completed as a mapping report.
Optionally, in some embodiments of the present application, the processor may be further configured to implement the following steps:
changing the background color of each selected cell in the first report template to be different from each unselected cell;
setting the background color of the tables in each row in the mapping report, and enabling the color of the tables in each row to be consistent with the color of the cells in the first report template corresponding to the first type of item codes in the row.
Optionally, in some embodiments of the present application, the processor may be further configured to implement the following steps:
acquiring the project name corresponding to each first type project code from the first report template;
and filling the item name corresponding to each first-type item code in the line in which each first-type item code is located in the mapping report.
Optionally, in some embodiments of the present application, the processor may be further configured to implement the following steps:
and inquiring the statistical value of the current period corresponding to each first-type project code, and filling the statistical value of the current period corresponding to each first-type project code in the line where each first-type project code is located in the mapping report.
Those skilled in the art will appreciate that the arrangement shown in fig. 6 does not constitute a limitation of the computer apparatus, and that the computer apparatus 6 may comprise more or less components than those shown, or some components may be combined, or a different arrangement of components, e.g. the computer apparatus may also comprise input-output devices, buses, etc.
The Processor may be a general purpose Processor, a Digital Signal Processor (DSP), an Application Specific Integrated Circuit (ASIC), an off-the-shelf Programmable Gate Array (FPGA) or other Programmable logic device, discrete Gate or transistor logic, discrete hardware components, or the like. A general purpose processor may be a microprocessor or the processor may be any conventional processor or the like.
The memory may be used to store computer programs and/or modules, and the processor may implement various functions of the computer device by executing or executing the computer programs and/or modules stored in the memory, as well as by invoking data stored in the memory. The memory may mainly include a storage program area and a storage data area, wherein the storage program area may store an operating system, an application program required by at least one function (such as a sound playing function, an image playing function, etc.), and the like; the storage data area may store data (such as audio data, a phonebook, etc.) created according to the use of the cellular phone, and the like. In addition, the memory may include high speed random access memory, and may also include non-volatile memory, such as a hard disk, a memory, a plug-in hard disk, a Smart Media Card (SMC), a Secure Digital (SD) Card, a Flash memory Card (Flash Card), at least one magnetic disk storage device, a Flash memory device, or other volatile solid state storage device.
The present application further provides a computer-readable storage medium having a computer program stored thereon, which when executed by a processor, can implement the steps of:
acquiring first-type item codes in all selected cell objects in a first report template, and sequencing all the first-type item codes according to the sequence of the selected cell objects corresponding to the first-type item codes;
obtaining storage formula objects in the selected cell objects in the second report template, and sequencing the storage formula objects according to the selected sequence of the corresponding cell objects, wherein the editing controls of the first report template and the second report template are different;
using the first-class item codes and storage formula objects with the same sequencing sequence number as a group of associated objects, and completing the mapping operation of each group of associated objects, wherein the mapping operation comprises the following steps: mapping fields in the first type item codes and storage formula objects in the same group of associated objects to different cells in the same row in the report template;
and taking the report template after the mapping operation of each group of associated objects is completed as a mapping report.
Optionally, in some embodiments of the present application, the processor may be further configured to implement the following steps:
changing the background color of each selected cell in the first report template to be different from each unselected cell;
setting the background color of the tables in each row in the mapping report, and enabling the color of the tables in each row to be consistent with the color of the cells in the first report template corresponding to the first type of item codes in the row.
Optionally, in some embodiments of the present application, the processor may be further configured to implement the following steps:
acquiring the project name corresponding to each first type project code from the first report template;
and filling the item name corresponding to each first-type item code in the line in which each first-type item code is located in the mapping report.
Optionally, in some embodiments of the present application, the processor may be further configured to implement the following steps:
and inquiring the statistical value of the current period corresponding to each first-type project code, and filling the statistical value of the current period corresponding to each first-type project code in the line where each first-type project code is located in the mapping report.
In the several embodiments provided in the present application, it should be understood that the disclosed system, apparatus and method may be implemented in other manners. For example, the above-described apparatus embodiments are merely illustrative, and for example, the division of the units is only one logical division, and other divisions may be realized in practice, for example, a plurality of units or components may be combined or integrated into another system, or some features may be omitted, or not executed. In addition, the shown or discussed mutual coupling or direct coupling or communication connection may be an indirect coupling or communication connection through some interfaces, devices or units, and may be in an electrical, mechanical or other form.
The units described as separate parts may or may not be physically separate, and parts displayed as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units can be selected according to actual needs to achieve the purpose of the solution of the embodiment.
In addition, functional units in the embodiments of the present invention may be integrated into one processing unit, or each unit may exist alone physically, or two or more units are integrated into one unit. The integrated unit can be realized in a form of hardware, and can also be realized in a form of a software functional unit.
The integrated unit, if implemented in the form of a software functional unit and sold or used as a stand-alone product, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present invention may be embodied in the form of a software product, which is stored in a storage medium and includes instructions for causing a computer device (which may be a personal computer, a server, or a network device) to execute all or part of the steps of the method according to the embodiments of the present invention. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a Read-only Memory (ROM), a Random Access Memory (RAM), a magnetic disk or an optical disk, and other various media capable of storing program codes.
The above-mentioned embodiments are only used for illustrating the technical solutions of the present invention, and not for limiting the same; although the present invention has been described in detail with reference to the foregoing embodiments, it will be understood by those of ordinary skill in the art that: the technical solutions described in the foregoing embodiments may still be modified, or some technical features may be equivalently replaced; and such modifications or substitutions do not depart from the spirit and scope of the corresponding technical solutions of the embodiments of the present invention.
Claims (10)
1. A report generation method is characterized by comprising the following steps:
acquiring first-type item codes in all selected cell objects in a first report template, and sequencing all the first-type item codes according to the sequence of the selected cell objects corresponding to the first-type item codes;
obtaining storage formula objects in selected cell objects in a second report template, and sequencing the storage formula objects according to the selected sequence of the corresponding cell objects, wherein the editing controls of the first report template and the second report template are different;
using the first-class item codes and storage formula objects with the same sequencing sequence number as a group of associated objects, and completing the mapping operation of each group of associated objects, wherein the mapping operation comprises the following steps: mapping fields in the first type item codes and storage formula objects in the same group of associated objects to different cells in the same row in the report template;
and taking the report template after the mapping operation of each group of associated objects is completed as a mapping report.
2. The method of claim 1, further comprising:
changing the background color of each selected cell in the first report template to be different from each unselected cell;
and setting the background color of the tables in each row in the mapping report to ensure that the color of the table in each row is consistent with the color of the cell in the first report template corresponding to the first type of item code in the row.
3. The method of claim 1, further comprising:
acquiring the project name corresponding to each first type project code from the first report template;
and filling the item name corresponding to each first-type item code in the line in which each first-type item code is located in the mapping report.
4. The method of claim 1, further comprising:
and inquiring the statistical value of the current period corresponding to each first-type project code, and filling the statistical value of the current period corresponding to each first-type project code in the line of each first-type project code in the mapping report.
5. The method of any one of claims 1 to 4, wherein the storage formula object comprises a second type item code field, a report item name field, and a fetch type field.
6. A report generation system, comprising:
the first obtaining unit is used for obtaining first-class item codes in all selected cell objects in the first report template and sequencing all the first-class item codes according to the sequence of the selected cell objects corresponding to the first-class item codes;
the second obtaining unit is used for obtaining storage formula objects in the selected cell objects in the second report template and sequencing the storage formula objects according to the selected sequence of the corresponding cell objects, and the editing controls of the first report template and the second report template are different;
a mapping unit, configured to use the first-class item codes and storage formula objects with the same sorting order number as a pair of associated objects, and complete a mapping operation of each associated object, where the mapping operation includes: mapping fields in the first type item codes and the storage formula objects in the same associated object to different cells in the same row in the report template; and taking the report template after the mapping operation of each group of associated objects is completed as a mapping report.
7. The system of claim 6, further comprising:
the first setting unit is used for changing the background color of each selected cell in the first report template so as to distinguish each unselected cell;
and the second setting unit is used for setting the background color of the tables in each row in the mapping report to ensure that the color of the table in each row is consistent with the color of the cell in the first report template corresponding to the first type of item code in the row.
8. The system of claim 6, further comprising:
the third obtaining unit is used for obtaining the project name corresponding to each first type project code from the first report template;
and the filling unit is used for filling the item name corresponding to each first-type item code in the line where the first-type item code is located in the mapping report.
9. A computer arrangement, characterized in that the computer arrangement comprises a processor for implementing the steps of the method according to any one of claims 1 to 5 when executing a computer program stored in a memory.
10. A computer-readable storage medium having stored thereon a computer program, characterized in that: the computer program when executed by a processor implementing the steps of the method according to any one of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910973627.8A CN110728123B (en) | 2019-10-14 | 2019-10-14 | Report generation method, system and related equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910973627.8A CN110728123B (en) | 2019-10-14 | 2019-10-14 | Report generation method, system and related equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN110728123A true CN110728123A (en) | 2020-01-24 |
| CN110728123B CN110728123B (en) | 2023-12-26 |
Family
ID=69221121
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910973627.8A Active CN110728123B (en) | 2019-10-14 | 2019-10-14 | Report generation method, system and related equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110728123B (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111325014A (en) * | 2020-02-28 | 2020-06-23 | 维沃移动通信有限公司 | Report content generation method and electronic equipment |
| CN111984238A (en) * | 2020-09-22 | 2020-11-24 | 吴政静 | Cross-platform bridging data information processing software |
| CN113296775A (en) * | 2021-06-17 | 2021-08-24 | 数字广东网络建设有限公司 | Page generation method and device, computer equipment and storage medium |
| CN114064716A (en) * | 2021-10-29 | 2022-02-18 | 北京市农林科学院信息技术研究中心 | Metadata-based WEB report automatic generation method and device |
| CN115859926A (en) * | 2023-01-30 | 2023-03-28 | 天津联想协同科技有限公司 | Electronic form data relation processing method and device, electronic equipment and medium |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120198322A1 (en) * | 2011-01-27 | 2012-08-02 | Microsoft Corporation | Automated table transformations from examples |
| CN103778234A (en) * | 2014-01-26 | 2014-05-07 | 北京恒华伟业科技股份有限公司 | Report form generating method and device |
| CN107168940A (en) * | 2017-03-29 | 2017-09-15 | 长春市万易科技有限公司 | A kind of report generating system and method |
| CN107368414A (en) * | 2017-07-19 | 2017-11-21 | 中国银行股份有限公司 | Information processing method, device and electronic equipment |
| CN109359283A (en) * | 2018-09-26 | 2019-02-19 | 中国平安人寿保险股份有限公司 | Method of summary, terminal device and the medium of list data |
| CN109710665A (en) * | 2018-08-17 | 2019-05-03 | 深圳壹账通智能科技有限公司 | Report downloading method, apparatus, equipment and readable storage medium storing program for executing |
-
2019
- 2019-10-14 CN CN201910973627.8A patent/CN110728123B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20120198322A1 (en) * | 2011-01-27 | 2012-08-02 | Microsoft Corporation | Automated table transformations from examples |
| CN103778234A (en) * | 2014-01-26 | 2014-05-07 | 北京恒华伟业科技股份有限公司 | Report form generating method and device |
| CN107168940A (en) * | 2017-03-29 | 2017-09-15 | 长春市万易科技有限公司 | A kind of report generating system and method |
| CN107368414A (en) * | 2017-07-19 | 2017-11-21 | 中国银行股份有限公司 | Information processing method, device and electronic equipment |
| CN109710665A (en) * | 2018-08-17 | 2019-05-03 | 深圳壹账通智能科技有限公司 | Report downloading method, apparatus, equipment and readable storage medium storing program for executing |
| CN109359283A (en) * | 2018-09-26 | 2019-02-19 | 中国平安人寿保险股份有限公司 | Method of summary, terminal device and the medium of list data |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111325014A (en) * | 2020-02-28 | 2020-06-23 | 维沃移动通信有限公司 | Report content generation method and electronic equipment |
| CN111984238A (en) * | 2020-09-22 | 2020-11-24 | 吴政静 | Cross-platform bridging data information processing software |
| CN113296775A (en) * | 2021-06-17 | 2021-08-24 | 数字广东网络建设有限公司 | Page generation method and device, computer equipment and storage medium |
| CN114064716A (en) * | 2021-10-29 | 2022-02-18 | 北京市农林科学院信息技术研究中心 | Metadata-based WEB report automatic generation method and device |
| CN114064716B (en) * | 2021-10-29 | 2023-10-20 | 北京市农林科学院信息技术研究中心 | Metadata-based automatic WEB report generation method and device |
| CN115859926A (en) * | 2023-01-30 | 2023-03-28 | 天津联想协同科技有限公司 | Electronic form data relation processing method and device, electronic equipment and medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN110728123B (en) | 2023-12-26 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110728123A (en) | Report generation method, system and related equipment | |
| CN110399352B (en) | Method, device, equipment and storage medium for processing SVN log file | |
| CN107085602B (en) | Statistical graph generation method and computer storage medium | |
| US20190042643A1 (en) | Method, apparatus, electronic equipment and storage medium for performing screening and statistical operation on data | |
| CN110399420A (en) | A kind of deriving method, electronic equipment and the medium of configurableization Excel format | |
| CN107657051A (en) | A kind of generation method of picture tag, terminal device and storage medium | |
| CN113722289A (en) | Method, device, electronic equipment and medium for constructing data service | |
| CN115422903A (en) | Report output method and device, electronic equipment and computer readable storage medium | |
| CN111800471A (en) | Recommended page display method and device and electronic equipment | |
| CN111639120A (en) | Method, device and equipment for forming graph of architecture view and readable storage medium | |
| CN107766519B (en) | Method for visually configuring data structure | |
| CN107122961A (en) | Excel nested report data processing methods based on SAP system | |
| CN111061733B (en) | Data processing method, device, electronic equipment and computer readable storage medium | |
| CN102707938A (en) | Table-form software specification manufacturing and supporting method and device | |
| CN110516220B (en) | Report data input method, system and related equipment | |
| CN109324963B (en) | Method for automatically testing profit result and terminal equipment | |
| CN114925127A (en) | Two-dimensional graph generation method and device for cascade structure data and storage medium | |
| CN110362540B (en) | Data storage and visitor number acquisition method and device | |
| CN114742631A (en) | Budget cost recovery method, electronic device and storage medium | |
| CN110941608B (en) | Method, device and equipment for generating buried point analysis and funnel analysis report | |
| CN114328452A (en) | Data auditing method, device, platform, electronic equipment and storage medium | |
| CN111695077A (en) | Asset information pushing method, terminal equipment and readable storage medium | |
| CN111399832A (en) | Page editing method and device | |
| CN111026705A (en) | Building engineering file management method, system and terminal equipment | |
| CN112700328B (en) | Automatic index analysis method, device, equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |