CN111158650B - Report template and report generation method and device - Google Patents
Report template and report generation method and device Download PDFInfo
- Publication number
- CN111158650B CN111158650B CN201911358119.5A CN201911358119A CN111158650B CN 111158650 B CN111158650 B CN 111158650B CN 201911358119 A CN201911358119 A CN 201911358119A CN 111158650 B CN111158650 B CN 111158650B
- Authority
- CN
- China
- Prior art keywords
- information
- report
- data
- data item
- generating
- 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.)
- Active
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F8/00—Arrangements for software engineering
- G06F8/20—Software design
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
Abstract
The report template maps data items by setting identification codes, so that data replacement can be performed when a report is generated, and a corresponding report is obtained.
Description
Technical Field
The invention relates to the field of report configuration, in particular to a report template, a report template and a report generation method and device.
Background
The report is the last ring of data processing and displaying of all software systems, and three main modes are adopted for the report generation mode: one is to generate a report configuration file through a report sample customization tool, and then generate a report file, such as wet-dry and cognos, according to the configuration file; one is to set up a report form sample to generate a report form by using an excel-like tool, such as a Simeit Smart report tool; the report is generated through program customization development, so that the cost is relatively high; the report tool is not enough in the use process: the report is complex to realize, the development and maintenance cost is high, the report cannot be well fused with the existing system, and particularly when the data in the report is continuously updated, the report generation step needs to be repeated, so that the scheme is more complex.
Disclosure of Invention
To solve at least one of the above problems, an embodiment of an aspect of the present application provides a report template generating method, including:
configuring data items required by a report template according to data item demand information in the setting configuration information, wherein the data items are stored in a specified database, and the data information of the data items is updated according to fixed or non-fixed time intervals;
generating a report template intermediate file with a set table layout; each table corresponds to a data item;
configuring table information of each table according to data items corresponding to each table, further generating the report template, wherein the table information comprises identification codes, the identification codes and the data items have a first mapping relation,
when generating a report, the current data information of the corresponding data item is used for replacing the table information of each table in the report template, so that a report is obtained.
In some embodiments, the table information further includes a placeholder, the placeholder having a second mapping relationship with a manner of processing the data item; the report template generation method further comprises the following steps:
configuring a processing mode of the data item according to the data item processing information in the setting configuration information; and when generating the report, further processing the replacement data in each table according to the placeholders to obtain the report.
In some embodiments, further comprising:
configuring index information of the data items, wherein the index information can be used for acquiring data information of corresponding data items in a designated database, and the index information and the identification code have a third mapping relation;
the first mapping relation is determined through the third mapping relation and the mapping relation between the data item and the index information.
In some embodiments, the configuring the index information of the data item includes: configuring data source type information, data source name information and SQL execution statements;
the data source type information can determine a connection driving interface used by a program to access the corresponding database, the data source name information can determine the corresponding database, and the SQL execution statement can obtain corresponding data through execution on the corresponding database.
In some embodiments, the setting configuration information includes typesetting information of each data item, and the generating a reporting template intermediate file with a setting table layout includes:
and generating the report template intermediate file according to the typesetting information of each data item.
Another embodiment of the present application provides a report generating method, including:
Determining data items in the corresponding tables according to the table information of each table in the report template; the table information includes an identification code having a first mapping relation with a data item, the data item being stored in a specified database, and the data information of the data item being updated at fixed or non-fixed time intervals;
and replacing the corresponding table information with the current data information of the data item to obtain a report.
In some embodiments, the table information further includes a placeholder, the placeholder having a second mapping relationship with a manner of processing the data item; the report generating method further comprises the following steps:
and processing the replacement data in each table according to the placeholders to obtain the report.
In some embodiments, further comprising:
acquiring report generation plan information; the report generation plan information comprises generation time points of at least one report; wherein, the liquid crystal display device comprises a liquid crystal display device,
and determining the data items in the corresponding tables according to the table information of each table in the report template to respond to the corresponding generation time points for execution.
In some embodiments, the determining the data item in the corresponding table according to the table information of each table in the report template includes:
Determining corresponding data item index information according to the identification code in the table information;
and acquiring the current data information of the appointed data item in the appointed database according to the data item index information.
In yet another aspect, an embodiment of the present application provides a reporting template having a set table layout, where each table in the reporting template includes table information; wherein, the liquid crystal display device comprises a liquid crystal display device,
the table information includes an identification code having a first mapping relation with a data item, the data item being stored in a specified database, and the data information of the data item being updated at fixed or non-fixed time intervals;
when generating a report, the current data information of the corresponding data item is used for replacing the table information of each table in the report template, so as to obtain a report.
In some embodiments, the table information further includes a placeholder, the placeholder having a second mapping relationship with a manner of processing the data item; and when generating the report, further processing the replacement data in each table according to the placeholders to obtain the report.
In still another aspect, an embodiment of the present application provides a report template generating apparatus, including:
The data item configuration module configures data items required by the report template according to the data item requirement information in the setting configuration information, the data items are stored in a specified database, and the data information of the data items is updated according to fixed or non-fixed time intervals;
the intermediate file generation module generates a report template intermediate file with a set table layout; each table corresponds to a data item;
the report template generation module is used for configuring the table information of each table according to the data item corresponding to each table, so as to generate the report template, wherein the table information comprises identification codes, and the identification codes and the data items have a first mapping relation;
when generating a report, the current data information of the corresponding data item is used for replacing the table information of each table in the report template, so that a report is obtained.
In some embodiments, the table information further includes a placeholder, the placeholder having a second mapping relationship with a manner of processing the data item; the report template generating device further comprises:
the processing mode configuration module configures the processing mode of the data item according to the data item processing information in the setting configuration information; and when generating the report, further processing the replacement data in each table according to the placeholders to obtain the report.
In some embodiments, further comprising:
the index information configuration module is used for configuring index information of the data items, wherein the index information can be used for acquiring data information of corresponding data items in a specified database, and the index information and the identification code have a third mapping relation;
the first mapping relation is determined through the third mapping relation and the mapping relation between the data item and the index information.
In some embodiments, the index information includes data source type information, data source name information, and SQL execution statements;
the data source type information can determine a connection driving interface used by a program to access the corresponding database, the data source name information can determine the corresponding database, and the SQL execution statement can obtain corresponding data through execution on the corresponding database.
In some embodiments, the setting configuration information includes typesetting information of each data item, and the intermediate file generating module generates the reporting template intermediate file according to the typesetting information of each data item.
In still another aspect, an embodiment of the present application provides a report generating apparatus, including:
The data item determining module is used for determining data items in the corresponding tables according to the table information of each table in the report template; the table information includes an identification code having a first mapping relation with a data item, the data item being stored in a specified database, and the data information of the data item being updated at fixed or non-fixed time intervals;
and the report generation module is used for replacing corresponding table information with the current data information of the data item to obtain a report.
In some embodiments, the table information further includes a placeholder, the placeholder having a second mapping relationship with a manner of processing the data item; the report generating device further comprises:
and the data item processing module is used for processing the replacement data in each table according to the placeholders to obtain the report.
In some embodiments, further comprising:
the report generation plan information acquisition module acquires report generation plan information; the report generation plan information comprises generation time points of at least one report; wherein, the liquid crystal display device comprises a liquid crystal display device,
the data item determination module performs the corresponding steps in response to the corresponding generation time points.
In some embodiments, the data item determination module comprises:
An index information determining unit for determining corresponding data item index information according to the identification code in the table information;
and the current data information acquisition unit acquires the current data information of the appointed data item in the appointed database according to the data item index information.
In yet another aspect, embodiments of the present application provide a computer device including a memory, a processor, and a computer program stored on the memory and executable on the processor, the processor implementing the steps of the method described above when the program is executed.
In yet another aspect, embodiments of the present application provide a computer-readable storage medium having stored thereon a computer program which, when executed by a processor, performs the steps of the method described above.
The beneficial effects of this application are as follows:
the report template maps data items by setting identification codes, so that data replacement can be performed when a report is generated, and a corresponding report is obtained.
Drawings
In order to more clearly illustrate the embodiments of the invention or the technical solutions in the prior art, the drawings that are required in the embodiments or the description of the prior art will be briefly described, it being obvious that the drawings in the following description are only some embodiments of the invention, and that other drawings may be obtained according to these drawings without inventive effort for a person skilled in the art.
Fig. 1 shows a flowchart of a report template generating method in an embodiment of the invention.
Fig. 2 is a schematic flow chart of a report generation method in an embodiment of the invention.
Fig. 3 is a schematic structural diagram of a report template generating device in an embodiment of the invention.
Fig. 4 shows a schematic structural diagram of a report generating device in an embodiment of the invention.
Fig. 5 shows a schematic structural diagram of a computer device suitable for use in implementing embodiments of the present application.
Detailed Description
The following description of the embodiments of the present invention will be made clearly and completely with reference to the accompanying drawings, in which it is apparent that the embodiments described are only some embodiments of the present invention, but not all embodiments. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
For the purpose of making the objects, technical solutions and advantages of the embodiments of the present invention more apparent, the technical solutions of the embodiments of the present invention will be clearly and completely described below with reference to the accompanying drawings in the embodiments of the present invention, and it is apparent that the described embodiments are some embodiments of the present invention, but not all embodiments of the present invention. All other embodiments, which can be made by those skilled in the art based on the embodiments of the invention without making any inventive effort, are intended to be within the scope of the invention.
An embodiment of the first aspect of the present invention provides a specific implementation manner of a report template generating method, referring to fig. 1, where the report template generating method specifically includes the following contents:
step 100: and configuring data items required by the report template according to the data item requirement information in the setting configuration information.
In step 100, configuration information is set to include a required data item, which is an indivisible minimum unit of data. The names of the data items are numbers, aliases, profiles, lengths and types of the data items and value ranges of the data items. The data item is the most basic, inseparable, unit of named data in the data record, being the smallest unit of identification with an independent meaning. In brief, the data item is an "attribute template" of the data, for example, the data item is an "amount", and the data information of the corresponding data item may be digital information such as 2000, 1000 (unit cell)), and the amount indicates an attribute of the digital information, that is, the amount is 2000, 1000, and the like.
In this application, data items are stored in a designated database, and data information of the data items is updated at fixed or non-fixed time intervals. Also taking the amount as an example, the data information of 1 minute at 11.11.11.10 in 2019 is 2000 yuan, but the data information of 11.11.11.11 in 2019 is 1000 yuan, that is, the data information of the data item is not fixed.
In addition, the data information of the data item may be updated at a set frequency, that is, at fixed time intervals, or may be updated irregularly, as long as the data information of the data item is updated.
Step 200: generating a report template intermediate file with a set table layout; each table corresponds to a data item.
In step 200, the middle file of the report template has a set table layout, i.e. the style information of the report is already provided, and specific data contents, such as length and width data of each table, data items corresponding to each table, etc., are not filled in each table.
Step 300: and configuring table information of each table according to the data item corresponding to each table, and further generating the report template, wherein the table information comprises identification codes, and the identification codes and the data items have a first mapping relation.
In step 300, the identification code may be a mapping code formed by letters, etc., through which a corresponding data item may be found, for example, in some embodiments, the identification code may find corresponding index information, through which a data item in a specified database may be retrieved, in this embodiment, if the index information and the identification code have a third mapping relationship, the first mapping relationship is determined together through the third mapping relationship and the mapping relationship between the data item and the index information, that is, the data item-index relationship-identification code is mapped one by one, it may be understood that the index information includes guiding information pointing to a database, and positioning information positioning the corresponding data item in the database, and some of these information may be implemented through SQL execution statement, and the above indexing manner may be a well-known indexing manner, which is not repeated herein.
It can be understood that when the report template generated by the method is used for generating a report, the current data information of the corresponding data item is used for replacing the table information of each table in the report template, so that a report is obtained.
As can be seen from the foregoing description, the embodiment of the present invention provides a report template generating method, where the report template maps data items by setting identification codes, so that data can be replaced when a report is generated, and a corresponding report is obtained.
In a specific embodiment, the index information, the identification code and the mapping relation with the data item may be configured, and the method steps of the application are executed by using the configured index information and mapping relation.
In another specific embodiment, the configuration process of the index information, the identification code and the mapping relation between the index information, the identification code and the data item may be a method step completed in the present application, that is, the report template generating method of the present application further includes:
step A100: and configuring index information of the data items, wherein the index information can be used for acquiring data information of corresponding data items in a designated database.
In specific implementation, the index information includes configuration data source type information, data source name information and SQL execution statement, table 1 shows a specific structure schematic table of the index information, and the index information is replaced by the name of "result set" in the embodiment shown in the table, and it is understood that the result set is the index information described above, and the two are consistent.
TABLE 1 information Structure schematic form
When index information (i.e., result set) is specifically configured, firstly defining whether the data source type is oracle, mysql, hbase and other types, and determining the connection driving interface used when a program accesses a corresponding database; then define the data source name, namely generally the data source (DataSource), through which the corresponding database can be accessed and execute the corresponding SQL statement on the corresponding database; the result set name is what must be specified when the data item is configured; the frequency indicates the frequency of the provision of the result set data, and if T indicates the current day, T-1 indicates the previous day, and so on.
In some preferred embodiments, a report after processing the data information of the data item may also be obtained through a report model, where in this embodiment, the table information further includes a placeholder, and the placeholder has a second mapping relationship with a processing manner of the data item. The report model generating method in this embodiment further includes:
step A200: configuring a processing mode of the data item according to the data item processing information in the setting configuration information; and when generating the report, further processing the replacement data in each table according to the placeholders to obtain the report.
In this embodiment, the placeholders may be symbols with respective versatility, such as%, # and the like, and form table information together with the identifier, that is, the placeholders may exist in a "co-existence" form with the identifier, for example, the table information may be expressed in the following form: placeholder-identification code-placeholder, e.g. rpt_nm in the table below, which defines the processing mode, the identification codes in two identical placeholders can map the current data information corresponding to the data item, such a representation mode can clearly define which data information is processed, and the demarcation is clear, table 2 shows the specific form of the placeholder:
TABLE 2 specific forms of placeholders
It can be appreciated that, in a further embodiment, the report template generating method of the present application further includes:
step A300: and configuring a second mapping relation between the placeholder and the processing mode of the data item.
It is clear to those skilled in the art that the first to third mapping relationships are just noun definitions in the present application to distinguish and clarify the mapping relationships, and the first to third mapping relationships have no hierarchical progression and no sequential relationship with each other.
The setting of the placeholders further enables the report template to be further used for generating reports with processed data information of the data items, so that the diversity of report generation is increased, and the generation requirements of more complicated reports can be met.
In some embodiments, the setting configuration information includes layout information of each data item, that is, a specific layout and a specific layout of each data item, and in this embodiment, step 200 specifically includes:
and generating the report template intermediate file according to the typesetting information of each data item.
As can be seen from the above description, according to the report template generating method provided by the embodiment of the invention, the data items are mapped by setting the identification codes, so that the corresponding report can be obtained by replacing the data when the report is generated.
As can be appreciated based on the description of the foregoing embodiments, as shown in fig. 2, the method for generating a report further includes:
step 500: determining data items in the corresponding tables according to the table information of each table in the report template; the table information includes an identification code having a first mapping relation with a data item, the data item is stored in a specified database, and the data information of the data item is updated at fixed or non-fixed time intervals.
Step 600: and replacing the corresponding table information with the current data information of the data item to obtain a report.
The report template is a template structure generated by the report template generation method, because the table information of each table in the report template is fixed, the current data information of the data item can be acquired according to the table information and the corresponding mapping relation, and then the report is generated.
Furthermore, in a preferred embodiment, the table information further includes a placeholder, and the placeholder has a second mapping relationship with the processing manner of the data item; the report generating method further comprises the following steps:
step 700: and processing the replacement data in each table according to the placeholders to obtain the report.
The function of the placeholders is consistent with that described above and will not be described in detail herein.
In a preferred embodiment, the report generating method further includes:
acquiring report generation plan information; the report generation plan information comprises generation time points of at least one report; and determining the data items in the corresponding tables according to the table information of each table in the report template, and executing the data items in the corresponding tables in response to the corresponding generation time points.
Specifically, when generating a report, firstly, reading a report plan to be generated, and processing the report plan one by one; firstly, judging whether the report is generated or not, and processing the next report if the report is generated; and if the set generation time is up, generating a report according to the form information.
Again, in one embodiment, step 500 specifically includes:
step 501: and determining corresponding data item index information according to the identification code in the table information.
Step 502: and acquiring the current data information of the appointed data item in the appointed database according to the data item index information.
As can be seen from the above description, according to the report generating method provided by the embodiment of the invention, the data item is mapped by setting the identification code, so that the corresponding report can be obtained by replacing the data when the report is generated.
In addition, based on the same inventive concept, the present application further provides a reporting template having a set table layout, each table in the reporting template including table information; wherein the table information includes an identification code having a first mapping relation with a data item, the data item being stored in a specified database, and the data information of the data item being updated at fixed or non-fixed time intervals; when generating a report, the current data information of the corresponding data item is used for replacing the table information of each table in the report template, so as to obtain a report.
It can be understood that the report template maps the data item by setting the identification code, so that the data can be replaced when the report is generated, and a corresponding report is obtained.
The embodiment of the invention provides a concrete implementation mode of a report template generating device for realizing all contents in a report template generating method, and referring to fig. 3, the report template generating device specifically comprises the following contents:
a data item configuration module 10 for configuring data items required for the reporting template according to the data item requirement information in the setting configuration information, the data items being stored in a designated database, and the data information of the data items being updated at fixed or non-fixed time intervals;
The intermediate file generating module 20 generates a report template intermediate file with a set table layout; each table corresponds to a data item;
the report template generating module 30 configures table information of each table according to a data item corresponding to each table, so as to generate the report template, wherein the table information comprises an identification code, and the identification code and the data item have a first mapping relation;
when generating a report, the current data information of the corresponding data item is used for replacing the table information of each table in the report template, so that a report is obtained.
The embodiment for implementing the report template generating device provided in the present application may be specifically used to execute the processing flow of the embodiment for implementing the report template generating method in the foregoing embodiment, and the functions thereof are not described herein in detail, and may refer to the detailed description of the foregoing method embodiment.
Wherein, the table information also comprises a placeholder, and the placeholder and the processing mode of the data item have a second mapping relation; the report template generating device further comprises:
the processing mode configuration module configures the processing mode of the data item according to the data item processing information in the setting configuration information; and when generating the report, further processing the replacement data in each table according to the placeholders to obtain the report.
Wherein, the report template generating device further comprises:
the index information configuration module is used for configuring index information of the data items, wherein the index information can be used for acquiring data information of corresponding data items in a specified database, and the index information and the identification code have a third mapping relation;
the first mapping relation is determined through the third mapping relation and the mapping relation between the data item and the index information.
The index information comprises data source type information, data source name information and SQL execution sentences;
the data source type information can determine a connection driving interface used by a program to access the corresponding database, the data source name information can determine the corresponding database, and the SQL execution statement can obtain corresponding data through execution on the corresponding database.
The setting configuration information comprises typesetting information of each data item, and the intermediate file generation module generates the intermediate file of the report template according to the typesetting information of each data item.
Still another aspect of the present invention further provides a report generating apparatus, as shown in fig. 4, including:
The data item determining module 50 determines the data item in the corresponding table according to the table information of each table in the report template; the table information includes an identification code having a first mapping relation with a data item, the data item being stored in a specified database, and the data information of the data item being updated at fixed or non-fixed time intervals;
the report generation module 60 replaces the corresponding table information with the current data information of the data item to obtain a report.
Wherein, the report generating device further comprises:
the report generation plan information acquisition module acquires report generation plan information; the report generation plan information comprises generation time points of at least one report; wherein, the liquid crystal display device comprises a liquid crystal display device,
the data item determination module performs the corresponding steps in response to the corresponding generation time points.
Wherein the data item determination module comprises:
an index information determining unit for determining corresponding data item index information according to the identification code in the table information;
and the current data information acquisition unit acquires the current data information of the appointed data item in the appointed database according to the data item index information.
The embodiment for implementing the report generating device provided in the present application may be specifically used to execute the processing flow of the embodiment for implementing the report generating method in the foregoing embodiment, and the functions thereof are not described herein in detail, and may refer to the detailed description of the foregoing method embodiment.
The embodiment of the present application further provides a specific implementation manner of an electronic device capable of implementing all the steps in the report template generating method in the foregoing embodiment, and referring to fig. 5, the electronic device specifically includes the following contents:
a processor (processor) 601, a memory (memory) 602, a communication interface (Communications Interface) 603, and a bus 604;
wherein the processor 601, the memory 602, and the communication interface 603 complete communication with each other through the bus 604; the communication interface 603 is used for realizing information transmission between the report template generating device and related equipment such as a user terminal;
the processor 601 is configured to invoke a computer program in the memory 602, where the processor executes the computer program to implement all the steps in the report template generating method and the report generating method in the foregoing embodiments.
Embodiments of the present application also provide a computer-readable storage medium capable of implementing all the steps of the report template generation method in the above embodiments, where the computer-readable storage medium stores a computer program, and the computer program implements all the steps of the report template generation method in the above embodiments when executed by a processor.
In this specification, each embodiment is described in a progressive manner, and identical and similar parts of each embodiment are all referred to each other, and each embodiment mainly describes differences from other embodiments. In particular, for a hardware+program class embodiment, the description is relatively simple, as it is substantially similar to the method embodiment, as relevant see the partial description of the method embodiment.
The foregoing describes specific embodiments of the present disclosure. Other embodiments are within the scope of the following claims. In some cases, the actions or steps recited in the claims can be performed in a different order than in the embodiments and still achieve desirable results. In addition, the processes depicted in the accompanying figures do not necessarily require the particular order shown, or sequential order, to achieve desirable results. In some embodiments, multitasking and parallel processing are also possible or may be advantageous.
Although the present application provides method operational steps as described in the examples or flowcharts, more or fewer operational steps may be included based on conventional or non-inventive labor. The order of steps recited in the embodiments is merely one way of performing the order of steps and does not represent a unique order of execution. When implemented by an actual device or client product, the instructions may be executed sequentially or in parallel (e.g., in a parallel processor or multi-threaded processing environment) as shown in the embodiments or figures.
The system, apparatus, module or unit set forth in the above embodiments may be implemented in particular by a computer chip or entity, or by a product having a certain function. One typical implementation is a computer. In particular, the computer may be, for example, a personal computer, a laptop computer, a car-mounted human-computer interaction device, a cellular telephone, a camera phone, a smart phone, a personal digital assistant, a media player, a navigation device, an email device, a game console, a tablet computer, a wearable device, or a combination of any of these devices.
Although the present description provides method operational steps as described in the examples or flowcharts, more or fewer operational steps may be included based on conventional or non-inventive means. The order of steps recited in the embodiments is merely one way of performing the order of steps and does not represent a unique order of execution. When implemented in an actual device or end product, the instructions may be executed sequentially or in parallel (e.g., in a parallel processor or multi-threaded processing environment, or even in a distributed data processing environment) as illustrated by the embodiments or by the figures. The terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, it is not excluded that additional identical or equivalent elements may be present in a process, method, article, or apparatus that comprises a described element.
For convenience of description, the above devices are described as being functionally divided into various modules, respectively. Of course, when implementing the embodiments of the present disclosure, the functions of each module may be implemented in the same or multiple pieces of software and/or hardware, or a module that implements the same function may be implemented by multiple sub-modules or a combination of sub-units, or the like. The above-described apparatus embodiments are merely illustrative, for example, the division of the units is merely a logical function division, and there may be additional divisions when actually implemented, for example, multiple units or components may be combined or integrated into another system, or some features may be omitted or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed with each other may be an indirect coupling or communication connection via some interfaces, devices or units, which may be in electrical, mechanical or other form.
Those skilled in the art will also appreciate that, in addition to implementing the controller in a pure computer readable program code, it is well possible to implement the same functionality by logically programming the method steps such that the controller is in the form of logic gates, switches, application specific integrated circuits, programmable logic controllers, embedded microcontrollers, etc. Such a controller can be regarded as a hardware component, and means for implementing various functions included therein can also be regarded as a structure within the hardware component. Or even means for achieving the various functions may be regarded as either software modules implementing the methods or structures within hardware components.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
In one typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.
The memory may include volatile memory in a computer-readable medium, random Access Memory (RAM) and/or nonvolatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). Memory is an example of computer-readable media.
Computer readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of storage media for a computer include, but are not limited to, phase change memory (PRAM), static Random Access Memory (SRAM), dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), read Only Memory (ROM), electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), digital Versatile Discs (DVD) or other optical storage, magnetic cassettes, magnetic tape magnetic disk storage or other magnetic storage devices, or any other non-transmission medium, which can be used to store information that can be accessed by a computing device. Computer-readable media, as defined herein, does not include transitory computer-readable media (transmission media), such as modulated data signals and carrier waves.
It will be appreciated by those skilled in the art that embodiments of the present description may be provided as a method, system, or computer program product. Accordingly, the present specification embodiments may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present description embodiments may take the form of a computer program product on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, etc.) having computer-usable program code embodied therein.
The present embodiments may be described in the general context of computer-executable instructions, such as program modules, being executed by a computer. Generally, program modules include routines, programs, objects, components, data structures, etc. that perform particular tasks or implement particular abstract data types. The embodiments of the specification may also be practiced in distributed computing environments where tasks are performed by remote processing devices that are linked through a communications network. In a distributed computing environment, program modules may be located in both local and remote computer storage media including memory storage devices.
In this specification, each embodiment is described in a progressive manner, and identical and similar parts of each embodiment are all referred to each other, and each embodiment mainly describes differences from other embodiments. In particular, for system embodiments, since they are substantially similar to method embodiments, the description is relatively simple, as relevant to see a section of the description of method embodiments. In the description of the present specification, a description referring to terms "one embodiment," "some embodiments," "examples," "specific examples," or "some examples," etc., means that a particular feature, structure, material, or characteristic described in connection with the embodiment or example is included in at least one embodiment or example of the embodiments of the present specification. In this specification, schematic representations of the above terms are not necessarily directed to the same embodiment or example. Furthermore, the particular features, structures, materials, or characteristics described may be combined in any suitable manner in any one or more embodiments or examples. Furthermore, the different embodiments or examples described in this specification and the features of the different embodiments or examples may be combined and combined by those skilled in the art without contradiction.
The foregoing is merely an example of an embodiment of the present disclosure and is not intended to limit the embodiment of the present disclosure. Various modifications and variations of the illustrative embodiments will be apparent to those skilled in the art. Any modification, equivalent replacement, improvement, or the like, which is within the spirit and principles of the embodiments of the present specification, should be included in the scope of the claims of the embodiments of the present specification.
Claims (18)
1. A report template generation method is characterized by comprising the following steps:
configuring data items required by a report template according to data item demand information in the setting configuration information, wherein the data items are stored in a specified database, and the data information of the data items is updated according to fixed or non-fixed time intervals;
generating a report template intermediate file with a set table layout; each table corresponds to a data item;
configuring table information of each table according to data items corresponding to each table, further generating the report template, wherein the table information comprises identification codes, the identification codes and the data items have a first mapping relation,
when generating a report, replacing the table information of each table in the report template with the current data information of the corresponding data item to obtain a report;
The method further comprises the steps of:
configuring index information of the data items, wherein the index information can be used for acquiring data information of corresponding data items in a designated database, and the index information and the identification code have a third mapping relation;
the first mapping relation is determined through the third mapping relation and the mapping relation between the data item and the index information.
2. The report template generating method according to claim 1, wherein the table information further comprises placeholders, and the placeholders have a second mapping relation with the processing mode of the data item; the report template generation method further comprises the following steps:
configuring a processing mode of the data item according to the data item processing information in the setting configuration information; and when generating the report, further processing the replacement data in each table according to the placeholders to obtain the report.
3. The report template generating method according to claim 1, wherein said configuring index information of said data item comprises: configuring data source type information, data source name information and SQL execution statements;
the data source type information can determine a connection driving interface used by a program to access the corresponding database, the data source name information can determine the corresponding database, and the SQL execution statement can obtain corresponding data through execution on the corresponding database.
4. The report template generating method according to claim 1, wherein the setting configuration information includes layout information of each data item, and the generating a report template intermediate file having a setting table layout includes:
and generating the report template intermediate file according to the typesetting information of each data item.
5. A report generation method, comprising:
determining data items in the corresponding tables according to the table information of each table in the report template; the table information includes an identification code having a first mapping relation with a data item, the data item being stored in a specified database, and the data information of the data item being updated at fixed or non-fixed time intervals;
replacing corresponding table information with the current data information of the data item to obtain a report;
the determining the data item in the corresponding table according to the table information of each table in the report template comprises the following steps:
determining corresponding data item index information according to the identification code in the table information;
and acquiring the current data information of the appointed data item in the appointed database according to the data item index information.
6. The report generating method as recited in claim 5, wherein the table information further comprises placeholders, the placeholders having a second mapping relationship with the manner in which the data items are processed; the report generating method further comprises the following steps:
And processing the replacement data in each table according to the placeholders to obtain the report.
7. The report generating method as recited in claim 5, further comprising:
acquiring report generation plan information; the report generation plan information comprises generation time points of at least one report; wherein, the liquid crystal display device comprises a liquid crystal display device,
and determining the data items in the corresponding tables according to the table information of each table in the report template to respond to the corresponding generation time points for execution.
8. A reporting template product having a set table layout, wherein each table in the reporting template product includes table information; wherein, the liquid crystal display device comprises a liquid crystal display device,
the table information includes an identification code having a first mapping relation with a data item, the data item being stored in a specified database, and the data information of the data item being updated at fixed or non-fixed time intervals;
when generating a report, replacing the table information of each table in the report template product with the current data information of the corresponding data item to obtain a report;
the data items also have index information, wherein the index information can be used for acquiring the data information of the corresponding data item in the appointed database, and the index information and the identification code have a third mapping relation;
The first mapping relation is determined through the third mapping relation and the mapping relation between the data item and the index information.
9. The reporting template product of claim 8 wherein the form information further comprises placeholders, the placeholders having a second mapping relationship with the manner in which the data items are processed; and when generating the report, further processing the replacement data in each table according to the placeholders to obtain the report.
10. A report template generating apparatus, comprising:
the data item configuration module configures data items required by the report template according to the data item requirement information in the setting configuration information, the data items are stored in a specified database, and the data information of the data items is updated according to fixed or non-fixed time intervals;
the intermediate file generation module generates a report template intermediate file with a set table layout; each table corresponds to a data item;
the report template generation module is used for configuring the table information of each table according to the data item corresponding to each table, so as to generate the report template, wherein the table information comprises identification codes, and the identification codes and the data items have a first mapping relation;
When generating a report, replacing the table information of each table in the report template with the current data information of the corresponding data item to obtain a report;
the index information configuration module is used for configuring index information of the data items, wherein the index information can be used for acquiring data information of corresponding data items in a specified database, and the index information and the identification code have a third mapping relation;
the first mapping relation is determined through the third mapping relation and the mapping relation between the data item and the index information.
11. The report template generating apparatus according to claim 10, wherein the table information further includes placeholders, the placeholders having a second mapping relationship with the manner in which the data items are processed; the report template generating device further comprises:
the processing mode configuration module configures the processing mode of the data item according to the data item processing information in the setting configuration information; and when generating the report, further processing the replacement data in each table according to the placeholders to obtain the report.
12. The report template generating apparatus according to claim 10, wherein the index information includes data source type information, data source name information, and SQL execution statements;
The data source type information can determine a connection driving interface used by a program to access the corresponding database, the data source name information can determine the corresponding database, and the SQL execution statement can obtain corresponding data through execution on the corresponding database.
13. The report template generating apparatus according to claim 10, wherein the setting configuration information includes layout information of each data item, and the intermediate file generating module generates the report template intermediate file according to the layout information of each data item.
14. A report generating apparatus, comprising:
the data item determining module is used for determining data items in the corresponding tables according to the table information of each table in the report template; the table information includes an identification code having a first mapping relation with a data item, the data item being stored in a specified database, and the data information of the data item being updated at fixed or non-fixed time intervals;
the report generation module replaces corresponding table information with the current data information of the data item to obtain a report;
the data item determination module includes:
An index information determining unit for determining corresponding data item index information according to the identification code in the table information;
and the current data information acquisition unit acquires the current data information of the appointed data item in the appointed database according to the data item index information.
15. The report generating device according to claim 14, wherein the table information further includes placeholders, the placeholders having a second mapping relation with a manner of processing the data item; the report generating device further comprises:
and the data item processing module is used for processing the replacement data in each table according to the placeholders to obtain the report.
16. The report generating apparatus as recited in claim 14, further comprising:
the report generation plan information acquisition module acquires report generation plan information; the report generation plan information comprises generation time points of at least one report; wherein, the liquid crystal display device comprises a liquid crystal display device,
the data item determination module performs the corresponding steps in response to the corresponding generation time points.
17. A computer device comprising a memory, a processor and a computer program stored on the memory and executable on the processor, characterized in that the processor implements the method of any of claims 1 to 7 when executing the program.
18. A computer readable storage medium, on which a computer program is stored, characterized in that the computer program, when being executed by a processor, implements the method of any of claims 1 to 7.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911358119.5A CN111158650B (en) | 2019-12-25 | 2019-12-25 | Report template and report generation method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911358119.5A CN111158650B (en) | 2019-12-25 | 2019-12-25 | Report template and report generation method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111158650A CN111158650A (en) | 2020-05-15 |
| CN111158650B true CN111158650B (en) | 2023-06-27 |
Family
ID=70558333
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911358119.5A Active CN111158650B (en) | 2019-12-25 | 2019-12-25 | Report template and report generation method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111158650B (en) |
Families Citing this family (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111708917A (en) * | 2020-06-10 | 2020-09-25 | 武汉钢铁有限公司 | Steel report data acquisition system |
| CN112000302B (en) * | 2020-08-25 | 2021-08-17 | 上海合阔信息技术有限公司 | Label generation method, template configuration method, device and storage medium |
| CN114064716B (en) * | 2021-10-29 | 2023-10-20 | 北京市农林科学院信息技术研究中心 | Metadata-based automatic WEB report generation method and device |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7761787B2 (en) * | 2002-12-02 | 2010-07-20 | Siemens Medical Solutions Usa, Inc. | Document generation system and user interface for producing a user desired document |
| WO2013101914A1 (en) * | 2011-12-29 | 2013-07-04 | Bibo Labs, Inc. | Spreadsheet-based programming language adapted for report generation |
| CN103646049A (en) * | 2013-11-26 | 2014-03-19 | 中国银行股份有限公司 | Method and system for automatically generating data report |
| CN103778234A (en) * | 2014-01-26 | 2014-05-07 | 北京恒华伟业科技股份有限公司 | Report form generating method and device |
| WO2014079304A1 (en) * | 2012-11-26 | 2014-05-30 | 中兴通讯股份有限公司 | Report creation method, device and system |
| CN108710708A (en) * | 2018-05-31 | 2018-10-26 | 泰康保险集团股份有限公司 | Report processing method, device, medium and electronic equipment |
| CN109471890A (en) * | 2018-10-16 | 2019-03-15 | 深圳壹账通智能科技有限公司 | Generation method, terminal device and the medium of report file |
| CN110175156A (en) * | 2019-04-10 | 2019-08-27 | 阿里巴巴集团控股有限公司 | The generation method and device of report |
Family Cites Families (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7203699B2 (en) * | 2004-06-28 | 2007-04-10 | Bellamy Robert E | Computerized system for automated completion of forms |
| CN102163188A (en) * | 2011-04-07 | 2011-08-24 | 北京数码大方科技有限公司 | Generation method and device thereof for EXCEL report in application system |
| US9104720B2 (en) * | 2012-06-28 | 2015-08-11 | International Business Machines Corporation | Generation of technical description of report from functional description of report |
| US9646004B2 (en) * | 2014-01-15 | 2017-05-09 | Software Ag | Hierarchical database report generation with automated query generation for placeholders |
| CN105138504A (en) * | 2015-09-07 | 2015-12-09 | 北京恒华伟业科技股份有限公司 | Report generation method and report engine |
| CN109325042B (en) * | 2018-08-14 | 2023-11-24 | 中国平安人寿保险股份有限公司 | Processing template acquisition method, form processing method, device, equipment and medium |
| CN110096683A (en) * | 2019-03-15 | 2019-08-06 | 中国平安人寿保险股份有限公司 | Report form generation method, system, computer installation and computer readable storage medium |
-
2019
- 2019-12-25 CN CN201911358119.5A patent/CN111158650B/en active Active
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7761787B2 (en) * | 2002-12-02 | 2010-07-20 | Siemens Medical Solutions Usa, Inc. | Document generation system and user interface for producing a user desired document |
| WO2013101914A1 (en) * | 2011-12-29 | 2013-07-04 | Bibo Labs, Inc. | Spreadsheet-based programming language adapted for report generation |
| WO2014079304A1 (en) * | 2012-11-26 | 2014-05-30 | 中兴通讯股份有限公司 | Report creation method, device and system |
| CN103646049A (en) * | 2013-11-26 | 2014-03-19 | 中国银行股份有限公司 | Method and system for automatically generating data report |
| CN103778234A (en) * | 2014-01-26 | 2014-05-07 | 北京恒华伟业科技股份有限公司 | Report form generating method and device |
| CN108710708A (en) * | 2018-05-31 | 2018-10-26 | 泰康保险集团股份有限公司 | Report processing method, device, medium and electronic equipment |
| CN109471890A (en) * | 2018-10-16 | 2019-03-15 | 深圳壹账通智能科技有限公司 | Generation method, terminal device and the medium of report file |
| CN110175156A (en) * | 2019-04-10 | 2019-08-27 | 阿里巴巴集团控股有限公司 | The generation method and device of report |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111158650A (en) | 2020-05-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111158650B (en) | Report template and report generation method and device | |
| CN107957831B (en) | Data processing method, device and processing equipment for displaying interface content | |
| CN110134668B (en) | Data migration method, device and equipment applied to blockchain | |
| CN107644286A (en) | Workflow processing method and device | |
| CN112395483B (en) | Page rendering method and device based on tree structure | |
| CN112015739A (en) | Data verification and data query method and device | |
| CN109214193B (en) | Data encryption and machine learning model training method and device and electronic equipment | |
| CN108255471B (en) | System configuration item configuration device, method and equipment based on configuration suite | |
| CN109086126B (en) | Task scheduling processing method and device, server, client and electronic equipment | |
| CN109241026A (en) | The method, apparatus and system of data management | |
| CN115840567A (en) | Application editing method and related equipment | |
| CN111008198B (en) | Service data acquisition method and device, storage medium and electronic equipment | |
| WO2017147013A1 (en) | Query response using mapping to parameterized report | |
| CN108415914B (en) | Method, device and equipment for inquiring information in visual object | |
| CN115311399A (en) | Image rendering method and device, electronic equipment and storage medium | |
| CN115390852A (en) | Method and device for generating uniform abstract syntax tree and program analysis | |
| CN111177609B (en) | Processing method and device for displaying three-dimensional data table in page and electronic equipment | |
| CN113360154A (en) | Page construction method, device, equipment and readable medium | |
| CN107645541B (en) | Data storage method and device and server | |
| CN111737784A (en) | Board card type selection configuration method and device based on digital three-dimensional ZXMP S385 subframe | |
| CN111209277A (en) | Data processing method, device, equipment and medium | |
| CN112579082A (en) | Interactive state data establishing method and device, storage medium and electronic equipment | |
| CN110502551A (en) | Data read-write method, system and infrastructure component | |
| CN110032565A (en) | A kind of method, system and electronic equipment generating statistical information | |
| CN111177562B (en) | Recommendation ordering processing method and device for target object and server |
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 | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20220913 Address after: 25 Financial Street, Xicheng District, Beijing 100033 Applicant after: CHINA CONSTRUCTION BANK Corp. Address before: 25 Financial Street, Xicheng District, Beijing 100033 Applicant before: CHINA CONSTRUCTION BANK Corp. Applicant before: Jianxin Financial Science and Technology Co.,Ltd. |
|
| TA01 | Transfer of patent application right | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |