CN110489462B - Method and system for automatically generating data report - Google Patents

Method and system for automatically generating data report Download PDF

Info

Publication number
CN110489462B
CN110489462B CN201910783358.9A CN201910783358A CN110489462B CN 110489462 B CN110489462 B CN 110489462B CN 201910783358 A CN201910783358 A CN 201910783358A CN 110489462 B CN110489462 B CN 110489462B
Authority
CN
China
Prior art keywords
data
report
generating
logic
data report
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
Application number
CN201910783358.9A
Other languages
Chinese (zh)
Other versions
CN110489462A (en
Inventor
熊坤伟
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Xingyin Information Technology Shanghai Co ltd
Original Assignee
Xingyin Information Technology Shanghai Co ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Xingyin Information Technology Shanghai Co ltd filed Critical Xingyin Information Technology Shanghai Co ltd
Priority to CN201910783358.9A priority Critical patent/CN110489462B/en
Publication of CN110489462A publication Critical patent/CN110489462A/en
Application granted granted Critical
Publication of CN110489462B publication Critical patent/CN110489462B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/245Query processing
    • G06F16/2458Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
    • G06F16/2462Approximate or statistical queries

Landscapes

  • Engineering & Computer Science (AREA)
  • Physics & Mathematics (AREA)
  • Probability & Statistics with Applications (AREA)
  • Theoretical Computer Science (AREA)
  • Computational Linguistics (AREA)
  • Software Systems (AREA)
  • Mathematical Physics (AREA)
  • Data Mining & Analysis (AREA)
  • Databases & Information Systems (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Fuzzy Systems (AREA)
  • Information Transfer Between Computers (AREA)

Abstract

The application discloses a method and a system for automatically generating a data report, wherein the method comprises the following steps: the method includes determining a data source for generating a data report, configuring data statistics logic, defining a report template for generating the data report, and generating the data report based on the data source, the statistics logic, and the report template. According to the method and the device, the data report can be generated more flexibly and simply, and the user experience is improved.

Description

Method and system for automatically generating data report
Technical Field
The present application relates to the field of data processing technologies, and in particular, to a method and a system for automatically generating a data report.
Background
Currently, enterprise-level application systems generally need to count various data and report the data to related leaders, business principals, or related technicians to feedback business operation conditions or provide decision references. The statistics are time-consuming and labor-consuming, even if a related BI (Business Intelligence) system is used, manual timing intervention and arrangement are still needed, and the BI system mainly serves decision making at a company level, and data statistics reports of a single system or a certain Business module are difficult to arrange in a demand queue.
Therefore, how to generate a data report more flexibly is a problem to be solved urgently.
Disclosure of Invention
In view of this, the present application provides a method for automatically generating a data report, which can automatically generate a data report more flexibly and simply, and improve user experience.
The application provides a method for automatically generating a data report, the method comprising:
determining a data source for generating a data report;
configuring data statistical logic;
defining a report template for generating a data report;
generating a data report based on the data source, statistical logic, and the report template.
Preferably, the method further comprises:
and sending the data report based on a preset time.
Preferably, the determining a data source for generating a data report comprises:
a data source configuration table is defined for generating data reports.
Preferably, the configuration data statistics logic comprises:
the logic of data statistics is configured in the manner of structured query language statements.
Preferably, the defining a report template for generating a data report comprises:
and editing the report template through a text editing plug-in.
A system for automatically generating data reports, comprising:
a determination module to determine a data source for generating a data report;
the configuration module is used for configuring data statistical logic;
a definition module for defining a report template for generating a data report;
a generation module to generate a data report based on the data source, the statistical logic, and the report template.
Preferably, the system further comprises:
and the sending module is used for sending the data report based on preset time.
Preferably, the determining module is specifically configured to:
a data source configuration table is defined for generating data reports.
Preferably, the configuration module is specifically configured to:
the logic of data statistics is configured in the manner of structured query language statements.
Preferably, the definition module is specifically configured to:
and editing the report template through a text editing plug-in.
In summary, the present application discloses a method for automatically generating a data report, when the data report needs to be automatically generated, first determining a data source for generating the data report, then configuring data statistics logic, defining a report template for generating the data report, and finally generating the data report based on the data source, the statistics logic, and the report template. According to the method and the device, the data report can be generated more flexibly and simply, and the user experience is improved.
Drawings
In order to more clearly illustrate the embodiments of the present application or the technical solutions in the prior art, the drawings used in the description of the embodiments or the prior art will be briefly described below, it is obvious that the drawings in the following description are only some embodiments of the present application, and for those skilled in the art, other drawings can be obtained according to the drawings without creative efforts.
FIG. 1 is a flow chart of an embodiment 1 of a method for automatically generating data reports as disclosed herein;
FIG. 2 is a flow chart of embodiment 2 of a method for automatically generating data reports as disclosed herein;
FIG. 3 is a flow chart of embodiment 3 of a method for automatically generating data reports as disclosed herein;
FIG. 4 is a flow chart of embodiment 4 of a method for automatically generating data reports as disclosed herein;
FIG. 5 is a flow chart of embodiment 5 of a method for automatically generating data reports as disclosed herein;
FIG. 6 is a schematic diagram of an embodiment 1 of a system for automatically generating data reports according to the present disclosure;
FIG. 7 is a schematic diagram of an embodiment 2 of a system for automatically generating data reports according to the present disclosure;
FIG. 8 is a block diagram of an embodiment 3 of a system for automatically generating data reports according to the present disclosure;
FIG. 9 is a schematic diagram of an embodiment 4 of a system for automatically generating data reports according to the present disclosure;
fig. 10 is a schematic structural diagram of an embodiment 5 of a system for automatically generating a data report according to the present disclosure.
Detailed Description
The technical solutions in the embodiments of the present application will be clearly and completely described below with reference to the drawings in the embodiments of the present application, and it is obvious that the described embodiments are only a part of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
As shown in fig. 1, which is a flowchart of embodiment 1 of a method for automatically generating a data report disclosed in the present application, the method may include the following steps:
s101, determining a data source for generating a data report;
when a data report needs to be automatically generated, a data source, i.e., raw data used to generate the data report, is first specified.
S102, configuring data statistical logic;
at the same time, data statistics logic for generating data reports is configured.
S103, defining a report template for generating a data report;
at the same time, the user may define templates for various reports.
And S104, generating a data report based on the data source, the statistical logic and the report template.
And finally, generating a final data report according to the determined data source, the statistical logic of the data and a template of the report to be generated.
In summary, in the above embodiments, when it is necessary to automatically generate a data report, a data source for generating the data report is first determined, then data statistics logic is configured, a report template for generating the data report is defined, and finally, the data report is generated based on the data source, the statistics logic, and the report template. According to the method and the device, the data report can be generated more flexibly and simply, and the user experience is improved.
As shown in fig. 2, which is a flowchart of embodiment 2 of the method for automatically generating a data report disclosed in the present application, the method may include the following steps:
s201, determining a data source for generating a data report;
when a data report needs to be automatically generated, a data source, namely, original data used for generating the data report, is first specified.
S202, configuring data statistical logic;
at the same time, data statistics logic for generating data reports is configured.
S203, defining a report template for generating a data report;
at the same time, the user may define templates for various reports.
S204, generating a data report based on the data source, the statistical logic and the report template;
and generating a final data report according to the determined data source, the statistical logic of the data and a template of the report to be generated.
And S205, sending a data report based on preset time.
After the final data report is generated, the data report can be further pushed according to the preset time. When the pushing time of the data report is preset, java's timing task technology, email technology, short message technology, etc. can be used to complete the automatic pushing of the data report.
In summary, in the above embodiments, when it is required to automatically generate a data report, a data source for generating the data report is first determined, then a data statistics logic is configured, a report template for generating the data report is defined, the data report is generated according to the data source, the statistics logic, and the report template, and the data report is further sent according to a preset time. According to the method and the device, the data report can be generated more flexibly and simply, and the user experience is improved.
As shown in fig. 3, which is a flowchart of embodiment 3 of the method for automatically generating a data report disclosed in the present application, the method may include the following steps:
s301, defining a data source configuration table for generating a data report;
when a data report needs to be automatically generated, a data source, i.e., raw data used to generate the data report, is first specified. In determining the data source for generating the data report, this may be accomplished by defining a data source configuration table.
S302, configuring data statistical logic;
at the same time, data statistics logic for generating data reports is configured.
S303, defining a report template for generating a data report;
at the same time, the user may define templates for various reports.
S304, generating a data report based on the data source, the statistical logic and the report template;
and generating a final data report according to the determined data source, the statistical logic of the data and a template of the report to be generated.
And S305, sending a data report based on preset time.
After the final data report is generated, the data report can be further pushed according to the preset time. When the pushing time of the data report is preset, java's timing task technology, email technology, short message technology, etc. can be used to complete the automatic pushing of the data report.
In summary, in the above embodiments, when it is necessary to automatically generate a data report, a data source configuration table for generating the data report is first defined, then a data statistics logic is configured, a report template for generating the data report is defined, the data report is generated according to the data source, the statistics logic, and the report template, and the data report is further sent according to a preset time. According to the method and the device, the data report can be generated more flexibly and simply, and the user experience is improved.
As shown in fig. 4, which is a flowchart of embodiment 4 of the method for automatically generating a data report disclosed in the present application, the method may include the following steps:
s401, defining a data source configuration table for generating a data report;
when a data report needs to be automatically generated, a data source, i.e., raw data used to generate the data report, is first specified. In determining the data source for generating the data report, this may be accomplished by defining a data source configuration table.
S402, configuring the logic of data statistics in a structured query language statement mode;
at the same time, data statistics logic for generating data reports is configured. A data reporting task may be completed by multiple data statistics structured query languages, the data statistics structured query languages are filled in by a user through an interface, and after the data statistics structured query languages are checked, the system automatically identifies data fields contained in the structured query languages. The user can configure corresponding display names for the fields, and only the display names appear in the generated report. The statistics set for each data statistics structured query language requires taking a name, such as dataResultOne, which will be used in the data report template. In addition, each data statistics structured query language needs to specify a specific data source.
For data reporting task configuration, a data reporting task is composed of attributes such as "report subject", "report object", "report template", "timing expression", and the like. The core logic of the data statistics is that program entry parameters are data report topics, a program acquires all data statistics structured query languages under the topics through the data report topics, executes the data statistics structured query languages one by one to generate related data sets, and places the data sets in the context of data reports; and generating a data reporting template from the data set according to a specified format by adopting a dynamic template technology, and pushing a data result to a reporting object by using an email technology and a short message technology.
S403, defining a report template for generating a data report;
at the same time, the user may define templates for various reports.
S404, generating a data report based on the data source, the statistical logic and the report template;
and generating a final data report according to the determined data source, the statistical logic of the data and a template of the report to be generated.
And S405, sending a data report based on preset time.
After the final data report is generated, the data report can be further pushed according to the preset time. When the pushing time of the data report is preset, java's timing task technology, email technology, short message technology, etc. can be used to complete the automatic pushing of the data report.
In summary, in the above embodiments, when a data report needs to be automatically generated, a data source configuration table for generating the data report is first defined, then the logic of data statistics is configured in a structured query language statement manner, a report template for generating the data report is defined, the data report is generated according to the data source, the statistics logic, and the report template, and the data report is further sent according to a preset time. According to the method and the device, the data report can be generated more flexibly and simply, and the user experience is improved.
As shown in fig. 5, which is a flowchart of embodiment 5 of the method for automatically generating a data report disclosed in the present application, the method may include the following steps:
s501, defining a data source configuration table for generating a data report;
when a data report needs to be automatically generated, a data source, i.e., raw data used to generate the data report, is first specified. In determining the data source for generating the data report, this may be accomplished by defining a data source configuration table.
S502, configuring the logic of data statistics in a structured query language statement mode;
at the same time, data statistics logic for generating data reports is configured. A data reporting task may be completed by multiple data statistics structured query languages, the data statistics structured query languages are filled in by a user through an interface, and after the data statistics structured query languages are checked, the system automatically identifies data fields contained in the structured query languages. The user can configure corresponding display names for the fields, and only the display names appear in the generated report. The statistics set for each data statistics structured query language requires taking a name, such as dataResultOne, which will be used in the data report template. In addition, each data statistics structured query language requires the specification of a particular data source.
For data reporting task configuration, a data reporting task is composed of attributes such as "report subject", "report object", "report template", "timing expression", and the like. The core logic of the data statistics is that program entry parameters are data report topics, a program acquires all data statistics structured query languages under the topics through the data report topics, executes the data statistics structured query languages one by one to generate related data sets, and places the data sets in the context of data reports; and generating a data reporting template from the data set according to a specified format by adopting a dynamic template technology, and pushing a data result to a reporting object by using an email technology and a short message technology.
S503, editing a report template through a text editing plug-in device;
at the same time, the user may define templates for various reports. The data report template can be edited by a text editing plug-in unit to generate an html script and store the html script in a database. Dynamic data is represented in the template by scripts like $ { dataresultone.count }, $ { dataresultone.data1.columna }.
S504, generating a data report based on the data source, the statistical logic and the report template;
and generating a final data report according to the determined data source, the statistical logic of the data and a template of the report to be generated.
And S505, sending a data report based on preset time.
After the final data report is generated, the data report can be further pushed according to the preset time. When the pushing time of the data report is preset, java's timing task technology, email technology, short message technology, etc. can be used to complete the automatic pushing of the data report.
In summary, in the above embodiments, when a data report needs to be automatically generated, a data source configuration table for generating the data report is defined first, then the logic of data statistics is configured in a structured query language statement manner, the report template is edited by a text editing plug-in, a data report is generated according to the data source, the statistics logic, and the report template, and the data report is further sent according to a preset time. According to the method and the device, the data report can be generated more flexibly and simply, and the user experience is improved.
As shown in fig. 6, which is a schematic structural diagram of embodiment 1 of a system for automatically generating a data report disclosed in the present application, the system may include:
a determining module 601, configured to determine a data source for generating a data report;
when a data report needs to be automatically generated, a data source, i.e., raw data used to generate the data report, is first specified.
A configuration module 602 for configuring data statistics logic;
at the same time, data statistics logic for generating data reports is configured.
A definition module 603 for defining a report template for generating a data report;
at the same time, the user may define templates for various reports.
A generation module 604 for generating data reports based on the data sources, statistical logic, and report templates.
And finally, generating a final data report according to the determined data source, the statistical logic of the data and a template of the report to be generated.
In summary, in the above embodiments, when a data report needs to be automatically generated, a data source for generating the data report is first determined, then data statistics logic is configured, a report template for generating the data report is defined, and finally, the data report is generated based on the data source, the statistics logic, and the report template. According to the method and the device, the data report can be generated more flexibly and simply, and the user experience is improved.
As shown in fig. 7, a schematic structural diagram of embodiment 2 of a system for automatically generating a data report disclosed in the present application may include:
a determining module 701, configured to determine a data source for generating a data report;
when a data report needs to be automatically generated, a data source, i.e., raw data used to generate the data report, is first specified.
A configuration module 702 for configuring data statistics logic;
at the same time, data statistics logic for generating data reports is configured.
A definition module 703 for defining a report template for generating a data report;
at the same time, the user may define templates for various reports.
A generation module 704 for generating a data report based on the data source, the statistical logic, and the report template;
and generating a final data report according to the determined data source, the statistical logic of the data and a template of the report to be generated.
A sending module 705, configured to send a data report based on a preset time.
After the final data report is generated, the data report can be further pushed according to the preset time. When the pushing time of the data report is preset, the automatic pushing of the data report can be completed by using a java's timed task technology, an email technology, a short message technology and the like.
In summary, in the above embodiments, when it is required to automatically generate a data report, a data source for generating the data report is first determined, then a data statistics logic is configured, a report template for generating the data report is defined, the data report is generated according to the data source, the statistics logic, and the report template, and the data report is further sent according to a preset time. According to the method and the device, the data report can be generated more flexibly and simply, and the user experience is improved.
As shown in fig. 8, a schematic structural diagram of embodiment 3 of a system for automatically generating a data report disclosed in the present application may include:
a determining module 801 for defining a data source configuration table for generating a data report;
when a data report needs to be automatically generated, a data source, namely, original data used for generating the data report, is first specified. In determining the data source for generating the data report, this may be accomplished by defining a data source configuration table.
A configuration module 802 for configuring data statistics logic;
at the same time, data statistics logic for generating data reports is configured.
A definition module 803, for defining a report template for generating a data report;
at the same time, the user may define templates for various reports.
A generation module 804 for generating a data report based on the data source, the statistical logic, and the report template;
and generating a final data report according to the determined data source, the statistical logic of the data and a template of the report to be generated.
A sending module 805, configured to send a data report based on a preset time.
After the final data report is generated, the data report can be further pushed according to the preset time. When the pushing time of the data report is preset, java's timing task technology, email technology, short message technology, etc. can be used to complete the automatic pushing of the data report.
In summary, in the above embodiments, when it is necessary to automatically generate a data report, a data source configuration table for generating the data report is first defined, then a data statistics logic is configured, a report template for generating the data report is defined, the data report is generated according to the data source, the statistics logic, and the report template, and the data report is further sent according to a preset time. According to the method and the device, the data report can be generated more flexibly and simply, and the user experience is improved.
As shown in fig. 9, a schematic structural diagram of embodiment 4 of a system for automatically generating a data report disclosed in the present application may include:
a determining module 901, configured to define a data source configuration table for generating a data report;
when a data report needs to be automatically generated, a data source, i.e., raw data used to generate the data report, is first specified. In determining the data source for generating the data report, this may be accomplished by defining a data source configuration table.
A configuration module 902, configured to configure the logic of data statistics in a structured query language statement;
at the same time, data statistics logic for generating data reports is configured. A data reporting task may be completed by multiple data statistics structured query languages, the data statistics structured query languages are filled in by a user through an interface, and after the data statistics structured query languages are checked, the system automatically identifies data fields contained in the structured query languages. The user can configure corresponding display names for the fields, and only the display names appear in the generated report. The statistics set for each data statistics structured query language requires a name, such as dataResultOne, to be used in the data report template. In addition, each data statistics structured query language requires the specification of a particular data source.
For data reporting task configuration, a data reporting task is composed of attributes such as "report subject", "report object", "report template", "timing expression", and the like. The core logic of the data statistics is that program entry parameters are data report topics, a program acquires all data statistics structured query languages under the topics through the data report topics, executes the data statistics structured query languages one by one to generate related data sets, and places the data sets in the context of data reports; and generating a data reporting template from the data set according to a specified format by adopting a dynamic template technology, and pushing a data result to a reporting object by using an email technology and a short message technology.
A definition module 903 for defining a report template for generating a data report;
at the same time, the user may define templates for various reports.
A generation module 904 for generating a data report based on the data source, the statistical logic, and the report template;
and generating a final data report according to the determined data source, the statistical logic of the data and a template of the report to be generated.
A sending module 905, configured to send a data report based on a preset time.
After the final data report is generated, the data report can be further pushed according to the preset time. When the pushing time of the data report is preset, java's timing task technology, email technology, short message technology, etc. can be used to complete the automatic pushing of the data report.
In summary, in the above embodiments, when a data report needs to be automatically generated, a data source configuration table for generating the data report is first defined, then the logic of data statistics is configured in a structured query language statement manner, a report template for generating the data report is defined, the data report is generated according to the data source, the statistics logic, and the report template, and the data report is further sent according to a preset time. According to the method and the device, the data report can be generated more flexibly and simply, and the user experience is improved.
As shown in fig. 10, a schematic structural diagram of embodiment 5 of a system for automatically generating a data report disclosed in the present application may include:
a determining module 1001 for defining a data source configuration table for generating a data report;
when a data report needs to be automatically generated, a data source, i.e., raw data used to generate the data report, is first specified. In determining the data source for generating the data report, this may be accomplished by defining a data source configuration table.
A configuration module 1002, configured to configure the logic of data statistics in a structured query language statement;
at the same time, data statistics logic for generating data reports is configured. A data reporting task may be completed by multiple data statistics structured query languages, the data statistics structured query languages are filled in by a user through an interface, and after the data statistics structured query languages are checked, the system automatically identifies data fields contained in the structured query languages. The user can configure corresponding display names for the fields, and only the display names appear in the generated report. The statistics set for each data statistics structured query language requires taking a name, such as dataResultOne, which will be used in the data report template. In addition, each data statistics structured query language needs to specify a specific data source.
For data reporting task configuration, a data reporting task is composed of attributes such as "report subject", "report object", "report template", "timing expression", and the like. The core logic of the data statistics is that program entry parameters are data report topics, a program acquires all data statistics structured query languages under the topics through the data report topics, executes the data statistics structured query languages one by one to generate related data sets, and places the data sets in the context of data reports; and generating a data reporting template from the data set according to a specified format by adopting a dynamic template technology, and pushing a data result to a reporting object by using an email technology and a short message technology.
A definition module 1003, configured to edit the report template through a text editing plug-in;
at the same time, the user may define templates for various reports. The data report template can be edited by a text editing plug-in unit to generate an html script and store the html script in a database. Dynamic data is represented in the template by scripts like $ { dataresultone.count }, $ { dataresultone.data1.columna }.
A generation module 1004 for generating a data report based on the data source, the statistical logic, and the report template;
and generating a final data report according to the determined data source, the statistical logic of the data and a template of the report to be generated.
A sending module 1005, configured to send the data report based on a preset time.
After the final data report is generated, the data report can be further pushed according to the preset time. When the pushing time of the data report is preset, java's timing task technology, email technology, short message technology, etc. can be used to complete the automatic pushing of the data report.
In summary, in the above embodiments, when a data report needs to be automatically generated, a data source configuration table for generating the data report is defined first, then the logic of data statistics is configured in a structured query language statement manner, the report template is edited by a text editing plug-in, a data report is generated according to the data source, the statistics logic, and the report template, and the data report is further sent according to a preset time. According to the method and the device, the data report can be generated more flexibly and simply, and the user experience is improved.
The embodiments in the present description are described in a progressive manner, each embodiment focuses on differences from other embodiments, and the same and similar parts among the embodiments are referred to each other. The device disclosed by the embodiment corresponds to the method disclosed by the embodiment, so that the description is simple, and the relevant points can be referred to the method part for description.
Those of skill would further appreciate that the various illustrative elements and algorithm steps described in connection with the embodiments disclosed herein may be implemented as electronic hardware, computer software, or combinations of both, and that the various illustrative components and steps have been described above generally in terms of their functionality in order to clearly illustrate this interchangeability of hardware and software. Whether such functionality is implemented as hardware or software depends upon the particular application and design constraints imposed on the implementation. Skilled artisans may implement the described functionality in varying ways for each particular application, but such implementation decisions should not be interpreted as causing a departure from the scope of the present application.
The steps of a method or algorithm described in connection with the embodiments disclosed herein may be embodied directly in hardware, in a software module executed by a processor, or in a combination of the two. A software module may reside in Random Access Memory (RAM), memory, Read Only Memory (ROM), electrically programmable ROM, electrically erasable programmable ROM, registers, hard disk, a removable disk, a CD-ROM, or any other form of storage medium known in the art.
The previous description of the disclosed embodiments is provided to enable any person skilled in the art to make or use the present application. Various modifications to these embodiments will be readily apparent to those skilled in the art, and the generic principles defined herein may be applied to other embodiments without departing from the spirit or scope of the application. Thus, the present application is not intended to be limited to the embodiments shown herein but is to be accorded the widest scope consistent with the principles and novel features disclosed herein.

Claims (10)

1. A method of automatically generating a data report, the method comprising:
determining a data source for generating a data report;
configuring data statistical logic; the data statistics logic is that all data statistics structured query languages under the theme are acquired through the data report theme, are executed one by one, generate related data sets and then are placed in the context of the data report;
defining a report template for generating a data report;
generating a data report based on the data source, statistical logic, and the report template.
2. The method of claim 1, further comprising:
and sending the data report based on a preset time.
3. The method of claim 1 or 2, wherein determining the data source for generating the data report comprises:
a data source configuration table is defined for generating data reports.
4. The method of claim 3, wherein the configuration data statistics logic comprises:
the logic of data statistics is configured in the manner of structured query language statements.
5. The method of claim 4, wherein defining a report template for generating a data report comprises:
and editing the report template through a text editing plug-in.
6. A system for automatically generating data reports, comprising:
a determination module to determine a data source for generating a data report;
the configuration module is used for configuring data statistical logic; the data statistics logic is that all data statistics structured query languages under the theme are acquired through the data report theme, are executed one by one, generate related data sets and then are placed in the context of the data report;
a definition module for defining a report template for generating a data report;
a generation module to generate a data report based on the data source, the statistical logic, and the report template.
7. The system of claim 6, further comprising:
and the sending module is used for sending the data report based on preset time.
8. The system according to claim 6 or 7, wherein the determining module is specifically configured to:
a data source configuration table is defined for generating data reports.
9. The system of claim 8, wherein the configuration module is specifically configured to:
the logic of data statistics is configured in the manner of structured query language statements.
10. The system of claim 9, wherein the definition module is specifically configured to:
and editing the report template through a text editing plug-in.
CN201910783358.9A 2019-08-23 2019-08-23 Method and system for automatically generating data report Active CN110489462B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201910783358.9A CN110489462B (en) 2019-08-23 2019-08-23 Method and system for automatically generating data report

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201910783358.9A CN110489462B (en) 2019-08-23 2019-08-23 Method and system for automatically generating data report

Publications (2)

Publication Number Publication Date
CN110489462A CN110489462A (en) 2019-11-22
CN110489462B true CN110489462B (en) 2022-06-03

Family

ID=68553188

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201910783358.9A Active CN110489462B (en) 2019-08-23 2019-08-23 Method and system for automatically generating data report

Country Status (1)

Country Link
CN (1) CN110489462B (en)

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN112989782B (en) * 2021-04-22 2021-08-27 北京三维天地科技股份有限公司 Method for automatic template configuration and report generation

Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105138501A (en) * 2015-08-10 2015-12-09 北京思特奇信息技术股份有限公司 Configurable dynamic report generating method and system
CN105740368A (en) * 2016-01-27 2016-07-06 浪潮通信信息系统有限公司 Method and device for generating report form
CN106528514A (en) * 2016-10-31 2017-03-22 山东鲁能软件技术有限公司 Report generation system and method
CN106933862A (en) * 2015-12-30 2017-07-07 北京神州泰岳软件股份有限公司 A kind of method and apparatus for generating mail report
CN110083814A (en) * 2019-04-09 2019-08-02 大唐微电子技术有限公司 A kind of report form generation method and device, computer readable storage medium

Patent Citations (5)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105138501A (en) * 2015-08-10 2015-12-09 北京思特奇信息技术股份有限公司 Configurable dynamic report generating method and system
CN106933862A (en) * 2015-12-30 2017-07-07 北京神州泰岳软件股份有限公司 A kind of method and apparatus for generating mail report
CN105740368A (en) * 2016-01-27 2016-07-06 浪潮通信信息系统有限公司 Method and device for generating report form
CN106528514A (en) * 2016-10-31 2017-03-22 山东鲁能软件技术有限公司 Report generation system and method
CN110083814A (en) * 2019-04-09 2019-08-02 大唐微电子技术有限公司 A kind of report form generation method and device, computer readable storage medium

Also Published As

Publication number Publication date
CN110489462A (en) 2019-11-22

Similar Documents

Publication Publication Date Title
CN105335293B (en) A kind of automatization test system and method based on interface concurrent
CN106933862B (en) Method and device for generating mail report
CN108280023B (en) Task execution method and device and server
CN107678736A (en) A kind of business Page Template shows method, system and computer installation
CN112860247B (en) Custom generation method, device, equipment and medium of model component
CN115065652B (en) Message reply method and device, storage medium and computer equipment
CN110837496A (en) Data quality management method and system based on dynamic sql
CN111367982B (en) Method, device, computer equipment and storage medium for importing TRRIGA basic data
CN110489462B (en) Method and system for automatically generating data report
CN117009483A (en) Method, device and equipment for generating question-answering service and readable storage medium
JP4626675B2 (en) Firmware providing method, communication system and service server using communication network
CN110659190A (en) Quality report generation method, quality report generation device, quality report generation equipment and computer readable storage medium
US11283748B2 (en) Message based information technology service management
CN113467782B (en) Method, device and equipment for determining business process
CN113079086B (en) Message transmission method, message transmission device, electronic device, and storage medium
US11082579B2 (en) Information processing apparatus, method of controlling information processing apparatus and non-transitory computer-readable medium storing program
JP6750838B1 (en) Procedure definition device for business automation processing and procedure definition system for business automation processing
CN109344372B (en) Big data-based document generation method and system
CN109597845B (en) Report configuration method, report configuration device, computer equipment and storage medium
CN111885180B (en) Message issuing method and device
CN110647546A (en) Third-party rule engine generation method and device
US20150207935A1 (en) Setup application for generating custom code
CN110147411B (en) Data synchronization method, device, computer equipment and storage medium
CN117874211A (en) Intelligent question-answering method, system, medium and electronic equipment based on SAAS software
CN117640736A (en) Report pushing method, report pushing device, computer equipment and storage medium

Legal Events

Date Code Title Description
PB01 Publication
PB01 Publication
SE01 Entry into force of request for substantive examination
SE01 Entry into force of request for substantive examination
GR01 Patent grant
GR01 Patent grant