CN113779941B - Configurable dynamic report generation device, system and method - Google Patents
Configurable dynamic report generation device, system and method Download PDFInfo
- Publication number
- CN113779941B CN113779941B CN202111052793.8A CN202111052793A CN113779941B CN 113779941 B CN113779941 B CN 113779941B CN 202111052793 A CN202111052793 A CN 202111052793A CN 113779941 B CN113779941 B CN 113779941B
- Authority
- CN
- China
- Prior art keywords
- report
- module
- data
- header
- 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.)
- Active
Links
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/174—Form filling; Merging
-
- 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
Abstract
The invention provides a configurable dynamic report generation device, a system and a method, comprising the following steps: the system comprises a report template storage module for storing report templates, a report data acquisition module for acquiring data parameters to be displayed, and a report template combination module for combining a plurality of report templates into a summary table; a report configuration module for carrying out parameter configuration on the combined report template; the report data display module is used for automatically filling the data acquired by the report data acquisition module into the table body of the report according to the header identification, generating a required report by combining the parameters configured by the report configuration module, and sending the report to the display screen for display; the invention adopts the combination report template to carry out data display by summarizing the basic report templates, reduces the complexity of parameter configuration, and generates the report standard which is considerable.
Description
Technical Field
The invention relates to the technical field of report generation, in particular to a configurable dynamic report generation device, a configurable dynamic report generation system and a configurable dynamic report generation method.
Background
At present, the report demand of enterprises is thousands, the traditional development mode needs to independently develop report logic and draw report interfaces for each report, the development period is long, the efficiency is low, and any modification needs to modify source codes and reissue the system.
The invention patent with the application number of CN202010607302.0 discloses a configuration report generating system and a method, wherein a report data configuration module is used for configuring report data, reading data from a database is realized by writing SQL sentences in the configuration process, and server data is read by configuring RESTful API paths; the report analysis module is used for analyzing the configured report data; the report drawing and displaying module is used for drawing the report according to the analysis result and a preset drawing mode, generating a report configuration total template, displaying the report configuration total template, and when the report needs to be added with a header, the report needs to be reconfigured again, so that the generation time is increased; meanwhile, when different reports are generated, the header and the table body parameters are required to be reconfigured, so that the operation is complex;
the invention patent with the application number of CN201410643482.2 discloses a method and a system for dynamically configuring and displaying a report, wherein a client side is used for configuring a report template, storing the configured report template into a background server, filling in query conditions on a selected report to generate a query request, analyzing and converting the query request into the query request meeting the query requirement of the background server, further sending the query request to the background server, and further carrying out engine calculation and format conversion on report data returned by the background server, displaying the processed report data, and configuring report parameters and increasing configuration time when different reports are manufactured, thereby increasing report generation time.
Disclosure of Invention
The invention aims to provide a configurable dynamic report generation device, a configurable dynamic report generation system and a configurable dynamic report generation method, which reduce the complexity of parameter configuration, and the generated report standard is considerable, and compared with the display form of a plurality of reports, the report is convenient to uniformly screen or process data.
The invention provides the following technical scheme:
a configurable dynamic report generation device, system and method, comprising:
the report template storage module: the method is used for storing a basic report template;
report data acquisition module: the system comprises a database, a display module and a display module, wherein the database is used for storing data parameters to be displayed;
report template combination module: selecting a plurality of report templates from the report template storage module according to a set summarizing logic algorithm according to the mapping relation between the data types and the header names of the report templates, and summarizing the report templates into a combined report template so that the header names of the combined report template cover the header names mapped by all the data types;
and a report configuration module: parameter configuration is carried out on the combined report template;
report data display module: the system comprises a report data acquisition module, a report configuration module, a display screen and a display screen, wherein the report data acquisition module is used for automatically filling data acquired by the report data acquisition module into a table body of a report according to the identification of a header, generating a required report by combining parameters configured by the report configuration module, and transmitting the report to the display screen for display.
Preferably, the parameter configuration of the report configuration module includes configuration codes, whether carousel is supported, carousel interval duration, display data source and automatic page turning interval duration.
Preferably, the report data display module further provides an operation interface for screening, modifying or processing data, updates data parameters at the operation interface, generates an updated report, and sends the updated report to the display screen for display.
Preferably, the report template combination module performs summarization on a plurality of report templates according to the header names.
Preferably, the system further comprises a data transmission module, wherein the data transmission module is used for sending the final report generated by the report data display module to a display screen for display.
A method for generating a configurable dynamic report adopts the generating system to generate the report, and the generating method comprises the following steps:
s1, acquiring data parameters to be displayed through a report data acquisition module, classifying the acquired data parameters into a plurality of data sets according to data types, and storing the data sets into a database;
s2, selecting a plurality of report templates in a report template storage module through a report template combination module according to a set summarizing logic algorithm according to the mapping relation between the data types and the header names of the report templates, and summarizing the report templates into a combined report template so that the header names of the combined report template cover the header names mapped by all the data types;
s3, parameter configuration is carried out on the combined report template through a report configuration module;
and S4, the report data display module automatically fills the data acquired by the report data acquisition module into a table body of a report according to the header identification, generates a required report by combining the parameters configured by the report configuration module, and sends the report to a display screen for display.
Preferably, the summary logic algorithm in step S2 includes the following steps:
a1, mapping the data name to be displayed into a mapping header name set of a report module, and selecting a report template from a report template database according to the required mapping header name set;
a2, arranging the report templates according to the degree of coincidence of the template header names of the report templates and the mapping header names, and selecting the report template with the highest degree of coincidence as a mother table;
a3, sequentially selecting the sub-tables according to the coincidence ratio, so that the header names of the templates of all the mother tables and the header names of the templates of the sub-tables are combined, the header name set obtained after the operation covers all the mapping header names, and the template header name sets of each template report form have no inclusion relation;
and A4, combining the header name sets of all the sub-tables to obtain header name sets of all the sub-tables, performing difference operation on the header name sets of all the sub-tables and the header name sets of the mother table to obtain an added header name set, and combining the header names in the added header name set into the mother table header to generate the final combined report template.
The configurable dynamic report generating device comprises a device host, wherein a touch screen, a memory and a processor are arranged in the device host, and the processor is used for realizing the method steps of the summarizing logic algorithm.
The beneficial effects of the invention are as follows:
1. the final display report generated by the invention is generated by combining initial basic report templates, so that the complexity of parameter configuration is reduced, the generated report standard is considerable, the format and unit are not required to be set, the complex drawing of the report page is not required, and the standardized management of the report is realized;
2. after standard configuration is set, a report is directly generated without changing configuration parameters, so that the efficiency is improved, the display is convenient, and the report development period is shortened;
3. all data are integrated on one report, and compared with the display form of a plurality of reports, the report is convenient to uniformly screen or process the data.
Drawings
The accompanying drawings are included to provide a further understanding of the invention and are incorporated in and constitute a part of this specification, illustrate the invention and together with the embodiments of the invention, serve to explain the invention. In the drawings:
fig. 1 is a schematic block diagram of the system of the present invention.
Detailed Description
Embodiment one:
a configurable dynamic report generation system, comprising:
the report template storage module: the method is used for storing a basic report template;
report data acquisition module: the system comprises a database, a display module and a display module, wherein the database is used for storing data parameters to be displayed;
report template combination module: selecting a plurality of report templates in a report template storage module according to a set summarizing logic algorithm according to the mapping relation between the data types and the header names of the report templates, and summarizing the report templates into a combined report template so that the header names of the combined report template cover the header names of all data types;
and a report configuration module: parameter configuration is carried out on the combined report template;
report data display module: the system comprises a report data acquisition module, a report configuration module, a display screen and a display screen, wherein the report data acquisition module is used for automatically filling data acquired by the report data acquisition module into a table body of a report according to the identification of a table header, generating a required report by combining parameters configured by the report configuration module, and transmitting the report to the display screen for display.
A method for generating a configurable dynamic report adopts the generating system to generate the report, and the generating method comprises the following steps:
s1, acquiring data parameters to be displayed through a report data acquisition module, classifying the acquired data parameters into a plurality of data sets according to data types, and storing the data sets into a database;
s2, selecting a plurality of report templates in a report template storage module through a report template combination module according to a set summarization logic algorithm according to a mapping relation between the data types and the header names of the report templates, and summarizing the report templates into a combined report template so that the header names of the combined report template cover the header names mapped by all the data types;
s3, parameter configuration is carried out on the combined report template through a report configuration module;
and S4, the report data display module automatically fills the data acquired by the report data acquisition module into a table body of the report according to the header identification, generates a required report by combining the parameters configured by the report configuration module, and sends the report to the display screen for display.
Example two
A configurable dynamic report generation system, comprising:
the report template storage module: the method is used for storing a basic report template;
report data acquisition module: the system comprises a database, a display module and a display module, wherein the database is used for storing data parameters to be displayed;
report template combination module: selecting a plurality of report templates in a report template storage module according to a set summarizing logic algorithm according to the mapping relation between the data types and the header names of the report templates, and summarizing the report templates into a combined report template (the report template combination module summarizes a plurality of report templates according to the header names), so that the header names of the combined report templates cover the header names mapped by all the data types;
and a report configuration module: parameter configuration is carried out on the combined report template, wherein the parameter configuration of the report configuration module comprises configuration codes, whether carousel is supported, carousel interval duration, display data sources and automatic page turning interval duration; after standard configuration is set, a report is often directly generated without changing configuration parameters, so that the efficiency is improved, the display is convenient, and the report development period is shortened;
report data display module: the system comprises a report data acquisition module, a report configuration module, a display screen and a display screen, wherein the report data acquisition module is used for automatically filling data acquired by the report data acquisition module into a table body of a report according to the identification of a table header, generating a required report by combining parameters configured by the report configuration module, and transmitting the report to the display screen for display; and an operation interface for screening, modifying or processing the data is further provided, the data parameters are updated in the operation interface, an updated report is generated, and the updated report is sent to a display screen for display.
The system also comprises a data transmission module which is used for sending the final report generated by the report data display module to a display screen for display.
The method of generating a report by the generating system of the present embodiment is the same as the generating method in the first embodiment.
Example III
In contrast to the first embodiment, the summary logic algorithm of step S2 of the present embodiment includes the following steps:
a1, mapping the data name to be displayed into a mapping header name set of a report module, and selecting a report template from a report template database according to the required mapping header name set;
a2, arranging the report templates according to the degree of coincidence of the template header names of the report templates and the mapping header names, and selecting the report template with the highest degree of coincidence as a mother table;
a3, sequentially selecting the sub-tables according to the coincidence ratio, so that the header names of the templates of all the mother tables and the header names of the templates of the sub-tables are combined, the header name set obtained after the operation covers all the mapping header names, and the template header name sets of each template report form have no inclusion relation;
and A4, combining the header name sets of all the sub-tables to obtain header name sets of all the sub-tables, performing difference operation on the header name sets of all the sub-tables and the header name sets of the mother table to obtain an added header name set, and combining the header names in the added header name set into the mother table header to generate the final combined report template.
The configurable dynamic report generating device comprises a device host, wherein a touch screen, a memory and a processor are arranged in the device host, and the processor is used for realizing the method steps of the summary logic algorithm.
The final display report generated by the invention is generated by combining initial basic report templates, so that the complexity of parameter configuration is reduced, the generated report standard is considerable, the format and unit are not required to be set, the complex drawing of the report page is not required, and the standardized management of the report is realized;
after standard configuration is set, a report is directly generated without changing configuration parameters, so that the efficiency is improved, the display is convenient, and the report development period is shortened;
all data are integrated on one report, and compared with the display form of a plurality of reports, the report is convenient to uniformly screen or process the data.
The foregoing description is only a preferred embodiment of the present invention, and the present invention is not limited thereto, but it is to be understood that modifications and equivalents of some of the technical features described in the foregoing embodiments may be made by those skilled in the art, although the present invention has been described in detail with reference to the foregoing embodiments. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present invention should be included in the protection scope of the present invention.
Claims (7)
1. A configurable dynamic report generation system, comprising:
the report template storage module: the method is used for storing a basic report template;
report data acquisition module: the system comprises a database, a display module and a display module, wherein the database is used for storing data parameters to be displayed;
report template combination module: selecting a plurality of report templates from the report template storage module according to a set summarizing logic algorithm according to the mapping relation between the data types and the header names of the report templates, and summarizing the report templates into a combined report template so that the header names of the combined report template cover the header names mapped by all the data types;
and a report configuration module: parameter configuration is carried out on the combined report template;
report data display module: the system comprises a report data acquisition module, a report configuration module, a display screen and a display screen, wherein the report data acquisition module is used for automatically filling data acquired by the report data acquisition module into a table body of a report according to the identification of a header, generating a required report by combining parameters configured by the report configuration module, and transmitting the report to the display screen for display;
the summary logic algorithm comprises the following steps:
a1, mapping the data name to be displayed into a mapping header name set of a report module, and selecting a report template from a report template database according to the required mapping header name set;
a2, arranging the report templates according to the descending order of the overlap ratio of the template header names of the report templates and the mapping header names, and selecting the report template with the highest overlap ratio as a mother table;
a3, sequentially selecting the sub-tables according to the coincidence ratio, so that the header names of the templates of all the mother tables and the header names of the templates of the sub-tables are combined, the header name set obtained after the operation covers all the mapping header names, and the template header name sets of each template report form have no inclusion relation;
and A4, combining the header name sets of all the sub-tables to obtain header name sets of all the sub-tables, performing difference operation on the header name sets of all the sub-tables and the header name sets of the mother table to obtain an added header name set, and combining the header names in the added header name set into the mother table header to generate the final combined report template.
2. The system of claim 1, wherein the parameter configuration of the report configuration module includes configuration code, whether carousel is supported, carousel interval duration, presentation data source, and auto-page-turning interval duration.
3. The system of claim 1, wherein the report data display module further provides an operation interface for screening, modifying or processing data, updates data parameters at the operation interface, generates an updated report, and sends the updated report to the display screen for display.
4. The system of claim 1, wherein the reporting model combining module aggregates the plurality of reporting templates according to header names.
5. The system for generating a configurable dynamic report according to claim 1, further comprising a data transmission module, wherein the data transmission module is configured to send the final report generated by the report data display module to a display screen for display.
6. A method for generating a configurable dynamic report, wherein a report is generated using a generating system according to any one of claims 1-5, the generating method comprising the steps of:
s1, acquiring data parameters to be displayed through a report data acquisition module, classifying the acquired data parameters into a plurality of data sets according to data types, and storing the data sets into a database;
s2, selecting a plurality of report templates in a report template storage module through a report template combination module according to a set summarizing logic algorithm according to the mapping relation between the data types and the header names of the report templates, and summarizing the report templates into a combined report template so that the header names of the combined report template cover the header names mapped by all the data types;
s3, parameter configuration is carried out on the combined report template through a report configuration module;
and S4, the report data display module automatically fills the data acquired by the report data acquisition module into a table body of a report according to the header identification, generates a required report by combining the parameters configured by the report configuration module, and sends the report to a display screen for display.
7. A configurable dynamic report generating device, comprising a device host, wherein the device host has a touch screen, a memory, and a processor, and the processor is configured to implement the steps of the method according to claim 6.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111052793.8A CN113779941B (en) | 2021-09-08 | 2021-09-08 | Configurable dynamic report generation device, system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202111052793.8A CN113779941B (en) | 2021-09-08 | 2021-09-08 | Configurable dynamic report generation device, system and method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN113779941A CN113779941A (en) | 2021-12-10 |
| CN113779941B true CN113779941B (en) | 2023-07-25 |
Family
ID=78842077
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202111052793.8A Active CN113779941B (en) | 2021-09-08 | 2021-09-08 | Configurable dynamic report generation device, system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN113779941B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN114417802B (en) * | 2022-03-22 | 2022-06-10 | 创意信息技术股份有限公司 | Intelligent report generation system |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104376068A (en) * | 2014-11-07 | 2015-02-25 | 北京思特奇信息技术股份有限公司 | Data representation system and method based on dynamic report template |
| CN107562949A (en) * | 2017-09-20 | 2018-01-09 | 深圳易嘉恩科技有限公司 | The method for realizing consolidated accounts Excel template write into Databasce |
| CN108959227A (en) * | 2018-07-12 | 2018-12-07 | 山东汇贸电子口岸有限公司 | A kind of self-defined report system and method based on B/S framework |
| CN110222321A (en) * | 2019-04-16 | 2019-09-10 | 中国平安人寿保险股份有限公司 | Report form generation method, device, computer installation and computer readable storage medium |
| CN111752999A (en) * | 2020-06-30 | 2020-10-09 | 潘传迪 | Configured report generation system and method |
| CN112487771A (en) * | 2020-12-14 | 2021-03-12 | 国网河北省电力有限公司 | Report generation method, report generation device and terminal |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7188100B2 (en) * | 2000-02-25 | 2007-03-06 | Joseph De Bellis | Search-on-the-fly report generator |
-
2021
- 2021-09-08 CN CN202111052793.8A patent/CN113779941B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104376068A (en) * | 2014-11-07 | 2015-02-25 | 北京思特奇信息技术股份有限公司 | Data representation system and method based on dynamic report template |
| CN107562949A (en) * | 2017-09-20 | 2018-01-09 | 深圳易嘉恩科技有限公司 | The method for realizing consolidated accounts Excel template write into Databasce |
| CN108959227A (en) * | 2018-07-12 | 2018-12-07 | 山东汇贸电子口岸有限公司 | A kind of self-defined report system and method based on B/S framework |
| CN110222321A (en) * | 2019-04-16 | 2019-09-10 | 中国平安人寿保险股份有限公司 | Report form generation method, device, computer installation and computer readable storage medium |
| CN111752999A (en) * | 2020-06-30 | 2020-10-09 | 潘传迪 | Configured report generation system and method |
| CN112487771A (en) * | 2020-12-14 | 2021-03-12 | 国网河北省电力有限公司 | Report generation method, report generation device and terminal |
Non-Patent Citations (2)
| Title |
|---|
| 单元格式动态报表的实现原理探究;贺华涛;仇少敏;;城建档案(04);73-75 * |
| 基于B/S架构的动态报表设计及实现;李辉;陈玉石;;科学家(第09期);42-43 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN113779941A (en) | 2021-12-10 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN108519967B (en) | Chart visualization method and device, terminal and storage medium | |
| CN101739390B (en) | Data transformation based on a technical design document | |
| CN106547729B (en) | A kind of dynamic creation method and system of data sheet | |
| CN111259643B (en) | Method and equipment for generating graphic report | |
| CN110503408B (en) | Business process management system based on custom configuration | |
| CN105224613A (en) | Based on integrating heterogeneous data source system and the integration method thereof of the federal technology of data | |
| CN111078702A (en) | SQL sentence classification management and unified query method and device | |
| CN109684616A (en) | Dynamic statement formula assembles the method and system made a report on | |
| CN113779941B (en) | Configurable dynamic report generation device, system and method | |
| CN113641700A (en) | Data processing method and device based on Spring boot frame | |
| CN105589840A (en) | Universal EXCEL/PDF report form exporting assembly | |
| CN110909017B (en) | Data analysis method and system | |
| CN109271448A (en) | It is the data synchronous system and method for platform based on database | |
| CN112735571A (en) | Medical health data uploading management platform | |
| CN103793519A (en) | Automatic tool supporting exportation of mass data | |
| CN116009793A (en) | Printing method | |
| CN111177234A (en) | Device and method for rapidly processing document type data file | |
| CN112445811A (en) | Data service method, device, storage medium and component based on SQL configuration | |
| CN108829968A (en) | Circuit diagram checking method based on Python spread function | |
| CN110275702B (en) | Presentation layer data formatting system of Java Web project | |
| CN113435944A (en) | Marketing effect post-evaluation system | |
| CN113380351A (en) | Method and system for realizing health medical data sharing and opening based on FHIR | |
| CN114036158A (en) | Elasticissearch and MySQL combined query method and device | |
| CN113641735A (en) | Visual display method of federal cluster data, electronic equipment and storage medium | |
| CN112905558A (en) | Report system implementation method and system based on database configuration |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |