CN112084762A - Report template generation method and system - Google Patents
Report template generation method and system Download PDFInfo
- Publication number
- CN112084762A CN112084762A CN202011036326.1A CN202011036326A CN112084762A CN 112084762 A CN112084762 A CN 112084762A CN 202011036326 A CN202011036326 A CN 202011036326A CN 112084762 A CN112084762 A CN 112084762A
- Authority
- CN
- China
- Prior art keywords
- field
- data
- generating
- basic information
- report template
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/186—Templates
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q40/00—Finance; Insurance; Tax strategies; Processing of corporate or income taxes
- G06Q40/02—Banking, e.g. interest calculation or account maintenance
Abstract
The invention provides a report template generation method and a report template generation system. The report template generation method comprises the following steps: acquiring an association table and selecting a field table name from the association table; determining table basic information data and a plurality of field data corresponding to the name of the field table; selecting at least one field group from the plurality of field data, and determining field configuration information corresponding to the field group; and generating a report template according to the field configuration information corresponding to the field group and the table basic information data. The invention can realize the rapid generation of the report template and improve the report generation efficiency and the accuracy.
Description
Technical Field
The invention relates to the technical field of data processing, in particular to a report template generation method and a report template generation system.
Background
The bank system relates to a large number of reports, the data in the reports are various, and a large number of reports reflect different problems in the field of unified problems (such as risks, calculation, assets and mechanisms), so that a lot of same field information exists in the reports. The existing technology for generating a large number of reports is often tedious: generally, a certain template is imported, then the format of the report is determined, and then the analysis is performed according to the row and column format of the template, and the data is read or operated. The method needs report designers to design a large number of reports and then communicate with developers, and the developers analyze the report templates, so that a large amount of repeated labor is generated, the workload is huge, quick response cannot be realized, and errors are easy to occur in some report development processes. Therefore, the rapid design and automatic generation of the report template are realized, and the efficiency and the accuracy of report generation are improved.
Disclosure of Invention
The embodiment of the invention mainly aims to provide a report template generation method and a report template generation system, so that a report template can be generated quickly, and the report generation efficiency and the accuracy are improved.
In order to achieve the above object, an embodiment of the present invention provides a report template generating method, including:
acquiring an association table and selecting a field table name from the association table;
determining table basic information data and a plurality of field data corresponding to the name of the field table;
selecting at least one field group from the plurality of field data, and determining field configuration information corresponding to the field group;
and generating a report template according to the field configuration information corresponding to the field group and the table basic information data.
The embodiment of the present invention further provides a report template generating system, including:
an acquisition unit configured to acquire an association table and select a domain table name from the association table;
the data determining unit is used for determining table basic information data and a plurality of field data corresponding to the field table name;
the field configuration information determining unit is used for selecting at least one field group from the plurality of field data and determining field configuration information corresponding to the field group;
and the report template generating unit is used for generating a report template according to the field configuration information corresponding to the field group and the table basic information data.
The embodiment of the invention also provides computer equipment which comprises a memory, a processor and a computer program which is stored on the memory and runs on the processor, wherein the processor realizes the steps of the report template generation method when executing the computer program.
The embodiment of the invention also provides a computer readable storage medium, wherein a computer program is stored on the computer readable storage medium, and the computer program realizes the steps of the report template generation method when being executed by the processor.
The report template generation method and the system of the embodiment of the invention select the name of the field table from the association table, then determine the table basic information data and the plurality of field data corresponding to the name of the field table, then select at least one field group from the plurality of field data, determine the field configuration information corresponding to the field group, and finally generate the report template according to the field configuration information and the table basic information data corresponding to the field group, thereby realizing the rapid generation of the report template and improving the report generation efficiency and the accuracy.
Drawings
In order to more clearly illustrate the embodiments of the present invention or the technical solutions in the prior art, the drawings used in the description of the embodiments will be briefly introduced below, and it is obvious that the drawings in the following description are only some embodiments of the present invention, and it is obvious for those skilled in the art that other drawings can be obtained based on these drawings without creative efforts.
FIG. 1 is a flowchart of a report template generation method according to an embodiment of the present invention;
FIG. 2 is a schematic diagram of an association table;
FIG. 3 is a schematic diagram of a basic information table;
FIG. 4 is a schematic diagram of a field configuration table;
FIG. 5 is a front end page diagram of new data;
FIG. 6 is a schematic diagram of a front end page of add-on table fields;
fig. 7 is a flowchart of S104 in the embodiment of the present invention;
FIG. 8 is a block diagram of a report template generation system according to an embodiment of the present invention;
fig. 9 is a block diagram of a computer device in the embodiment of the present invention.
Detailed Description
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.
As will be appreciated by one skilled in the art, embodiments of the present invention may be embodied as a system, apparatus, device, method, or computer program product. Accordingly, the present disclosure may be embodied in the form of: entirely hardware, entirely software (including firmware, resident software, micro-code, etc.), or a combination of hardware and software.
In view of the fact that the prior art cannot realize quick response and errors are easy to occur in the report development process, the embodiment of the invention provides a report template generation method, which is used for quickly generating a report template and improving the report generation efficiency and the accuracy. The present invention will be described in detail below with reference to the accompanying drawings.
Certain rules and configurations are required to realize the automatic generation of the report. Some of the initialized settings contribute to the quality and speed of report generation. Meanwhile, the initialized configuration can be adapted to the service requirement more quickly. Manual configuration can affect efficiency to some extent and can cause errors. The method and the device perform format configuration on the data of the database based on Java language and oracle database, define each field in the report by using the data pre-inserted in the database, then combine the defined fields, redefine the report template, and thus realize automatic generation and rapid generation of the report template.
There are three core profiles for the present invention. The first is the table information content stored in the oracle database, recorded by a table _ info table (basic information table), and mainly used for recording the basic information of the derived report template. The second is the field information content stored in the oracle database, recorded by a table _ column table (field configuration table), and mainly used for recording the field information and related configuration in the report template. The third is a user _ col _ comments table (association table) that records the correspondence between table names and field names. The invention has two page functions at the front end. One is a management page of the table information and the field information of the report template, which is mainly used for configuring the basic information of the report template and the field information derived from the report template. And the other page is a report template export page used for displaying the configured report template and exporting the file.
FIG. 1 is a flowchart of a report template generating method according to an embodiment of the present invention. Fig. 2 is a schematic diagram of an association table. Fig. 3 is a schematic diagram of a basic information table. Fig. 4 is a schematic diagram of a field configuration table. As shown in fig. 1 to 4, the report template generating method includes:
s101: an association table is obtained and a domain table name is selected from the association table.
In particular embodiments, domain TABLE selection information may be received from a user, the domain TABLE selection information including a domain TABLE NAME (TABLE _ NAME in FIG. 2, RWA43_ OPER _ RISK _ REQ; Table English NAME in FIG. 3). The corresponding domain table name may be selected from the association table according to the domain table selection information.
The configuration of the report information and the report field information is mainly to insert data into a basic information table and a field configuration table. The most important of them is the correspondence between the table name and the field name, i.e. the record in the association table. A TABLE NAME (TABLE _ NAME in fig. 2) corresponds to how many field NAMEs (COLUMN _ NAME), i.e. defines how many fields the TABLE relates to at most. Because one TABLE English NAME TABLE _ NAME in the association TABLE corresponds to a plurality of fields COLUMN _ NAME, a user can combine a plurality of fields and focus on establishing a plurality of report models in a certain problem field (the problem field corresponding to the TABLE English NAME). There are two ways of configuring the table data, one is to insert the data by way of a front-end page send transaction. The method is convenient and quick to manage the fields, but is easy to generate errors. Once a correspondence is deleted or modified, an overall system error may result. Or by initializing the configuration and then not allowing the front-end page to modify the correspondence between the table name and the field name. The method has the advantages of being not easy to make mistakes, and has the disadvantages that the configuration is fixed, and if the configuration is required to be modified, the data needs to be imported from the database again. The invention adopts the second mode, namely, the data in the association table is directly imported through initializing the configured corresponding relation and can not be modified.
S102: and determining table basic information data and a plurality of field data corresponding to the name of the field table.
As shown in fig. 3, the table basic information data includes a table number, a table english name (field table name), a table chinese name, a table type, an Excel start line, an Excel end line, an Excel delete field identifier, Excel multi-column processing, an Excel unique identifier column combination, an Excel corresponding virtual entity class name, whether Excel is NULL mode, an Excel ignored field, the number of Excel reading sheets, the number of Excel writing sheets, an Excel writing sheet assignment attribute, an Excel homogeneous attribute, a name of Excel writing sheets, an Excel export template name, an Excel parameter table type, an xml definition of Excel, an audit corresponding table number, manual data and other machine distinguishing mechanisms. For example, in the present application, based on the information of the chinese construction bank, the other banking institutions are banking institutions other than the chinese construction bank. The table numbers correspond to the names of the characters in the table one by one, and one table English name corresponds to a plurality of table numbers.
As shown in fig. 2, field data corresponding to the domain table NAME RWA43_ OPER _ RISK _ REQ includes a field english NAME (COLUMN _ NAME) and a field chinese NAME (COMMENTS). Taking the Chinese name as an example, the fields include date, statement code, organization number, version number, currency, serial number, beta coefficient, total income/loan balance first year, total income/loan balance second year, total income/loan balance third year, capital requirement first year, capital requirement second year, and capital requirement third year.
S103: at least one field group is selected from the plurality of field data, and field configuration information corresponding to the field group is determined.
In one embodiment, before executing S103, the method further includes: field selection information is received from a user. Wherein the field selection information includes a table number.
S103 includes: and selecting at least one field group from the field data according to the field selection information, and determining field configuration information corresponding to the field group. The table numbers correspond to the field groups one by one, and one table number corresponds to one report model.
One field group comprises at least one field data, and the field configuration information corresponding to the field group can be determined according to the field configuration information corresponding to the at least one field data. As shown in fig. 4, the field configuration information corresponding to each field data includes a field number, a table number, a field english name, a field chinese name, a field attribute name, a page query condition identifier, a page edit type (cell type in Excel), a page padding identifier, a page ranking number, a page query result identifier, an Excel sequence number, an Excel value, an Excel field check, an Excel code list, an Excel display identifier, an Excel resource type, an Excel value type, and an Excel writing identifier.
S104: and generating a report template according to the field configuration information corresponding to the field group and the table basic information data.
Fig. 7 is a flowchart of S104 in the embodiment of the present invention. As shown in fig. 7, S104 includes:
s201: and generating a basic information table according to the table basic information data.
The data in the basic information table mainly records the structure and the basic information of the report template. The addition, deletion and modification operations can be realized through the front-end page. In the present invention, the correspondence between the TABLE NAME and the field NAME is fixed, so that the TABLE _ ID (TABLE number) or TABLE _ NAME (TABLE english NAME) to be input at the time of addition must be TABLE information already existing in the association TABLE. The field configuration table records field information, and the operations of adding, deleting and modifying can also be carried out through a front-end page.
Fig. 5 is a front end page diagram of the new data. As shown in fig. 5, the table english name (field table name) is fixed and uneditable after being input, the table english name corresponds to a plurality of table basic information data, and the user can write the table basic information data into the basic information table by filling the table basic information data on the front end page.
S202: and generating a field configuration table according to the field configuration information corresponding to the field group.
FIG. 6 is a diagram of a front end page of the add-on table field. As shown in fig. 6, clicking the new field information, the page first queries the field data corresponding to the name of the domain table in the association table. Selecting at least one field data, determining field configuration information corresponding to the field data, and writing the field configuration information into a field configuration table.
Wherein, a field configuration table corresponds to a field data, and the field group comprises at least one field data, i.e. the field group corresponds to at least one field configuration table. The table numbers correspond to the field groups one by one, namely one report model corresponds to at least one field configuration table. In order to reflect a certain problem, a plurality of field data are needed, a plurality of fields can be added to the report model, and a plurality of report models can be generated by different field configuration table combinations.
S203: and generating a report template according to the basic information table and the field configuration table.
In one embodiment, S203 includes: determining a field configuration table corresponding to the table number in the basic information table; and generating a report template according to the basic information table and a field configuration table corresponding to the table number in the basic information table.
As shown in fig. 6, the table number is 12.1, and a report template with the number of 12.1 is generated according to the basic information table corresponding to 12.1 and the at least one field configuration table.
The execution subject of the report template generating method shown in fig. 1 may be a computer. As can be seen from the process shown in fig. 1, the report template generating method according to the embodiment of the present invention selects a field table name from an association table, determines table basic information data and a plurality of field data corresponding to the field table name, selects at least one field group from the plurality of field data, determines field configuration information corresponding to the field group, and generates a report template according to the field configuration information and the table basic information data corresponding to the field group.
The specific process of the embodiment of the invention is as follows:
1. receiving domain table selection information from a user, the domain table selection information including a domain table name (table english name).
2. And acquiring the association table, and selecting the corresponding field table name from the association table according to the field table selection information.
3. Determining table basic information data and a plurality of field data corresponding to the field table name, and generating a basic information table according to the table basic information data.
For example, the domain name is RWA43_ OPER _ RISK _ REQ in fig. 2, and the plurality of field data corresponding to the domain name includes date, report number, organization number, version number, currency, serial number, β coefficient, total income/loan balance first year, total income/loan balance second year, total income/loan balance third year, capital requirement first year, capital requirement second year, and capital requirement third year. The table base information data includes table numbers, for example, the table numbers include 12.1 and 12.2. In specific implementation, a user can see the table number in the table basic information data on the front-end page of the newly added data.
4. Receiving field selection information from a user, the field selection information including a table number. And selecting at least one field group from the field data according to the field selection information, and determining field configuration information corresponding to the field group.
In particular, the user may fill in the table numbers 12.1 and 12.2 on the front page of the added table fields to correspond the field sets to the basic information table. For example, field group 1 corresponding to table number 12.1 includes the following field data: the date, the report number, the organization number, the version number, the first year of total income/loan balance and the first year of capital requirement, and the field configuration information of each field data comprises a table number of 12.1; table number 12.2 corresponds to field group 2 including the following field data: date, statement code, institution number, version number, total income/loan balance second year and capital requirements second year, the field configuration information for each field data includes table number 12.2.
5. And generating a field configuration table according to the field configuration information corresponding to the field group.
For example, if the field group 1 includes six field data including date, report code, organization number, version number, total income/loan balance first year and capital requirement first year, six field configuration tables are correspondingly generated according to the field configuration information of the six field data, and the table numbers in the six field configuration tables are all 12.1. Similarly, the field group 2 includes six field data including date, report coding, organization number, version number, total income/loan balance for the second year and capital requirement for the second year, then six field configuration tables are correspondingly generated according to the field configuration information of the six field data, and the table numbers in the six field configuration tables are all 12.2.
6. Determining a field configuration table corresponding to the table number in the basic information table; and generating a report template according to the basic information table and a field configuration table corresponding to the table number in the basic information table.
For example, at this time, a report template with the number of 12.1 may be generated according to the basic information table corresponding to the table number of 12.1 and the six field configuration tables corresponding to the table number of 12.1; and generating a report template with the number of 12.2 according to the basic information table corresponding to the table number of 12.2 and the six field configuration tables corresponding to the table number of 12.2. The field data in report template 12.1 and report template 12.2 are both from the field data corresponding to RWA43_ OPER _ RISK _ REQ.
The invention can realize the automatic generation of the report template. And dynamically generating a report template in an Excel format by utilizing the background Java code through dynamically configuring the basic information data and the field configuration information of the report. In addition, the invention can also insert report data in batch. Data can be directly written in the report template through the field configuration information and the table basic information data: the background Java code determines whether to perform read-write operation or not through the configuration information of each field, so that batch import of report data is realized.
In summary, the report template generation method provided by the embodiment of the invention has the following beneficial effects:
1. the name of the report (namely the name of the Chinese character in the report) can be flexibly configured, and a plurality of reports with different formats and contents can be rapidly generated.
2. And the quick replacement and design of fields in the report are supported. And quickly generating a corresponding report template according to the fields corresponding to different focusing problems.
3. And the fast import of data is realized. The filling rules of the report template in different lines and columns are limited by setting the field format.
Based on the same inventive concept, the embodiment of the invention also provides a report template generation system, and as the problem solving principle of the system is similar to that of the report template generation method, the implementation of the system can refer to the implementation of the method, and repeated parts are not described again.
FIG. 8 is a block diagram of a report template generating system according to an embodiment of the present invention. As shown in fig. 8, the report template generation system includes:
an acquisition unit configured to acquire an association table and select a domain table name from the association table;
the data determining unit is used for determining table basic information data and a plurality of field data corresponding to the field table name;
the field configuration information determining unit is used for selecting at least one field group from the plurality of field data and determining field configuration information corresponding to the field group;
and the report template generating unit is used for generating a report template according to the field configuration information corresponding to the field group and the table basic information data.
In one embodiment, the report template generating unit is specifically configured to:
generating a basic information table according to the table basic information data;
generating a field configuration table according to the field configuration information corresponding to the field group;
and generating a report template according to the basic information table and the field configuration table.
In one embodiment, the method further comprises the following steps:
a receiving unit for receiving field selection information from a user;
the field configuration information determining unit is specifically configured to:
and selecting at least one field group from the field data according to the field selection information, and determining field configuration information corresponding to the field group.
In one embodiment, the field selection information and the table base information data each include a table number;
the report template generating unit is specifically configured to:
determining a field configuration table corresponding to the table number in the basic information table;
and generating a report template according to the basic information table and a field configuration table corresponding to the table number in the basic information table.
To sum up, the report template generating system of the embodiment of the present invention selects a field table name from the association table, determines table basic information data and a plurality of field data corresponding to the field table name, selects at least one field group from the plurality of field data, determines field configuration information corresponding to the field group, and generates the report template according to the field configuration information corresponding to the field group and the table basic information data, so that the report template can be generated quickly, and the report generating efficiency and the accuracy are improved.
The embodiment of the invention also provides a specific implementation mode of computer equipment, which can realize all the steps in the report template generation method in the embodiment. Fig. 9 is a block diagram of a computer device in an embodiment of the present invention, and referring to fig. 9, the computer device specifically includes the following:
a processor (processor)901 and a memory (memory) 902.
The processor 901 is configured to call a computer program in the memory 902, and when the processor executes the computer program, the processor implements all the steps in the report template generating method in the foregoing embodiment, for example, when the processor executes the computer program, the processor implements the following steps:
acquiring an association table and selecting a field table name from the association table;
determining table basic information data and a plurality of field data corresponding to the name of the field table;
selecting at least one field group from the plurality of field data, and determining field configuration information corresponding to the field group;
and generating a report template according to the field configuration information corresponding to the field group and the table basic information data.
To sum up, the computer device of the embodiment of the present invention selects a field table name from the association table, determines table basic information data and a plurality of field data corresponding to the field table name, selects at least one field group from the plurality of field data, determines field configuration information corresponding to the field group, and generates a report template according to the field configuration information and the table basic information data corresponding to the field group, so that the rapid generation of the report template can be realized, and the report generation efficiency and the accuracy are improved.
An embodiment of the present invention further provides a computer-readable storage medium capable of implementing all steps in the report template generating method in the foregoing embodiment, where the computer-readable storage medium stores a computer program, and when the computer program is executed by a processor, the computer program implements all steps of the report template generating method in the foregoing embodiment, for example, when the processor executes the computer program, the processor implements the following steps:
acquiring an association table and selecting a field table name from the association table;
determining table basic information data and a plurality of field data corresponding to the name of the field table;
selecting at least one field group from the plurality of field data, and determining field configuration information corresponding to the field group;
and generating a report template according to the field configuration information corresponding to the field group and the table basic information data.
To sum up, the computer-readable storage medium of the embodiment of the present invention selects a field table name from the association table, determines table basic information data and a plurality of field data corresponding to the field table name, selects at least one field group from the plurality of field data, determines field configuration information corresponding to the field group, and generates a report template according to the field configuration information corresponding to the field group and the table basic information data, so that a report template can be quickly generated, and report generation efficiency and accuracy are improved.
The above-mentioned embodiments are intended to illustrate the objects, technical solutions and advantages of the present invention in further detail, and it should be understood that the above-mentioned embodiments are only exemplary embodiments of the present invention, and are not intended to limit the scope of the present invention, and any modifications, equivalent substitutions, improvements and the like made within the spirit and principle of the present invention should be included in the scope of the present invention.
Those of skill in the art will further appreciate that the various illustrative logical blocks, units, and steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware, computer software, or combinations of both. To clearly illustrate the interchangeability of hardware and software, various illustrative components, elements, and steps have been described above generally in terms of their functionality. Whether such functionality is implemented as hardware or software depends upon the particular application and design requirements of the overall system. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present embodiments.
The various illustrative logical blocks, or elements, or devices described in connection with the embodiments disclosed herein may be implemented or performed with a general purpose processor, a digital signal processor, an Application Specific Integrated Circuit (ASIC), a field programmable gate array or other programmable logic device, discrete gate or transistor logic, discrete hardware components, or any combination thereof designed to perform the functions described herein. A general-purpose processor may be a microprocessor, but in the alternative, the processor may be any conventional processor, controller, microcontroller, or state machine. A processor may also be implemented as a combination of computing devices, e.g., a digital signal processor and a microprocessor, a plurality of microprocessors, one or more microprocessors in conjunction with a digital signal processor core, or any other similar configuration.
The steps of a method or algorithm described in connection with the embodiments disclosed herein may be embodied directly in hardware, in a software module executed by a processor, or in a combination of the two. A software module may be stored in RAM memory, flash memory, ROM memory, EPROM memory, EEPROM memory, registers, hard disk, a removable disk, a CD-ROM, or any other form of storage medium known in the art. For example, a storage medium may be coupled to the processor such the processor can read information from, and write information to, the storage medium. In the alternative, the storage medium may be integral to the processor. The processor and the storage medium may reside in an ASIC, which may be located in a user terminal. In the alternative, the processor and the storage medium may reside in different components in a user terminal.
In one or more exemplary designs, the functions described above in connection with the embodiments of the invention may be implemented in hardware, software, firmware, or any combination of the three. If implemented in software, the functions may be stored on or transmitted over as one or more instructions or code on a computer-readable medium. Computer-readable media includes both computer storage media and communication media that facilitate transfer of a computer program from one place to another. Storage media may be any available media that can be accessed by a general purpose or special purpose computer. For example, such computer-readable media can include, but is not limited to, RAM, ROM, EEPROM, CD-ROM or other optical disk storage, magnetic disk storage or other magnetic storage devices, or any other medium which can be used to carry or store program code in the form of instructions or data structures and which can be read by a general-purpose or special-purpose computer, or a general-purpose or special-purpose processor. Additionally, any connection is properly termed a computer-readable medium, and, thus, is included if the software is transmitted from a website, server, or other remote source via a coaxial cable, fiber optic cable, twisted pair, Digital Subscriber Line (DSL), or wirelessly, e.g., infrared, radio, and microwave. Such discs (disk) and disks (disc) include compact disks, laser disks, optical disks, DVDs, floppy disks and blu-ray disks where disks usually reproduce data magnetically, while disks usually reproduce data optically with lasers. Combinations of the above may also be included in the computer-readable medium.
Claims (10)
1. A report template generation method is characterized by comprising the following steps:
acquiring an association table and selecting a field table name from the association table;
determining table basic information data and a plurality of field data corresponding to the field table name;
selecting at least one field group from the plurality of field data, and determining field configuration information corresponding to the field group;
and generating a report template according to the field configuration information corresponding to the field group and the table basic information data.
2. The report template generating method according to claim 1, wherein generating a report according to the field configuration information corresponding to the field group and the table base information data comprises:
generating a basic information table according to the table basic information data;
generating a field configuration table according to the field configuration information corresponding to the field group;
and generating a report template according to the basic information table and the field configuration table.
3. The reporting template generating method as recited in claim 2, further comprising:
receiving field selection information from a user;
selecting at least one field group from the plurality of field data, and determining field configuration information corresponding to the field group includes:
and selecting at least one field group from the plurality of field data according to the field selection information, and determining field configuration information corresponding to the field group.
4. The reporting template generating method as recited in claim 3,
the field selection information and the table basic information data both comprise table numbers;
generating a report template according to the basic information table and the field configuration table comprises the following steps:
determining a field configuration table corresponding to the table number in the basic information table;
and generating a report template according to the basic information table and a field configuration table corresponding to the table number in the basic information table.
5. A report template generation system, comprising:
an acquisition unit configured to acquire an association table and select a domain table name from the association table;
the data determining unit is used for determining table basic information data and a plurality of field data corresponding to the field table name;
a field configuration information determining unit, configured to select at least one field group from the plurality of field data, and determine field configuration information corresponding to the field group;
and the report template generating unit is used for generating a report template according to the field configuration information corresponding to the field group and the table basic information data.
6. The reporting template generating system of claim 5, wherein the reporting template generating unit is specifically configured to:
generating a basic information table according to the table basic information data;
generating a field configuration table according to the field configuration information corresponding to the field group;
and generating a report template according to the basic information table and the field configuration table.
7. The reporting template generating system as recited in claim 6, further comprising:
a receiving unit for receiving field selection information from a user;
the field configuration information determining unit is specifically configured to:
and selecting at least one field group from the plurality of field data according to the field selection information, and determining field configuration information corresponding to the field group.
8. The reporting template generating system as recited in claim 7,
the field selection information and the table basic information data both comprise table numbers;
the report template generating unit is specifically configured to:
determining a field configuration table corresponding to the table number in the basic information table;
and generating a report template according to the basic information table and a field configuration table corresponding to the table number in the basic information table.
9. A computer device comprising a memory, a processor and a computer program stored on the memory and running on the processor, wherein the processor when executing the computer program implements the steps of the report template generation method of any of claims 1 to 4.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the report template generating method according to any one of claims 1 to 4.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011036326.1A CN112084762A (en) | 2020-09-27 | 2020-09-27 | Report template generation method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202011036326.1A CN112084762A (en) | 2020-09-27 | 2020-09-27 | Report template generation method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN112084762A true CN112084762A (en) | 2020-12-15 |
Family
ID=73738486
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202011036326.1A Pending CN112084762A (en) | 2020-09-27 | 2020-09-27 | Report template generation method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN112084762A (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20200073926A1 (en) * | 2017-05-09 | 2020-03-05 | Hefei Hanteng Information Technology Co., Ltd. | Form customization method and device |
| CN111158795A (en) * | 2019-12-24 | 2020-05-15 | 深圳壹账通智能科技有限公司 | Report generation method, device, medium and electronic equipment |
| CN111563368A (en) * | 2020-04-03 | 2020-08-21 | 江苏苏宁物流有限公司 | Report generation method and device, computer equipment and storage medium |
-
2020
- 2020-09-27 CN CN202011036326.1A patent/CN112084762A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20200073926A1 (en) * | 2017-05-09 | 2020-03-05 | Hefei Hanteng Information Technology Co., Ltd. | Form customization method and device |
| CN111158795A (en) * | 2019-12-24 | 2020-05-15 | 深圳壹账通智能科技有限公司 | Report generation method, device, medium and electronic equipment |
| CN111563368A (en) * | 2020-04-03 | 2020-08-21 | 江苏苏宁物流有限公司 | Report generation method and device, computer equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11816100B2 (en) | Dynamically materialized views for sheets based data | |
| CN109766497B (en) | Ranking list generation method and device, storage medium and electronic equipment | |
| US11086894B1 (en) | Dynamically updated data sheets using row links | |
| CN111126019B (en) | Report generation method and device based on mode customization and electronic equipment | |
| CN107544808A (en) | The generation method and device of a kind of web form | |
| CN111400387B (en) | Conversion method and device for import and export data, terminal equipment and storage medium | |
| CN104881275A (en) | Electronic spreadsheet generating method and device | |
| CN112434015B (en) | Data storage method and device, electronic equipment and medium | |
| CN111367976A (en) | Method and device for exporting EXCEL file data based on JAVA reflection mechanism | |
| CN111782117B (en) | Interface display method and device, storage medium and electronic device | |
| CN115840567A (en) | Application editing method and related equipment | |
| CN116468010A (en) | Report generation method, device, terminal and storage medium | |
| CN114238527A (en) | Data processing method and data processing device based on object relation mapping | |
| CN112861491A (en) | Report processing method and device, electronic equipment and computer readable storage medium | |
| CN110704635B (en) | Method and device for converting triplet data in knowledge graph | |
| TW201525737A (en) | Method for automatically generating website interactive program | |
| CN112084762A (en) | Report template generation method and system | |
| CN102866985A (en) | Data formatting device and method for on-line analytical processing system | |
| US20230195792A1 (en) | Database management methods and associated apparatus | |
| CN111933228B (en) | Method and device for realizing project distribution and management system in clinical research | |
| CN113254455A (en) | Dynamic configuration method and device of database, computer equipment and storage medium | |
| CN114385722A (en) | Interface attribute consistency checking method and device, electronic equipment and storage medium | |
| JP2020087087A (en) | Correction candidate specification program | |
| CN116611418B (en) | Report processing method and device based on online editing, electronic equipment and medium | |
| CN115599976B (en) | User grouping method, device, electronic 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 |