CN111680478B - Report generation method, device, equipment and storage medium based on configuration software - Google Patents
Report generation method, device, equipment and storage medium based on configuration software Download PDFInfo
- Publication number
- CN111680478B CN111680478B CN202010554339.1A CN202010554339A CN111680478B CN 111680478 B CN111680478 B CN 111680478B CN 202010554339 A CN202010554339 A CN 202010554339A CN 111680478 B CN111680478 B CN 111680478B
- Authority
- CN
- China
- Prior art keywords
- report
- data
- configuration software
- software
- configuration
- 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
- 238000000034 method Methods 0.000 title claims abstract description 88
- 230000006870 function Effects 0.000 claims abstract description 38
- 230000008569 process Effects 0.000 claims abstract description 22
- 238000013461 design Methods 0.000 claims description 36
- 238000004590 computer program Methods 0.000 claims description 26
- 238000013515 script Methods 0.000 abstract description 11
- 238000004364 calculation method Methods 0.000 description 15
- 238000011161 development Methods 0.000 description 7
- 238000010586 diagram Methods 0.000 description 6
- 230000000007 visual effect Effects 0.000 description 6
- 238000012544 monitoring process Methods 0.000 description 5
- 238000004886 process control Methods 0.000 description 4
- 239000003208 petroleum Substances 0.000 description 2
- 238000007639 printing Methods 0.000 description 2
- 230000003068 static effect Effects 0.000 description 2
- 239000000126 substance Substances 0.000 description 2
- XLYOFNOQVPJJNP-UHFFFAOYSA-N water Substances O XLYOFNOQVPJJNP-UHFFFAOYSA-N 0.000 description 2
- 230000004888 barrier function Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000006243 chemical reaction Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000009191 jumping Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
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/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- 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
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
A report generation method, device, equipment and storage medium based on configuration software, wherein the method comprises the following steps: receiving a report generation instruction, wherein the report generation instruction carries report parameters of a report to be generated; calling a query tool to read historical data corresponding to the report parameters from a target database corresponding to the configuration software; loading a preset form template corresponding to the report to be generated; filling the acquired historical data corresponding to the report parameters into the preset table template to obtain initial report data; and receiving a data sorting instruction, and carrying out data sorting on the initial report data based on the data sorting instruction to obtain a report. According to the method, the required historical data is read from the target database corresponding to the configuration software, the historical data is filled into the preset form template, and the report is obtained after data arrangement, the process is separated from the configuration software, the limitation of functions and scripts provided by the configuration software is not relied on, and the configuration software is prevented from being blocked and dying in the execution process.
Description
Technical Field
The present invention relates to the field of data statistics technologies, and in particular, to a method and an apparatus for generating a report based on configuration software, a computer device, and a storage medium.
Background
The configuration software is also called configuration monitoring system software, and is special software for data acquisition and process control (SCADA, supervisory Control and Data Acquisition), and also refers to a software platform and a development environment at the level of an automatic control system monitoring layer. The software is also a general-purpose level software tool for rapidly constructing the monitoring function of the industrial automatic control system for users through a flexible configuration mode. The configuration software is widely applied to the fields of machinery, automobiles, petroleum, chemical industry, papermaking, water treatment, process control and the like.
A report is a form that dynamically displays data in a form, chart, or the like. When the report function is realized by using the configuration software in the traditional method, the report function is usually realized by matching the Script function of the configuration software with a general form control, however, the existing configuration software part does not have the function of realizing the report, and the efficiency of the configuration software which can realize the report function is usually lower when the Script function of the configuration software is used for realizing data statistics calculation, the configuration software is easy to be blocked and is seriously caused to be dead, and the configuration software is not responded.
Disclosure of Invention
Based on the foregoing, it is necessary to provide a method, a device, a computer device and a storage medium for generating a report based on configuration software with high statistical calculation efficiency.
A report generation method based on configuration software, the method comprising:
receiving a report generation instruction, wherein the report generation instruction carries report parameters of a report to be generated;
calling a query tool to read historical data corresponding to the report parameters from a target database corresponding to the configuration software;
loading a preset form template corresponding to the report to be generated;
filling the acquired historical data corresponding to the report parameters into the preset table template to obtain initial report data;
and receiving a data sorting instruction, and carrying out data sorting on the initial report data based on the data sorting instruction to obtain a report.
In one embodiment, before receiving the report generation instruction, the method further comprises:
acquiring a software identifier of configuration software;
the calling and inquiring tool reads the historical data corresponding to the report parameters from the target database corresponding to the configuration software, and the method comprises the following steps:
when the standard access interface of the self-contained database is provided by the configuration software according to the software identification, a query tool is called to read historical data corresponding to the report parameters from the self-contained database through the standard access interface; the target database corresponding to the configuration software comprises the self-contained database.
In one embodiment, the calling the query tool to read the historical data corresponding to the report parameters from the target database corresponding to the configuration software includes:
when the configuration software is determined to not provide a standard access interface with a database according to the software identification, calling a configuration tool to acquire parameter variables of the configuration software, and acquiring a configuration file corresponding to the configuration software;
in the running process of the configuration software, calling a real-time data acquisition tool to acquire real-time data corresponding to the configuration file in the configuration software, and storing the acquired real-time data into a preset database; the target database corresponding to the configuration software comprises the preset database.
In one embodiment, before loading the preset table template corresponding to the report to be generated, the method further includes: inquiring whether a preset table template corresponding to the report to be generated exists or not, if so, entering the step of loading the preset table template corresponding to the report to be generated;
when the table template corresponding to the report to be generated is not queried, the method further comprises the following steps:
receiving report design requirements, and generating a target table template corresponding to the report to be generated based on the report design requirements;
Filling the obtained historical data corresponding to the report parameters into the target table template to obtain initial report data;
and receiving a data sorting instruction, and carrying out data sorting on the initial report data based on the data sorting instruction to obtain a report.
In one embodiment, the generating the target table template corresponding to the report to be generated based on the report design requirement includes:
creating an Excel table, wherein the Excel table comprises a pivot table workbook and a report workbook;
and determining a report style of the report workbook based on the report design requirement, and obtaining the target table template.
In one embodiment, the filling the obtained history data corresponding to the report parameters into the target table template to obtain initial report data, and obtaining the initial report data includes: filling the obtained historical data corresponding to the report parameters into the pivot table workbook; reading corresponding data from the pivot table workbook and filling the corresponding data into the report workbook;
the data sorting instruction is used for carrying out data sorting on the initial report data to obtain a report, and the method comprises the following steps: and calling a corresponding Excel function based on the data sorting instruction to sort the data of the report workbook, so as to obtain the report.
In one embodiment, after obtaining the report, further comprising: receiving an operation instruction aiming at the report; and executing corresponding operation on the report according to the operation instruction.
A report generation device based on configuration software, the device comprising:
the instruction receiving module is used for receiving a report generation instruction, wherein the report generation instruction carries report parameters of a report to be generated;
the historical data reading module is used for calling a query tool to read historical data corresponding to the report parameters from a target database corresponding to the configuration software;
the template loading module is used for loading a preset form template corresponding to the report to be generated;
the data filling module is used for receiving a data sorting instruction, filling the acquired historical data corresponding to the report parameters into the preset form template based on the data sorting instruction, and obtaining initial report data;
and the data sorting module is used for carrying out data sorting on the initial report data based on the data sorting instruction to obtain a report.
The computer equipment comprises a memory and a processor, wherein the memory stores a computer program, and the processor realizes the steps of the report generating method based on the configuration software when executing the computer program.
A computer readable storage medium having stored thereon a computer program which when executed by a processor performs the steps of the configuration software based report generation method described above.
According to the report generating method, the device, the equipment and the storage medium based on the configuration software, when the report generating instruction is received, based on the report parameters carried by the report generating instruction, the query tool is called to acquire corresponding historical data from the database corresponding to the configuration software, meanwhile, a preset table template corresponding to the report to be generated is loaded, and the query tool fills the acquired historical data into the preset table template to acquire initial report data; and then, carrying out data sorting on the initial report data based on the received data sorting instruction to obtain a report. According to the method, the required historical data is read from the target database corresponding to the configuration software, and is filled into the preset form template corresponding to the report to be generated, the report data is arranged by combining the data arranging instruction, so that the report is obtained, the process is separated from the configuration software, the function provided by the configuration software and the limitation of the script are not relied on, and the configuration software is prevented from being blocked and dying in the execution process.
Drawings
FIG. 1 is an application environment diagram of a report generation method based on configuration software in one embodiment;
FIG. 2 is a flowchart of a report generating method based on configuration software in one embodiment;
FIG. 3 is a flowchart of a report generating method based on configuration software according to another embodiment;
FIG. 4 is a flowchart of a query tool for reading historical data corresponding to report parameters from a target database corresponding to configuration software according to an embodiment;
FIG. 5 is a flowchart of a report generating method based on configuration software according to another embodiment;
FIG. 6 is a flowchart of a report generation method based on configuration software in an embodiment;
FIG. 7 is a diagram of a report in one embodiment;
FIG. 8 is a block diagram illustrating an exemplary configuration software-based report generating apparatus according to an embodiment;
fig. 9 is an internal structural diagram of a computer device in one embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application will be further described in detail with reference to the accompanying drawings and examples. It should be understood that the specific embodiments described herein are for purposes of illustration only and are not intended to limit the present application.
The report generation method based on the configuration software can be applied to an application environment shown in fig. 1. Wherein the terminal 102 communicates with the server 104 via a network. When receiving the report generation instruction, the server 104 acquires corresponding historical data from a database corresponding to the configuration software by calling a query tool based on report parameters carried by the report generation instruction, and loads a preset table template corresponding to the report to be generated at the same time, and the query tool fills the acquired historical data into the preset table template to acquire initial report data; and then, carrying out data sorting on the initial report data based on the received data sorting instruction to obtain a report. In some embodiments, the report is sent to the terminal 102 for display after the report is obtained. The terminal 102 may be, but not limited to, various personal computers, notebook computers, smartphones, tablet computers, and portable wearable devices, and the server 104 may be implemented by a stand-alone server or a server cluster composed of a plurality of servers.
In one embodiment, as shown in fig. 2, a report generating method based on configuration software is provided, and the method is applied to the server in fig. 1 for illustration, and includes steps S210 to S250.
Step S210, a report generation instruction is received, wherein the report generation instruction carries report parameters of a report to be generated.
The report generation instruction may be an instruction issued by a user and used to instruct the server to generate a report. The report parameters comprise parameters required in a report to be generated; in one embodiment, the report parameters include some of the parameters in the data obtained in the configuration software. Report forms for reporting to the higherorganizations reports the status to the upper level. Briefly, the method comprises the following steps: the report forms dynamically display data in forms of tables, icons and the like, and can be expressed as follows: "report = multiple formats + dynamic data".
Step S220, a query tool is called to read historical data corresponding to report parameters from a target database corresponding to the configuration software.
Configuration software, also known as configuration monitoring system software, is dedicated software for data acquisition and process control, and also refers to a software platform and development environment at the level of the monitoring layer of an automatic control system. The configuration software is widely applied to the fields of machinery, automobiles, petroleum, chemical industry, papermaking, water treatment, process control and the like. In one embodiment, the configuration software is SCADA (Supervisory Control And Data Acquisition, data acquisition and supervisory control) software. In one embodiment, the configuration software may be Siemens Wincc, wonderware Intouch, citict, sub-control king, etc. In one embodiment, the configuration software used in this embodiment provides OPC DA Server functionality. The OPC DA Server provides a plurality of interfaces through which the OPC DA Client can obtain information of hardware devices connected with the OPC DA Server without knowing the detailed information of the hardware devices.
The target database is a database storing data of configuration software, and in one embodiment, the target database may be a database that is self-contained with configuration software, such as an InSQL database that is self-contained with items of WonderWare Intouch SCADA (one of SCADA software) software. In another embodiment, other databases connected to the configuration software are also possible, in which historical data of the configuration software is stored, such as MySQL database. In one embodiment, if the configuration software provides a standard access interface of the self-contained database, allowing external access, the target database is the self-contained database of the configuration software; in this embodiment, before the query tool is called to read the historical data corresponding to the report parameters from the target database corresponding to the configuration software, the method further includes: and calling the query tool to connect the self-contained database of the configuration software through an access interface of the self-contained database provided by the configuration software. In another embodiment, if the configuration software provides a standard access interface with a database, a target database is required to be built, and data is obtained from the database of the configuration software in advance through a data obtaining tool and stored in the target database, or real-time data can be obtained and stored in the target database while the configuration software is running through a real-time data obtaining tool.
The query tool is used for acquiring historical data corresponding to report parameters from a database (in the embodiment, a target database) for storing the historical data of the configuration software; in one embodiment, the report generating instruction further includes a history period corresponding to a report parameter of the report to be generated, and further, in this embodiment, the query tool is invoked to obtain history data corresponding to the history period according to the report generating instruction. In this embodiment, the query tool obtains corresponding historical data according to the historical time period specified in the report generation instruction, and may obtain corresponding historical data according to the needs of the user, so as to be used for making a report. In one particular embodiment, the query tool is an application or a net, activeX control with a report display interface. Net is an operation platform which allows people to construct various application modes on the operation platform, so that people can obtain information from websites to the greatest extent in a diversified way through a simple mode, the cooperative work among websites is solved, and the barriers among computers, equipment, websites, major institutions and industry are broken; activeX controls are Microsoft's designation of a range of strategic object-oriented program technologies and tools, the primary of which is the Component Object Model (COM). In a specific embodiment, the query tool may be developed using Visual Studio, and the historical data corresponding to the report parameters is queried from the target database through the database query grammar according to the report type and report parameters of the report to be generated. In one embodiment, the report parameters include report template name, start time, end time, or report type, among others. Where Visual Studio (Microsoft Visual Studio, a family of development kits; includes most of the tools required throughout the software lifecycle, such as UML tools, code management tools, integrated Development Environment (IDE), etc., it will be appreciated that in other embodiments, the query tools may be developed by other development tools as well.
In this embodiment, after receiving the report generation instruction, the query tool is called according to the report generation instruction to obtain corresponding historical data, so as to be used for making a subsequent report.
Step S230, loading a preset table template corresponding to the report to be generated.
The preset table template is a table template corresponding to a preset report, and can be any type of table template formed by tables.
In a specific embodiment, loading a preset table template corresponding to a report to be generated includes: and loading a preset Excel table template corresponding to the report to be generated. In this embodiment, a table template is preset for a report to be generated, that is, a preset Excel table template, and after a report generation instruction is received, the corresponding preset Excel table template is loaded according to the report generation instruction. Microsoft Excel is a piece of spreadsheet software written by Microsoft (Microsoft) for computers using windows (a suite of operating systems developed by Microsoft) and Apple Macintosh (Makino computer) operating systems. Has visual interface, excellent calculation function and graph tool. In this embodiment, an Excel table is used as a table template of the report, and has rich calculation functions and chart tools, so that the functions of the Excel can be utilized to realize the diversified functions of the report, the complex calculation of the report can be realized, and even a person without software development capability can realize the complex calculation by using the functions of the Excel calculation formula.
In one embodiment, table templates of a plurality of reports are stored in a server, table template identifiers are set for the table templates to distinguish the templates, and when a report generation instruction is received, a corresponding preset Excel table template is loaded according to the target table template identifier carried in the report generation instruction.
Step S240, filling the history data corresponding to the acquired report parameters into a preset table template to acquire initial report data.
The report parameters may include a plurality of parameter data, after the preset table is loaded, each report parameter is respectively filled in a position corresponding to the preset table template, so that parameter data required by an unprocessed report can be obtained, and the embodiment is recorded as initial report data.
In the embodiment, corresponding historical data is obtained from the configuration software according to the requirements of the user, and then the historical data is filled into a preset form template established by an Excel form to obtain initial data report data, so that the complex statistics and calculation requirements can be realized by utilizing the calculation function of the Excel form, and the functions which cannot be realized by an Excel formula can be realized by using macro script in the Excel; namely, the report generating method based on the configuration software in the embodiment can realize the statistical calculation requirement in a relatively complex report.
Step S250, a data sorting instruction is received, and data sorting is carried out on the initial report data based on the data sorting instruction, so that a report is obtained.
The data arrangement instruction is an instruction initiated by a user and used for arranging the generated initial report data so as to generate a report meeting the user requirement; the data sort instruction carries instructions of all operations required by the process of sorting the initial report data into the report, such as instructions including a calculation function.
In one embodiment, after obtaining the report, further comprising: and receiving an operation instruction aiming at the report, and executing corresponding operation on the report according to the operation instruction. The operation instructions for the report form comprise a storage instruction, a display instruction, a deriving instruction, a printing preview instruction or a printing instruction and the like for the report form; after generating the report, the user can select to save, display, export, print preview or print the report, and when receiving the corresponding operation instruction, the server executes the operation (save, display, export, print preview or print, etc.) corresponding to the operation instruction on the report. In a specific embodiment, after obtaining the report, the method further comprises: and receiving a report display operation instruction, and displaying a report according to the operation instruction. And after the initial report data is sorted based on the data sorting requirement to obtain a report, displaying the report, and completing the report work. In one embodiment, the report may be displayed by inserting a control (such as an Excel control) or other controls corresponding to a preset form template into the configuration software, and displaying the generated report to complete the report work.
In an embodiment, the method for generating the report based on the configuration software may be implemented in different forms, for example, in a specific embodiment, the method for generating the report based on the configuration software may be implemented by an independent program, the method for generating the report based on the configuration software may be implemented by an independent control in a manner of embedding the configuration software, or the method for generating the report based on the configuration software may be implemented by calling a corresponding dynamic chain. It will be appreciated that in other embodiments, the configuration software-based report generation method described above may be implemented in other forms.
According to the report generating method based on the configuration software, when the report generating instruction is received, based on the report parameters carried by the report generating instruction, the query tool is called to acquire corresponding historical data from the database corresponding to the configuration software, meanwhile, a preset table template corresponding to the report to be generated is loaded, and the query tool fills the acquired historical data into the preset table template to acquire initial report data; and then, carrying out data sorting on the initial report data based on the received data sorting instruction to obtain a report. According to the method, the required historical data is read from the target database corresponding to the configuration software, and is filled into the form template corresponding to the report to be generated, the data arrangement instruction is combined to realize the arrangement of the report data, the report is obtained, the process is separated from the configuration software, the limitation of functions and scripts provided by the configuration software is not relied on, and the situation that the configuration software is blocked and killed in the execution process can be avoided.
In one embodiment, as shown in fig. 3, before receiving the report generation instruction, the method further includes: step S310, obtaining a software identifier of configuration software; in this embodiment, the step S320 of calling the query tool to read the history data corresponding to the report parameters from the target database corresponding to the configuration software includes: when the configuration software is determined to provide a standard access interface of the self-contained database according to the software identification, a query tool is called to read historical data corresponding to report parameters from the self-contained database of the configuration software through the standard access interface; the target database corresponding to the configuration software comprises a self-contained database of the configuration software.
In this embodiment, the software identifier of the configuration software is a unique identifier of the configuration software, and a unique configuration software can be determined by the software identifier of the configuration software; it is further determined whether the configuration software has a standard access interface to a self-contained database.
When the configuration software is determined to provide a standard access interface of the self-contained database according to the software identification of the configuration software, the self-contained database of the configuration software is indicated to allow external access, and the query tool can be directly called to access the self-contained database of the configuration software through the standard access interface so as to obtain corresponding historical data. Further, in this embodiment, before the query tool is called to read the historical data corresponding to the report parameters from the target database corresponding to the configuration software, the method further includes: and calling the query tool to connect the self-contained database of the configuration software through an access interface of the self-contained database provided by the configuration software.
In this embodiment, whether the configuration software provides the self-contained database for external access is determined through the software identifier of the configuration software, that is, when the standard data access interface of the self-contained database is provided, the query tool is called to directly obtain the historical data corresponding to the report parameters from the self-contained database of the configuration software through the standard access interface, and the database is not required to be additionally installed for storing the data of the state software, so that the space can be saved.
In another embodiment, when the software identification of the configuration software determines that the configuration software does not provide a standard access interface to the self-contained database, a target database is created for storing the data of the configuration software. In one embodiment, the real-time data may be obtained while the configuration software is running and stored in the target database by invoking a real-time data acquisition tool. In another embodiment, the required data may be obtained from the configuration software by other data acquisition tools and stored in the target database.
In another embodiment, as shown in fig. 4, invoking the query tool to read the historical data corresponding to the report parameters from the target database corresponding to the configuration software includes: in step S410, when it is determined that the configuration software does not provide the standard access interface with the database according to the software identifier, the configuration tool is invoked to obtain the parameter variable of the configuration software, and the configuration file corresponding to the configuration software is generated according to the parameter variable. Step S420, calling a real-time data acquisition tool to acquire a configuration file in the running process of the configuration software, acquiring real-time data corresponding to each parameter variable in the configuration file from the configuration software, and storing the acquired real-time data into a preset database; the target database corresponding to the configuration software comprises a preset database; step S430, calling a query tool to read historical data corresponding to report parameters from a target database corresponding to the configuration software.
The real-time data acquisition tool is used for acquiring real-time data from the configuration software and storing the real-time data into the target database. In one embodiment, the real-time data acquisition tool may be developed by Visual Studio, and according to a preset configuration file, the real-time data of the configuration software is read by OPC Client (OPC Client) while the configuration software is running, and stored in the target database according to the data conversion rate exceeding the threshold. In one embodiment, the real-time data acquisition tool may be an application running in the background, a net control, or an ActiveX control. In one embodiment, the real-time data acquisition tool writes the read real-time data to the target database at storage interval conditions (e.g., a rate of change of greater than 1%). The real-time data acquisition tool reads real-time data in the running process of the configuration software, stores the target database, and when a report generation instruction is received, can read historical data required by a report to be generated from the target database. It will be appreciated that in other embodiments, the real-time data acquisition tool may be developed by other development tools.
The configuration tool is used for acquiring parameter variables of the configuration software and generating configuration files corresponding to the configuration software according to the parameter variables; the configuration tool can obtain the parameter variables of the configuration software and collate the parameter variables to generate corresponding configuration files for storage, and the real-time data obtaining tool can obtain the corresponding real-time data from the configuration software according to the configuration files for storage in the subsequent use process. The obtained parameter variables can be the parameter variables which are monitored by all the configuration software, and can also be the parameter variables which are determined according to the user requirements, namely, the parameter variables can be part of the parameter variables which are monitored by the configuration software; in one embodiment, the configuration tool reads the configuration software defined variable access path and selects the variables to be used in the report and stores the variables as configuration files. In one embodiment, the configuration tool may be developed through Visual Studio, and the configuration software defined parameter variable access path is read through OPC Client, and the variables needed to be used in the report are selected and saved as configuration files. It is to be appreciated that in other embodiments, the configuration tool may be developed by other development tools.
In one embodiment, the data itself redundancy may be used or a redundant data function may be provided for the pre-set database when constructing the pre-set database. In a specific embodiment, mySQL database is used as a preset database, and MySQL has three implementation methods, and SQLServer can directly use redundancy or scheduling functions.
In this embodiment, the configuration software is a standard access interface provided with a database, and the real-time data of the configuration software is obtained by the real-time data obtaining tool while the configuration software is running and stored in a preset database (target database), and when a report generating instruction is received, the query tool is called to obtain the history data required by the report generating instruction from the preset database. Because the configuration tool and the real-time data acquisition tool are adopted, the report generation method based on the configuration software in the embodiment can be applied to various different types of configuration software (including the configuration software with a database access interface and the configuration software without the database access interface), so that the report generation method based on the configuration software has stronger universality.
In one embodiment, as shown in fig. 5, before loading the preset table template corresponding to the report to be generated, the method further includes step S510: inquiring whether a preset table template corresponding to the report to be generated exists or not, and if so, entering a step of loading the preset table template corresponding to the report to be generated. In this embodiment, when no preset table template corresponding to the report to be generated is queried, steps S520 to S540 are further included.
Step S520, receiving report design requirements, and generating a target table template corresponding to the report to be generated based on the report design requirements.
Report design requirements refer to the design requirements of a user on a table template of a report, and the report design requirements can include requirements of parameters, formats and the like required by the table template. Corresponding form templates may be generated based on the report design requirements. In this embodiment, if the to-be-generated report corresponding to the report generation instruction does not find the corresponding preset table template, the table template corresponding to the to-be-generated report is created first according to the report design requirement input by the user, and in this embodiment, the to-be-generated report is marked as the target table template, and then the obtained historical data can be filled into the target table template to obtain initial report data.
And step S530, filling the historical data corresponding to the acquired report parameters into a target table template to acquire initial report data.
Filling the history data corresponding to the acquired report parameters into the target table template is similar to the process of filling the history data into the preset table template, and filling each item of parameters, variables and the like in the report parameters into the target table template correspondingly, so that initial report data can be acquired.
Step S540, a data sorting instruction is received, and data sorting is carried out on the initial report data based on the data sorting instruction, so that a report is obtained.
After the initial report data is obtained, a data arrangement instruction sent by a user is received, and the initial report data is subjected to data arrangement according to the data arrangement instruction, so that a report meeting the requirement of the user is obtained. And after the historical data corresponding to the report parameters are stored in the preset table template, the process of sorting the obtained initial report data is the same.
In this embodiment, if a preset table template corresponding to a report to be generated is not found when a report generation instruction for generating the report to be generated is received, a target table template is created according to a report design requirement sent by a user, and then the acquired historical data is filled into the target table template to obtain initial report data for subsequent sorting and generating of the report.
Further, in one embodiment, generating a table template corresponding to a report to be generated based on the report design requirements includes: creating an Excel table, wherein the Excel table comprises a pivot table workbook and a report workbook; and determining the report style of the report workbook based on the report design requirement to obtain a target table template.
In an embodiment, the creating target table template is an Excel table created, and the Excel table at least includes a pivot table workbook and a report workbook; a pivot table workbook, a SourceData workbook, for filling in the acquired history data; and the Report workbook is used for presenting the generated Report style and data. The report design requirements limit the form style of the report workbook in the Excel form, and after the report design requirements are received, the form of the report workbook in the Excel form is designed according to the report design requirements, so that a target form template is obtained. The target table template adopts an Excel table template, initial report data is obtained after the history data is filled in later, a report is obtained by sorting the initial report data, the report can be obtained by sorting the data by utilizing the function of the Excel table, the complex calculation is realized by using the calculation function of the Excel, and the complex calculation can be realized by using the function of the Excel calculation formula without software development capability personnel. For functions which cannot be realized by the Excel formula, macro script can be used in the Excel, so that the universality is high.
In one embodiment, filling the historical data corresponding to the acquired report parameters into an Excel table template to obtain initial report data, including: filling the history data corresponding to the acquired report parameters into a pivot table workbook; reading corresponding data from the pivot table workbook and filling the corresponding data into the report workbook; data sorting is carried out on the initial report data based on the data sorting instruction to obtain a report, and the method comprises the following steps: and calling the Excel function based on the data sorting instruction to sort the data of the report workbook, thereby obtaining the report.
In this embodiment, for obtaining the history data corresponding to the report parameters of the report to be generated, the history data is stored in the pivot table workbook of the preset Excel table template, and when the initial report data is subjected to data arrangement based on the data arrangement instruction, the data is read from the pivot table workbook and is filled into the report workbook, and then the data in the report workbook is arranged according to the data arrangement instruction, so that the report is obtained.
In one embodiment, as shown in fig. 6, the report generating method based on the configuration software includes the following steps (in this embodiment, an Excel table is taken as an example of a preset table template):
acquiring a software identifier of the configuration software, determining whether the configuration software provides a standard access interface of a self-contained database according to the software identifier, and if so, calling a query tool (which can be an application program with a report display interface or a net and an ActiveX control) to read historical data corresponding to report parameters of a report to be generated in the report generation instruction from the self-contained database of the configuration software when the report generation instruction is received. If the configuration software is determined to not provide the standard access interface of the self-contained database according to the software identification, calling a configuration tool to acquire parameter variables in the configuration software and generating a corresponding configuration file. In the running process of the configuration software, a real-time data acquisition tool is called to read the configuration file generated by the configuration tool, and real-time data corresponding to each parameter variable of the configuration file is acquired from the configuration software and stored in a preset database (for example, SQLServer, oracle, mySQL and the like). When a report generating instruction is received, a query tool is called to read historical data corresponding to report parameters of a report to be generated from a preset database.
Judging whether a preset Excel table template corresponding to the report to be generated exists or not, if yes, filling the read historical data into a 'SourceData' worksheet of the preset Excel table template, and obtaining initial report data. If the preset Excel table template corresponding to the Report to be generated does not exist, receiving a Report design requirement, and creating an Excel table corresponding to the Report to be generated according to the Report design requirement, wherein the Excel table comprises a SourceData worksheet and a Report worksheet; and determining a Report worksheet based on the Report design requirements to obtain a target Excel form template. And then storing the read historical data into the target Excel table template to obtain initial report data.
Further, a data sorting instruction is received, data filled in a 'SourceData' worksheet of an Excel table filled with historical data is read into a 'Report' worksheet, and a corresponding function of the Excel is called based on the data sorting instruction to sort initial Report data so as to obtain a Report. Further, the report is displayed through the query tool. A schematic diagram of a report in one embodiment is shown in fig. 7.
In the embodiment, the method can realize the function of the actual project on the report very efficiently aiming at different types of configuration software, greatly improves the project execution efficiency, saves the cost and more completely realizes the requirements of customers. The method is completely separated from the configuration software, and does not depend on the functions of the configuration software and the limitation of a script system; the script system of the configuration software is not used any more, software development is not required to be carried out according to the grammar of different types of software, and the project implementation difficulty is reduced. The complex computation is realized by using the computation function of Excel, and the complex computation can be realized by using the computation formula function of Excel without software development capability personnel. For functions which cannot be realized by the Excel formula, the functions can be realized by using macro scripts in the Excel, so that the method has strong universality.
It should be understood that, although the steps in the flowcharts of fig. 2-6 are shown in order as indicated by the arrows, these steps are not necessarily performed in order as indicated by the arrows. The steps are not strictly limited to the order of execution unless explicitly recited herein, and the steps may be executed in other orders. Moreover, at least some of the steps in fig. 2-6 may include multiple steps or stages that are not necessarily performed at the same time, but may be performed at different times, nor does the order in which the steps or stages are performed necessarily performed in sequence, but may be performed alternately or alternately with at least a portion of the steps or stages in other steps or other steps.
In one embodiment, as shown in fig. 8, a report generating device based on configuration software is provided, including: an instruction receiving module 810, a history data reading module 820, a template loading module 830, a data populating module 840, and a data sorting module 850, wherein:
the instruction receiving module 810 is configured to receive a report generating instruction, where the report generating instruction carries report parameters of a report to be generated;
The historical data reading module 820 is used for calling the query tool to read the historical data corresponding to the report parameters from the target database corresponding to the configuration software;
the template loading module 830 is configured to load a preset table template corresponding to the report to be generated;
the data filling module 840 is configured to receive a data sorting instruction, and fill historical data corresponding to the acquired report parameters into a preset table template based on the data sorting instruction, so as to obtain initial report data;
the data sorting module 850 is configured to sort the data of the initial report based on the data sorting instruction, and obtain a report.
According to the report generating device based on the configuration software, when the report generating instruction is received, based on report parameters carried by the report generating instruction, corresponding historical data is obtained from a database corresponding to the configuration software by calling a query tool, a preset table template corresponding to a report to be generated is loaded at the same time, and the query tool fills the obtained historical data into the preset table template to obtain initial report data; and then, carrying out data sorting on the initial report data based on the received data sorting instruction to obtain a report. According to the method, the required historical data is read from the target database corresponding to the configuration software, and is filled into the preset form template corresponding to the report to be generated, the report data is arranged by combining the data arranging instruction, so that the report is obtained, the process is separated from the configuration software, the function provided by the configuration software and the limitation of the script are not relied on, and the configuration software is prevented from being blocked and dying in the execution process.
In one embodiment, the apparatus further comprises: the software identification acquisition module is used for acquiring the software identification of the configuration software; in this embodiment, the history data reading module 820 is configured to, when determining that the configuration software provides a standard access interface of the self-contained database according to the software identifier, invoke the query tool to read, through the standard access interface, history data corresponding to report parameters from the self-contained database; the target database corresponding to the configuration software comprises a self-contained database.
Further, in one embodiment, the history data reading module 820 is further configured to call the configuration tool to obtain parameter variables of the configuration software to obtain a configuration file corresponding to the configuration software when it is determined that the configuration software does not provide a standard access interface with the database according to the software identifier; and in the running process of the configuration software, calling a real-time data acquisition tool to acquire a configuration file, acquiring real-time data corresponding to each parameter variable of the configuration file from the configuration software, and storing the acquired real-time data into a preset database; the target database corresponding to the configuration software comprises a preset database.
In one embodiment, the apparatus further comprises: the template inquiry module is used for inquiring whether a preset table template corresponding to the report to be generated exists or not, if yes, the step of jumping to the template loading module to load the preset Excel table template corresponding to the report to be generated is executed; in this embodiment, the apparatus further includes: the table creation module is used for receiving the report design requirement and generating a target table template corresponding to the report to be generated based on the report design requirement; in this embodiment, the data filling module is further configured to fill the history data corresponding to the acquired report parameters into the target table template to obtain initial report data; the data sorting module is used for receiving data sorting instructions, sorting the data of the initial report form based on the data sorting instructions, and obtaining the report form.
In one embodiment, the above-mentioned table creation module is specifically configured to create an Excel table, where the Excel table includes a pivot table workbook and a report workbook; and the table design module is used for determining the report style of the report workbook based on the report design requirement.
In one embodiment, the data populating module is specifically configured to: filling the history data corresponding to the acquired report parameters into a pivot table workbook; reading corresponding data from the pivot table workbook and filling the corresponding data into the report workbook; and the data sorting module is used for calling the corresponding Excel function based on the data sorting instruction to sort the data of the report workbook so as to obtain a report.
In one embodiment, the apparatus further includes an operation instruction receiving module, configured to receive an operation instruction for a report; and the report presentation module is used for executing corresponding operation on the report according to the operation instruction.
For specific limitations of the configuration software-based report generating device, reference may be made to the above limitations of the configuration software-based report generating method, which are not described herein. All or part of the modules in the report generating device based on the configuration software can be realized by software, hardware and a combination thereof. The above modules may be embedded in hardware or may be independent of a processor in the computer device, or may be stored in software in a memory in the computer device, so that the processor may call and execute operations corresponding to the above modules.
In one embodiment, a computer device is provided, which may be a server, and the internal structure of which may be as shown in fig. 9. The computer device includes a processor, a memory, and a network interface connected by a system bus. Wherein the processor of the computer device is configured to provide computing and control capabilities. The memory of the computer device includes a non-volatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, computer programs, and a database. The internal memory provides an environment for the operation of the operating system and computer programs in the non-volatile storage media. The database of the computer equipment is used for storing data such as a preset form template, a configuration file and the like. The network interface of the computer device is used for communicating with an external terminal through a network connection. The computer program, when executed by the processor, implements a report generation method based on configuration software.
It will be appreciated by those skilled in the art that the structure shown in fig. 9 is merely a block diagram of a portion of the structure associated with the present application and is not limiting of the computer device to which the present application applies, and that a particular computer device may include more or fewer components than shown, or may combine some of the components, or have a different arrangement of components.
In one embodiment, a computer device is provided comprising a memory and a processor, the memory having stored therein a computer program, the processor when executing the computer program performing the steps of:
receiving a report generation instruction, wherein the report generation instruction carries report parameters of a report to be generated; calling a query tool to read historical data corresponding to report parameters from a target database corresponding to the configuration software; loading a preset form template corresponding to a report to be generated; filling the history data corresponding to the acquired report parameters into a preset table template to acquire initial report data; and receiving a data sorting instruction, and carrying out data sorting on the initial report data based on the data sorting instruction to obtain a report.
In one embodiment, the processor when executing the computer program further performs the steps of: acquiring a software identifier of configuration software; when the configuration software is determined to provide a standard access interface of the self-contained database according to the software identification, a query tool is called to read historical data corresponding to report parameters from the self-contained database through the standard access interface; the target database corresponding to the configuration software comprises a self-contained database.
In one embodiment, the processor when executing the computer program further performs the steps of: when the configuration software is determined to not provide a standard access interface with a database according to the software identification, calling a configuration tool to acquire parameter variables of the configuration software, and acquiring a configuration file corresponding to the configuration software; in the running process of the configuration software, calling a real-time data acquisition tool to acquire the configuration file, acquiring real-time data corresponding to each parameter variable in the configuration file from the configuration software, and storing the acquired real-time data into a preset database; the target database corresponding to the configuration software comprises a preset database.
In one embodiment, the processor when executing the computer program further performs the steps of: inquiring whether a preset table template corresponding to the report to be generated exists or not, if so, entering a step of loading the preset table template corresponding to the report to be generated; receiving report design requirements, and generating a target table template corresponding to a report to be generated based on the report design requirements; filling the history data corresponding to the acquired report parameters into a target table template to acquire initial report data; and receiving a data sorting instruction, and carrying out data sorting on the initial report data based on the data sorting instruction to obtain a report.
In one embodiment, the processor when executing the computer program further performs the steps of: creating an Excel table, wherein an Excel table template comprises a pivot table workbook and a report workbook; and determining the report style of the report workbook based on the report design requirements.
In one embodiment, the processor when executing the computer program further performs the steps of: filling the history data corresponding to the acquired report parameters into a pivot table workbook; reading corresponding data from the pivot table workbook and filling the corresponding data into the report workbook; and calling a corresponding Excel function based on the data sorting instruction to sort the data of the report workbook, thereby obtaining a report.
In one embodiment, the processor when executing the computer program further performs the steps of: receiving an operation instruction aiming at a report; and executing corresponding operation on the report according to the operation instruction.
In one embodiment, a computer readable storage medium is provided having a computer program stored thereon, which when executed by a processor, performs the steps of:
receiving a report generation instruction, wherein the report generation instruction carries report parameters of a report to be generated; calling a query tool to read historical data corresponding to report parameters from a target database corresponding to the configuration software; loading a preset form template corresponding to a report to be generated; filling the history data corresponding to the acquired report parameters into a preset table template to acquire initial report data; and receiving a data sorting instruction, and carrying out data sorting on the initial report data based on the data sorting instruction to obtain a report.
In one embodiment, the computer program when executed by the processor further performs the steps of: acquiring a software identifier of configuration software; when the configuration software is determined to provide a standard access interface of the self-contained database according to the software identification, a query tool is called to read historical data corresponding to report parameters from the self-contained database through the standard access interface; the target database corresponding to the configuration software comprises a self-contained database.
In one embodiment, the computer program when executed by the processor further performs the steps of: when the configuration software is determined to not provide a standard access interface with a database according to the software identification, calling a configuration tool to acquire parameter variables of the configuration software, and acquiring a configuration file corresponding to the configuration software; in the running process of the configuration software, calling a real-time data acquisition tool to acquire a configuration file, acquiring real-time data corresponding to each parameter variable in the configuration file from the configuration software, and storing the acquired real-time data into a preset database; the target database corresponding to the configuration software comprises a preset database.
In one embodiment, the computer program when executed by the processor further performs the steps of: inquiring whether a preset table template corresponding to the report to be generated exists or not, if so, entering a step of loading the preset table template corresponding to the report to be generated; receiving report design requirements, and generating a target table template corresponding to a report to be generated based on the report design requirements; filling the history data corresponding to the acquired report parameters into a target table template to acquire initial report data; and receiving a data sorting instruction, and carrying out data sorting on the initial report data based on the data sorting instruction to obtain a report.
In one embodiment, the computer program when executed by the processor further performs the steps of: creating an Excel table, wherein the Excel table comprises a pivot table workbook and a report workbook; and determining the report style of the report workbook based on the report design requirements.
In one embodiment, the computer program when executed by the processor further performs the steps of: filling the history data corresponding to the acquired report parameters into a pivot table workbook; reading corresponding data from the pivot table workbook and filling the corresponding data into the report workbook; and calling a corresponding Excel function based on the data sorting instruction to sort the data of the report workbook, thereby obtaining a report.
In one embodiment, the computer program when executed by the processor further performs the steps of: receiving an operation instruction aiming at a report; and executing corresponding operation on the report according to the operation instruction.
Those skilled in the art will appreciate that implementing all or part of the above described methods may be accomplished by way of a computer program stored on a non-transitory computer readable storage medium, which when executed, may comprise the steps of the embodiments of the methods described above. Any reference to memory, storage, database, or other medium used in embodiments provided herein may include at least one of non-volatile and volatile memory. The nonvolatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical Memory, or the like. Volatile memory can include random access memory (RandomAccess Memory, RAM) or external cache memory. By way of illustration, and not limitation, RAM can be in the form of a variety of forms, such as static random access memory (Static Random Access Memory, SRAM) or dynamic random access memory (Dynamic Random Access Memory, DRAM), and the like.
The technical features of the above embodiments may be arbitrarily combined, and all possible combinations of the technical features in the above embodiments are not described for brevity of description, however, as long as there is no contradiction between the combinations of the technical features, they should be considered as the scope of the description.
The above examples merely represent a few embodiments of the present application, which are described in more detail and are not to be construed as limiting the scope of the invention. It should be noted that it would be apparent to those skilled in the art that various modifications and improvements could be made without departing from the spirit of the present application, which would be within the scope of the present application. Accordingly, the scope of protection of the present application is to be determined by the claims appended hereto.
Claims (10)
1. A report generation method based on configuration software is characterized by comprising the following steps:
acquiring a software identifier of configuration software;
receiving a report generation instruction, wherein the report generation instruction carries report parameters of a report to be generated, and the report generation instruction comprises a historical time period corresponding to the report parameters of the report to be generated;
calling a query tool to read historical data corresponding to the report parameters from a target database corresponding to the configuration software;
Loading a preset form template corresponding to the report to be generated;
filling the acquired historical data corresponding to the report parameters into the preset table template to obtain initial report data;
receiving a data sorting instruction, and carrying out data sorting on the initial report data based on the data sorting instruction to obtain a report;
the calling and inquiring tool reads the historical data corresponding to the report parameters from the target database corresponding to the configuration software, and the method comprises the following steps:
when the standard access interface of the self-contained database is provided by the configuration software according to the software identification, a query tool is called to read historical data corresponding to the report parameters from the self-contained database of the configuration software through the standard access interface;
when the configuration software is determined to not provide a standard access interface with a database according to the software identification, calling a configuration tool to acquire parameter variables of the configuration software, and acquiring a configuration file corresponding to the configuration software; in the running process of configuration software, calling a real-time data acquisition tool to acquire the configuration file from the configuration software through the standard access interface, acquiring real-time data corresponding to each parameter variable of the configuration file from the configuration software, and storing the acquired real-time data into a preset database; calling a query tool to read historical data corresponding to the report parameters from the preset database; the target database corresponding to the configuration software comprises the preset database.
2. The method of claim 1, further comprising, prior to loading the preset form template: inquiring whether a preset table template corresponding to the report to be generated exists or not, if so, entering a step of loading the preset table template corresponding to the report to be generated;
when the preset table template corresponding to the report to be generated is not queried, the method further comprises the following steps:
receiving report design requirements, and generating a target table template corresponding to the report to be generated based on the report design requirements;
filling the obtained historical data corresponding to the report parameters into the target table template to obtain initial report data;
and receiving a data sorting instruction, and carrying out data sorting on the initial report data based on the data sorting instruction to obtain a report.
3. The method of claim 2, wherein generating a target table template corresponding to the report to be generated based on the report design requirements comprises:
creating an Excel table, wherein the Excel table comprises a pivot table workbook and a report workbook;
and determining a report style of the report workbook based on the report design requirement, and obtaining the target table template.
4. A method according to claim 3, characterized in that:
filling the obtained historical data corresponding to the report parameters into the target table template to obtain initial report data, and obtaining the initial report data, wherein the method comprises the following steps: filling the obtained historical data corresponding to the report parameters into the pivot table workbook; reading corresponding data from the pivot table workbook and filling the corresponding data into the report workbook;
the data sorting instruction is used for carrying out data sorting on the initial report data to obtain a report, and the method comprises the following steps: and calling a corresponding Excel function based on the data sorting instruction to sort the data of the report workbook, so as to obtain the report.
5. The method according to any one of claims 1 to 4, further comprising, after obtaining the report:
receiving an operation instruction aiming at the report;
and executing corresponding operation on the report according to the operation instruction.
6. A report generating device based on configuration software, the device comprising:
the software identification acquisition module is used for acquiring the software identification of the configuration software;
the instruction receiving module is used for receiving a report generation instruction, wherein the report generation instruction carries report parameters of a report to be generated, and the report parameters comprise a historical time period corresponding to the report parameters of the report to be generated;
The historical data reading module is used for calling a query tool to read historical data corresponding to the report parameters from a target database corresponding to the configuration software;
the template loading module is used for loading a preset form template corresponding to the report to be generated;
the data filling module is used for receiving a data sorting instruction, filling the acquired historical data corresponding to the report parameters into the preset form template based on the data sorting instruction, and obtaining initial report data;
the data sorting module is used for sorting the data of the initial report form based on the data sorting instruction to obtain a report form;
the calling and inquiring tool reads the historical data corresponding to the report parameters from the target database corresponding to the configuration software, and the method comprises the following steps:
when the standard access interface of the self-contained database is provided by the configuration software according to the software identification, a query tool is called to read historical data corresponding to the report parameters from the self-contained database of the configuration software through the standard access interface;
when the configuration software is determined to not provide a standard access interface with a database according to the software identification, calling a configuration tool to acquire parameter variables of the configuration software, and acquiring a configuration file corresponding to the configuration software; in the running process of configuration software, calling a real-time data acquisition tool to acquire the configuration file from the configuration software through the standard access interface, acquiring real-time data corresponding to each parameter variable of the configuration file from the configuration software, and storing the acquired real-time data into a preset database; calling a query tool to read historical data corresponding to the report parameters from the preset database; the target database corresponding to the configuration software comprises the preset database.
7. The apparatus of claim 6, wherein the history data reading module is further configured to invoke a configuration tool to obtain parameter variables of the configuration software to obtain a configuration file corresponding to the configuration software when it is determined that the configuration software does not provide a standard access interface of the self-contained database according to the software identifier;
and in the running process of the configuration software, calling a real-time data acquisition tool to acquire a configuration file, acquiring real-time data corresponding to each parameter variable of the configuration file from the configuration software, and storing the acquired real-time data into a preset database; the target database corresponding to the configuration software comprises a preset database.
8. The apparatus of claim 6, wherein the apparatus further comprises: the table creation module is used for receiving the report design requirement and generating a target table template corresponding to the report to be generated based on the report design requirement.
9. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor implements the steps of the method of any one of claims 1 to 5 when the computer program is executed.
10. 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 steps of the method of any of claims 1 to 5.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010554339.1A CN111680478B (en) | 2020-06-17 | 2020-06-17 | Report generation method, device, equipment and storage medium based on configuration software |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010554339.1A CN111680478B (en) | 2020-06-17 | 2020-06-17 | Report generation method, device, equipment and storage medium based on configuration software |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111680478A CN111680478A (en) | 2020-09-18 |
| CN111680478B true CN111680478B (en) | 2024-04-16 |
Family
ID=72455353
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010554339.1A Active CN111680478B (en) | 2020-06-17 | 2020-06-17 | Report generation method, device, equipment and storage medium based on configuration software |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111680478B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113591448B (en) * | 2021-08-03 | 2024-06-18 | 京东科技控股股份有限公司 | Report generation method, device and storage medium |
| CN114297994A (en) * | 2021-12-23 | 2022-04-08 | 中冶南方工程技术有限公司 | Method, system, device and storage medium for generating parameterized report |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102663209A (en) * | 2012-04-28 | 2012-09-12 | 楚天科技股份有限公司 | Application of configurable statement on rubber plug or aluminium cap cleaning device |
| CN109471890A (en) * | 2018-10-16 | 2019-03-15 | 深圳壹账通智能科技有限公司 | Generation method, terminal device and the medium of report file |
| CN110019297A (en) * | 2017-10-13 | 2019-07-16 | 北京北方华创真空技术有限公司 | A kind of historical data output processing method and device |
| WO2019174191A1 (en) * | 2018-03-15 | 2019-09-19 | 平安科技（深圳）有限公司 | Report data initialization method and apparatus, and computer device and storage medium |
| WO2019178979A1 (en) * | 2018-03-21 | 2019-09-26 | 平安科技（深圳）有限公司 | Method for querying report data, apparatus, storage medium and server |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| KR101977972B1 (en) * | 2011-12-29 | 2019-05-14 | 바이보 랩스, 인크. | Spreadsheet-based programming language adapted for report generation |
-
2020
- 2020-06-17 CN CN202010554339.1A patent/CN111680478B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102663209A (en) * | 2012-04-28 | 2012-09-12 | 楚天科技股份有限公司 | Application of configurable statement on rubber plug or aluminium cap cleaning device |
| CN110019297A (en) * | 2017-10-13 | 2019-07-16 | 北京北方华创真空技术有限公司 | A kind of historical data output processing method and device |
| WO2019174191A1 (en) * | 2018-03-15 | 2019-09-19 | 平安科技（深圳）有限公司 | Report data initialization method and apparatus, and computer device and storage medium |
| WO2019178979A1 (en) * | 2018-03-21 | 2019-09-26 | 平安科技（深圳）有限公司 | Method for querying report data, apparatus, storage medium and server |
| CN109471890A (en) * | 2018-10-16 | 2019-03-15 | 深圳壹账通智能科技有限公司 | Generation method, terminal device and the medium of report file |
Non-Patent Citations (5)
| Title |
|---|
| WinCC自定义数据库的数据查询和报表生成;周小龙;刘芙蓉;范敏毅;;工业控制计算机;20130425(第04期);全文 * |
| 周小龙 ; 刘芙蓉 ; 范敏毅.WinCC自定义数据库的数据查询和报表生成.工业控制计算机.2013,(第04期),第26-27页. * |
| 基于VB的新型报表系统研究;冯国川;宋延民;;自动化技术与应用;20101225(第12期);全文 * |
| 苗进立 ; .iFIX历史数据报表使用经验总结.工业控制计算机.2013,(第04期),第15-18页. * |
| 郭建明 ; 邢晨 ; 刘清 ; .WinCC组态软件中自定义复杂报表的实现.工业控制计算机.2007,(第02期),第4-5页. * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111680478A (en) | 2020-09-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10642913B2 (en) | Intent and bot based query guidance | |
| CN108492005B (en) | Project data processing method and device, computer equipment and storage medium | |
| CN107798030B (en) | Splitting method and device of data table | |
| CN111061475B (en) | Software code generating method, device, computer equipment and storage medium | |
| CN106293891B (en) | Multidimensional investment index monitoring method | |
| CN111738404B (en) | Model training task processing method and device, electronic equipment and storage medium | |
| CN117033249B (en) | Test case generation method and device, computer equipment and storage medium | |
| CN111680478B (en) | Report generation method, device, equipment and storage medium based on configuration software | |
| CN114327374A (en) | Business process generation method and device and computer equipment | |
| CN115237857A (en) | Log processing method and device, computer equipment and storage medium | |
| CN112579705A (en) | Metadata acquisition method and device, computer equipment and storage medium | |
| CN115392501A (en) | Data acquisition method and device, electronic equipment and storage medium | |
| US7716646B2 (en) | Loading a chain of processors from an XML file | |
| CN116431731A (en) | Data asynchronous export method, device, equipment and storage medium thereof | |
| CN115061916B (en) | Method for automatically generating interface test case and related equipment thereof | |
| CN117217684A (en) | Index data processing method and device, computer equipment and storage medium | |
| CN110334905B (en) | Project fault display method, device, computer equipment and storage medium | |
| CN116383787A (en) | Page creation method, page creation device, computer equipment and storage medium | |
| CN110969430B (en) | Suspicious user identification method, suspicious user identification device, computer equipment and storage medium | |
| CN110532533B (en) | Form precision collocation method, device, computer equipment and storage medium | |
| CN116089446A (en) | Optimization control method and device for structured query statement | |
| CN114780648A (en) | Task scheduling method, device, computer equipment, storage medium and program product | |
| CN113157754A (en) | Method, device and equipment for displaying flow form data and storage medium | |
| CN117573199B (en) | Model difference comparison analysis method, device, equipment and medium | |
| CN113867975B (en) | Quick response method and device for command line and computer equipment |
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 |