CN111680478A - Configuration software based report generation method, device, equipment and storage medium - Google Patents
Configuration software based report generation method, device, equipment and storage medium Download PDFInfo
- Publication number
- CN111680478A CN111680478A CN202010554339.1A CN202010554339A CN111680478A CN 111680478 A CN111680478 A CN 111680478A CN 202010554339 A CN202010554339 A CN 202010554339A CN 111680478 A CN111680478 A CN 111680478A
- Authority
- CN
- China
- Prior art keywords
- report
- data
- configuration software
- instruction
- form template
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 82
- 230000006870 function Effects 0.000 claims abstract description 40
- 230000008569 process Effects 0.000 claims abstract description 23
- 238000013461 design Methods 0.000 claims description 34
- 238000004590 computer program Methods 0.000 claims description 25
- 238000013515 script Methods 0.000 abstract description 11
- 230000000903 blocking effect Effects 0.000 abstract description 2
- 238000004364 calculation method Methods 0.000 description 17
- 238000010586 diagram Methods 0.000 description 8
- 238000011161 development Methods 0.000 description 6
- 238000012544 monitoring process Methods 0.000 description 5
- 230000000007 visual effect Effects 0.000 description 5
- 238000004886 process control Methods 0.000 description 4
- 238000003889 chemical engineering Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 239000003208 petroleum Substances 0.000 description 2
- 238000007639 printing Methods 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
- 238000007796 conventional method Methods 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
- 230000003068 static effect Effects 0.000 description 1
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/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 are provided, the method comprises: 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 the 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 form template to acquire initial report data; and receiving a data sorting instruction, and performing 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, the report is obtained after the data is arranged, 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 execution process can avoid the false halt of the configuration software due to blocking.
Description
Technical Field
The present application relates to the field of data statistics, 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, which refers to special software for Data Acquisition and process control (SCADA), and also refers to a software platform and a development environment at the level of a monitoring layer of an automatic control system. The software is also a universal software tool which provides a user with a monitoring function of quickly constructing an industrial automatic control system in a flexible configuration mode. The configuration software is widely applied to the fields of machinery, automobiles, petroleum, chemical engineering, papermaking, water treatment, process control and the like.
A report is a form that dynamically displays data in a format such as a table, a graph, etc. In the conventional method, when the configuration software is used for realizing the report function, the report function is usually realized by matching the Script function of the configuration software with a general table control, however, part of the existing configuration software does not have the function of realizing the report, and for part of the configuration software capable of realizing the report function, the efficiency is usually lower when the Script function of the configuration software is used for realizing data statistical calculation, the configuration software is easy to be jammed and falsely dead, and the configuration software is seriously non-responsive.
Disclosure of Invention
In view of the above, it is necessary to provide a report generating method, device, computer device and storage medium based on configuration software, which have higher statistical computation efficiency.
A report generation method based on configuration software 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 the 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 form template to acquire initial report data;
and receiving a data sorting instruction, and performing 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 query tool reads the historical data corresponding to the report parameters from the target database corresponding to the configuration software, and the calling query tool comprises the following steps:
when the standard access interface provided by the self-contained database by the configuration software is determined according to the software identifier, calling a query tool 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 step of reading the historical data corresponding to the report parameter from the target database corresponding to the configuration software by the query tool includes:
when it is determined that the configuration software does not provide a standard access interface with a database according to the software identifier, calling a configuration tool to obtain parameter variables of the configuration software, and obtaining 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 an embodiment, before loading the preset form template corresponding to the report to be generated, the method further includes: inquiring whether a preset form template corresponding to the report to be generated exists or not, and if so, entering the step of loading the preset form template corresponding to the report to be generated;
when the form template corresponding to the report to be generated is not inquired, the method further comprises the following steps:
receiving a report design requirement, and generating a target form template corresponding to the report to be generated based on the report design requirement;
filling the acquired historical data corresponding to the report parameters into the target form template to acquire initial report data;
and receiving a data sorting instruction, and performing data sorting on the initial report data based on the data sorting instruction to obtain a report.
In one embodiment, the generating a target form 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 data pivot table workbook and a report workbook;
and determining the report style of the report workbook based on the report design requirement, and obtaining the target form template.
In an embodiment, the filling the acquired historical data corresponding to the report parameter into the target table template to obtain initial report data, and the obtaining initial report data includes: filling the acquired 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 form workbook;
the data sorting of the initial report data based on the data sorting instruction is performed to obtain a report, and the data sorting comprises the following steps: and calling a corresponding Excel function based on the data sorting instruction to perform data sorting on the report workbook to obtain the report.
In one embodiment, after obtaining the report, the method further includes: 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, and 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 the historical data corresponding to the report parameters from the 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 acquiring 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.
A computer device comprises a memory and a processor, wherein the memory stores a computer program, and the processor realizes the steps of the report generation method based on the configuration software when executing the computer program.
A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the above-mentioned configuration software-based report generation method.
According to the report generation method, device, equipment and storage medium based on the configuration software, when a report generation instruction is received, based on report parameters carried by the report generation instruction, a query tool is called to obtain corresponding historical data from a database corresponding to the configuration software, meanwhile, a preset table template corresponding to a report to be generated is loaded, and the query tool fills the obtained historical data into the preset table template to obtain initial report data; and then, performing data sorting on the initial report data based on the received data sorting instruction to obtain a report. The method reads the required historical data from the target database corresponding to the configuration software, fills the required historical data into the preset form template corresponding to the report to be generated, and combines the data sorting instruction to realize the sorting of the report data and obtain the report, and the process is separated from the configuration software, does not depend on the function provided by the configuration software and the limitation of the script, and can avoid the false halt of the configuration software in the execution process.
Drawings
FIG. 1 is a diagram of an embodiment of an application environment for a configuration software based report generation method;
FIG. 2 is a flowchart illustrating a report generation method based on configuration software according to an embodiment;
FIG. 3 is a schematic flow chart illustrating a report generation method based on configuration software according to another embodiment;
FIG. 4 is a schematic flow chart illustrating an embodiment of invoking a query tool to read historical data corresponding to report parameters from a target database corresponding to configuration software;
FIG. 5 is a flowchart illustrating a report generation method based on configuration software according to another embodiment;
FIG. 6 is a flowchart illustrating a method for generating reports based on configuration software according to an embodiment;
FIG. 7 is a diagram of a report in an embodiment;
FIG. 8 is a block diagram illustrating an embodiment of a report generator based on configuration software;
FIG. 9 is a diagram illustrating an internal structure of a computer device according to an embodiment.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the present application is described in further detail below with reference to the accompanying drawings and embodiments. It should be understood that the specific embodiments described herein are merely illustrative of the present application and are not intended to limit the present application.
The report generation method based on the configuration software can be applied to the application environment shown in fig. 1. Wherein the terminal 102 communicates with the server 104 via a network. When receiving a report generation instruction, the server 104 acquires corresponding historical data from a database corresponding to the configuration software by calling an inquiry tool based on report parameters carried by the report generation instruction, and loads a preset form template corresponding to a report to be generated at the same time, wherein the inquiry tool fills the acquired historical data into the preset form template to obtain initial report data; and then, performing 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, smart phones, tablet computers, and portable wearable devices, and the server 104 may be implemented by an independent server or a server cluster formed by a plurality of servers.
In an embodiment, as shown in fig. 2, a report generation method based on configuration software is provided, which is described by taking the method as an example applied to the server in fig. 1, and includes steps S210 to S250.
Step S210, receiving a report generation instruction, wherein the report generation instruction carries report parameters of the report to be generated.
The report generation instruction can be an instruction sent by a user and used for instructing the server to generate the report. The report parameters comprise parameters required in the report to be generated; in one embodiment, the report parameters include a portion of the parameters in the data obtained in the configuration software. Report [ forms for reporting to the higher levels ] reports the table of the cases to the upper level. In brief, the following: the report forms are data dynamically displayed in forms such as tables and icons, and can be expressed by a formula as follows: "report" is a diverse format + dynamic data ".
Step S220, a query tool is called to read the historical data corresponding to the report parameters from the target database corresponding to the configuration software.
Configuration software, also called configuration monitoring system software, refers to special software for data acquisition and process control, and also refers to a software platform and a development environment at the level of a monitoring layer of an automatic control system. The configuration software is widely applied to the fields of machinery, automobiles, petroleum, chemical engineering, papermaking, water treatment, process control and the like. In one embodiment, the configuration software is SCADA (Supervisory Control And Data Acquisition) software. In one embodiment, the configuration software may be Siemens Wincc, Wonderware Intouch, Citect, Subsonic configuration King, and the like. In one embodiment, the configuration software used in this embodiment provides the OPC DA Server function. 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 the configuration software, and in one embodiment, the target database may be a database of the configuration software itself, such as an InSQL database of the project itself using WonderWare inner outlet SCADA (one of SCADA software). In another embodiment, there may be another database connected to the configuration software, in which the 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 and allows external access, the target database is the self-contained database of the configuration software; in this embodiment, before the invoking the query tool reads the historical data corresponding to the report parameter from the target database corresponding to the configuration software, the method further includes: and calling a 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 needs to be constructed, and data is acquired from the database of the configuration software in advance through a data acquisition tool and stored in the target database, or real-time data is acquired while the configuration software is running through a real-time data acquisition tool and stored in the target database.
The query tool is used for acquiring historical data corresponding to report parameters from a database (marked as a target database in the embodiment) for storing historical data of the configuration software; in an embodiment, the report generation instruction further includes a historical time period corresponding to the report parameter of the report to be generated, and further, in this embodiment, the query tool is invoked to obtain historical data corresponding to the historical time period according to the report generation instruction. In this embodiment, the query tool obtains the corresponding historical data according to the historical time period specified in the report generation instruction, and can obtain the corresponding historical data according to the needs of the user, so as to be used for making the report. In one embodiment, the query tool is an application with a report display interface or a net, ActiveX control. Net is an operation platform which allows people to construct various application modes on the operation platform, so that people can acquire information from websites in a diversified and maximum way in a simple way as much as possible, thereby solving the cooperative work among websites and breaking the barriers among computers, equipment, websites, various major institutions and the industry; ActiveX controls are Microsoft's name for a range of strategic object-oriented programming technologies and tools, the primary technology being the Component Object Model (COM). In a specific embodiment, the query tool can be developed by using Visual Studio, and the historical data corresponding to the report parameters is queried from the target database through the database query syntax according to the report types and the report parameters of the report to be generated. In one embodiment, the report parameters include a report template name, a start time, an end time, or a report type, among others. Wherein, Visual Studio (Microsoft Visual Studio is a development kit series product; includes most tools needed in the whole software life cycle, such as UML tool, code management tool, Integrated Development Environment (IDE) and so on.
In this embodiment, after the report generation instruction is received, the query tool is called according to the report generation instruction to obtain corresponding historical data for making a subsequent report.
And step S230, loading a preset form template corresponding to the report to be generated.
The preset form template is a form template corresponding to a preset report and can be a form template formed by any type of forms.
In a specific embodiment, the loading of the preset form template corresponding to the report to be generated includes: and loading a preset Excel form template corresponding to the report to be generated. In this embodiment, a form template is preset for a report to be generated, that is, a preset Excel form template, and after a report generation instruction is received, a corresponding preset Excel form template is loaded according to the report generation instruction. Microsoft Excel is a piece of spreadsheet software written by Microsoft (Microsoft) for computers that use windows (a suite of operating systems developed by Microsoft) and the Apple Macintosh (Macintosh computer) operating system. Has intuitive interface, excellent calculation function and graph tool. In the embodiment, the Excel table is used as the table template of the report, the Excel table has rich calculation functions and diagram tools, the function of the Excel can be used for realizing the diversified functions of the report, the realization of complex calculation of the report can be realized, and even people without software development ability can realize complex calculation by using the Excel calculation formula function.
In one embodiment, a plurality of form templates of the report are stored in the server, the form templates can be distinguished by setting form template identifiers for the form templates, and when a report generation instruction is received, a corresponding preset Excel form template is loaded according to a target form template identifier carried in the report generation instruction.
Step S240, filling the historical data corresponding to the obtained report parameters into a preset form template, and obtaining initial report data.
The report parameters may include a plurality of parameter data, and after the preset form is loaded, each report parameter is respectively filled into the corresponding position of the preset form template, so that the parameter data required by the unprocessed report can be obtained, which is recorded as the initial report data in this embodiment.
In the embodiment, corresponding historical data are obtained from the configuration software according to the requirements of the user, and then the historical data are filled into a preset form template established by an Excel form to obtain initial data report data, so that the complex statistical and calculation requirements can be realized by utilizing the calculation function of the Excel form, and the function which cannot be realized by the Excel formula can be realized by using a macro script in the Excel; that is, the report generation method based on the configuration software in this embodiment can meet the statistical computation requirement in the more complex report.
And step S250, receiving a data sorting instruction, and performing data sorting on the initial report data based on the data sorting instruction to obtain a report.
The data sorting instruction refers to an instruction initiated by a user for sorting the generated initial report data to generate a report meeting the requirements of the user; the data sorting instruction carries instructions of all operations required in the process of sorting the initial report data into the report, for example, the instructions include instructions of a calculation function and the like.
In one embodiment, after the report is obtained, the method further comprises the following steps: and receiving an operation instruction aiming at the report, and executing corresponding operation on the report according to the operation instruction. The operation instruction for the report comprises a saving instruction, a display instruction, an export instruction, a print preview instruction or a print instruction and the like for the report; after the report is generated, the user can select to perform operations such as saving, displaying, exporting, print previewing or printing on the report, and the server executes the operations (saving, displaying, exporting, print previewing or printing and the like) corresponding to the operation instructions on the report when receiving the corresponding operation instructions. In a specific embodiment, after obtaining the report, the method further comprises: and receiving a report display operation instruction, and displaying the report according to the operation instruction. And after the initial report data are sorted based on the data sorting requirements to obtain the report, displaying the report, and finishing the report work. In an embodiment, the report can 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 configuration software-based report generation method may be implemented in different forms, for example, in an embodiment, the configuration software-based report generation method may be implemented by an independent program, may be implemented by an independent control embedded in configuration software, and may be implemented by invoking a corresponding dynamic chain. It is understood that the above report generation method based on configuration software can be implemented in other forms in other embodiments.
According to the report generation method based on the configuration software, when a report generation instruction is received, based on report parameters carried by the report generation instruction, a query tool is called to obtain corresponding historical data from a database corresponding to the configuration software, meanwhile, a preset table template corresponding to a report to be generated is loaded, and the query tool fills the obtained historical data into the preset table template to obtain initial report data; and then, performing data sorting on the initial report data based on the received data sorting instruction to obtain a report. The method reads the required historical data from the target database corresponding to the configuration software, fills the required historical data into the form template corresponding to the report to be generated, and combines the data sorting instruction to realize sorting of the report data and obtain the report, and the process is separated from the configuration software, does not depend on the function provided by the configuration software and the limitation of the script, and can avoid the blocking and the false death of the configuration software in the execution process.
In one embodiment, as shown in fig. 3, before receiving the report generation instruction, the method further includes: step S310, acquiring a software identifier of configuration software; in this embodiment, invoking the query tool to read the historical data corresponding to the report parameters from the target database corresponding to the configuration software includes step S320: when the standard access interface provided by the configuration software with the database is determined according to the software identifier, calling a query tool to read historical data corresponding to report parameters from the 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 the unique identifier of the configuration software, and only one configuration software can be determined by the software identifier of the configuration software; it can then be determined whether the configuration software has a standard access interface that provides its own database.
When the configuration software provides the 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 at the moment, 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 invoking of the query tool reads the historical data corresponding to the report parameter from the target database corresponding to the configuration software, the method further includes: and calling a 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, when determining whether the configuration software provides a self-contained database accessible from the outside through the software identifier of the configuration software, that is, when providing a standard data access interface of the self-contained database, 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 it is not necessary to additionally install a database for storing data of the state software, so that space can be saved.
In another embodiment, when the software identifier of the configuration software determines that the configuration software does not provide a standard access interface with the database, a target database for storing the data of the configuration software needs to be constructed. In one embodiment, the real-time data may be obtained while the configuration software is running by calling a real-time data obtaining tool, and stored in the target database. In another embodiment, the required data may also be obtained from the configuration software by other data obtaining tools and stored in the target database.
In another embodiment, as shown in fig. 4, invoking a query tool to read the historical data corresponding to the report parameters from the target database corresponding to the configuration software includes: 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, calling a configuration tool to obtain the parameter variable of the configuration software, and generating a configuration file corresponding to the configuration software according to the parameter variable. Step S420, in the running process of the configuration software, calling a real-time data acquisition tool to acquire a configuration file, configuring real-time data corresponding to parameter variables in the 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, a query tool is called to read the historical data corresponding to the report parameters from the 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 can be developed through visual studio, and according to a preset configuration file, the real-time data of the configuration software is read through an OPC Client (OPC Client) while the configuration software is running, and is stored into a target database according to the data conversion rate exceeding a threshold value. In one embodiment, the real-time data acquisition tool may be an application running in the background,. net control, or ActiveX control. In one embodiment, the real-time data acquisition tool writes the read real-time data to the target database on a storage interval condition (e.g., which may be a rate of change exceeding 1%). And the real-time data acquisition tool reads real-time data in the running process of the configuration software, stores the target database, and can read historical data required by the report to be generated from the target database when a report generation instruction is received. 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; specifically, the configuration tool may obtain parameter variables of the configuration software and arrange the parameter variables to generate a corresponding configuration file for storage, and in a subsequent use process, the real-time data obtaining tool may obtain corresponding real-time data from the configuration software according to the configuration file for storage. The obtained parameter variables may be parameter variables correspondingly monitored by all the configuration software, or parameter variables determined according to user requirements, that is, part of the parameter variables monitored by the configuration software may be the parameter variables; in one embodiment, the configuration tool reads the variable access path defined by the configuration software, selects the variables to be used in the report, and stores the variables as the configuration file. In one embodiment, the configuration tool can be developed and obtained through Visual Studio, parameter variable access paths defined by configuration software are read through an OPC Client, variables required to be used in a report are selected and stored as configuration files. It will be appreciated that in other embodiments, the configuration tool may be developed by other development tools.
In one embodiment, when building a preset database, redundancy of the data itself may be used or a redundant data function may be provided for the preset database. In a specific embodiment, a MySQL database is used as a preset database, MySQL has three implementation methods, and the SQLServer can directly use redundancy or scheduling functions.
In this embodiment, the configuration software is a standard access interface provided with a database, the real-time data of the configuration software is acquired while the configuration software is running through the real-time data acquisition tool, and is stored in a preset database (target database), and when a report generation instruction is received, the query tool is invoked to acquire historical data required by the report generation instruction from the preset database. Due to the adoption of the configuration tool and the real-time data acquisition tool, the report generation method based on the configuration software in the embodiment can be applied to various different types of configuration software (including configuration software provided with a database access interface and configuration software not provided with the database access interface), so that the report generation method based on the configuration software has stronger universality.
In an embodiment, as shown in fig. 5, before loading the preset form template corresponding to the report to be generated, the method further includes step S510: and inquiring whether a preset form template corresponding to the report to be generated exists or not, and if so, entering a step of loading the preset form template corresponding to the report to be generated. In this embodiment, when the preset form template corresponding to the report to be generated is not queried, the method further includes steps S520 to S540.
And step S520, receiving report design requirements, and generating a target form template corresponding to the report to be generated based on the report design requirements.
The report design requirement refers to the design requirement of a user on a form template of a report, and the report design requirement can comprise the requirements of parameters, formats and the like required by the form template. Based on report design requirements, a corresponding form template can be generated. In this embodiment, if the report to be generated corresponding to the report generation instruction does not find the corresponding preset form template, the form template corresponding to the report to be generated is created first according to the report design requirement input by the user, and is marked as the target form template in this embodiment, and the obtained historical data may be subsequently filled into the target form template to obtain the initial report data.
Step S530, the historical data corresponding to the acquired report parameters is filled into a target form template, and initial report data is acquired.
The process of filling the historical data corresponding to the acquired report parameters into the target form template is similar to the process of filling the historical data into the preset form template, and the initial report data can be acquired by correspondingly filling various parameters, variables and the like in the report parameters into the target form template.
And S540, receiving a data sorting instruction, and performing data sorting on the initial report data based on the data sorting instruction to obtain a report.
And after the initial report data is obtained, receiving a data sorting instruction sent by a user, and performing data sorting on the initial report data according to the data sorting instruction to obtain a report meeting the user requirement. And after the historical data corresponding to the report parameters are stored in the preset form template, the process of sorting the obtained initial report data is the same.
In this embodiment, if a report generation instruction for generating a report to be generated is received and a preset form template corresponding to the report to be generated is not found, a target form template is created according to a report design requirement sent by a user, and then the obtained historical data is filled into the target form template to obtain initial report data for subsequent arrangement to generate the report.
Further, in an embodiment, generating a form template corresponding to a report to be generated based on report design requirements includes: creating an Excel table, wherein the Excel table comprises a data pivot table workbook and a report workbook; and determining the report style of the report workbook based on the report design requirement, and obtaining the target form template.
In an embodiment, the created target form template is a created Excel form, and the Excel form at least comprises a pivot table workbook and a report workbook; the data pivot table workbook and the SourceData workbook are used for filling the acquired historical data; and the Report workbook are used for presenting the generated Report styles and data. The report design requirement limits the form style of the report workbook in the Excel form, and after the report design requirement is received, the form style of the report workbook in the Excel form is designed according to the report design requirement, and the target form template is obtained. The target form template adopts an Excel form template, initial report data is obtained after historical data is filled in subsequently, the initial report data is arranged to obtain a report, the data arrangement can be realized by utilizing the Excel form function to obtain the report, the calculation function of Excel is used to realize complex calculation, and people without software development ability can realize the complex calculation by utilizing the Excel calculation formula function. For functions which cannot be realized by the Excel formula, the functions can be realized by using macro scripts in the Excel, and the universality is higher.
In one embodiment, the step of filling the obtained historical data corresponding to the report parameters into an Excel form template to obtain initial report data includes: filling historical data corresponding to the acquired report parameters into a data perspective table workbook; reading corresponding data from the pivot table workbook and filling the corresponding data into the report form workbook; data arrangement is carried out on the initial report data based on the data arrangement instruction, and a report is obtained, wherein the data arrangement instruction comprises the following steps: and calling the Excel function based on the data sorting instruction to perform data sorting on the report workbook to obtain a report.
In this embodiment, the historical data corresponding to the report parameters of the report to be generated is obtained and stored in the pivot table workbook of the preset Excel form template, and when data arrangement is performed on the initial report data based on the data arrangement instruction, the data is read from the pivot table workbook and is filled in 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 an embodiment, as shown in fig. 6, the report generation method based on the configuration software includes the following steps (in this embodiment, an Excel table is taken as a preset table template as an example):
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, if so, calling a query tool (which can be an application program with a report display interface or a net or an ActiveX control) to read historical data corresponding to report parameters carrying a report to be generated in a report generation instruction from the self-contained database of the configuration software when receiving the report generation instruction. And if the configuration software is determined not to provide the standard access interface with the database according to the software identifier, 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, calling a real-time data acquisition tool to read the configuration file generated by the configuration tool, acquiring real-time data corresponding to each parameter variable of the configuration file from the configuration software, and storing the real-time data into a preset database (such as SQLServer, Oracle, MySQL and the like). And when a report generation instruction is received, calling a query tool to read the historical data corresponding to the report parameters of the report to be generated, which are carried in the report generation instruction, from a preset database.
And judging whether a preset Excel form template corresponding to the report to be generated exists or not, if so, filling the read historical data into a 'SourceData' working table of the preset Excel form template, and obtaining initial report data. If the preset Excel form template corresponding to the Report to be generated does not exist, receiving Report design requirements, and creating an Excel form corresponding to the Report to be generated according to the Report design requirements, wherein the Excel form comprises a 'SourceData' working table and a 'Report' working table; and determining a Report worksheet based on Report design requirements, and obtaining a target Excel form template. And then storing the read historical data into the target Excel form template to obtain initial report data.
Further, a data sorting instruction is received, data filled in a 'SourceData' worksheet of the Excel form filled with the historical data are read into a 'Report' worksheet, and a corresponding function of the Excel is called based on the data sorting instruction to realize sorting of the initial Report data so as to obtain the Report. And further, displaying the report through a query tool. Fig. 7 is a diagram illustrating a report according to an embodiment.
In the embodiment, the method can realize the report function of the actual project with high efficiency aiming at different types of configuration software, thereby greatly improving the project execution efficiency, saving the cost and more completely realizing the requirement of customers. The method is completely separated from the configuration software and does not depend on the function of the configuration software and the limitation of a script system; and a script system of configuration software is not used, software development is not required to be carried out according to the syntax of different configuration software, and the project implementation difficulty is reduced. The calculation function of the Excel is used for realizing complex calculation, and a person without software development ability can realize the complex calculation by using the Excel calculation formula function. For functions which cannot be realized by an Excel formula, the functions can be realized by macro scripts in the Excel, and the method has strong universality.
It should be understood that although the various steps in the flow charts of fig. 2-6 are shown in order as indicated by the arrows, the steps are not necessarily performed in order as indicated by the arrows. The steps are not performed in the exact order shown and described, and may be performed in other orders, unless explicitly stated otherwise. Moreover, at least some of the steps in fig. 2-6 may include multiple steps or multiple stages, which are not necessarily performed at the same time, but may be performed at different times, which are not necessarily performed in sequence, but may be performed in turn or alternately with other steps or at least some of the other steps.
In an embodiment, as shown in fig. 8, there is provided a report generating apparatus based on configuration software, including: the system comprises an instruction receiving module 810, a historical data reading module 820, a template loading module 830, a data filling module 840 and a data sorting module 850, wherein:
the instruction receiving module 810 is configured to receive a report generation instruction, where the report generation instruction carries a report parameter of a report to be generated;
a historical data reading module 820, configured to invoke 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 830 is configured to load a preset form template corresponding to the report to be generated;
the data filling module 840 is used for receiving a data sorting instruction, and filling historical data corresponding to the acquired report parameters into a preset table template based on the data sorting instruction to acquire initial report data;
and the data sorting module 850 is used for performing data sorting on the initial report data based on the data sorting instruction to obtain a report.
When the report generation device based on the configuration software receives a report generation instruction, based on report parameters carried by the report generation instruction, acquiring corresponding historical data from a database corresponding to the configuration software by calling an inquiry tool, loading a preset form template corresponding to a report to be generated, and filling the acquired historical data into the preset form template by the inquiry tool to obtain initial report data; and then, performing data sorting on the initial report data based on the received data sorting instruction to obtain a report. The method reads the required historical data from the target database corresponding to the configuration software, fills the required historical data into the preset form template corresponding to the report to be generated, and combines the data sorting instruction to realize the sorting of the report data and obtain the report, and the process is separated from the configuration software, does not depend on the function provided by the configuration software and the limitation of the script, and can avoid the false halt of the configuration software in the execution process.
In one embodiment, the above apparatus further comprises: the software identifier acquisition module is used for acquiring a software identifier of the configuration software; in this embodiment, the historical data reading module 820 is configured to, when it is determined that the configuration software provides the standard access interface of the self-contained database according to the software identifier, invoke a query tool to read the 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 a self-contained database.
Further, in an embodiment, the historical data reading module 820 is further configured to, when it is determined that the configuration software does not provide a standard access interface with a database according to the software identifier, invoke a configuration tool to obtain a parameter variable of the configuration software, and obtain 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 parameter variables 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 above apparatus further comprises: the template query module is used for querying whether a preset form template corresponding to the report to be generated exists or not, and if so, the template query module jumps to the template loading module to execute the step of loading the preset Excel form template corresponding to the report to be generated; in this embodiment, the apparatus further includes: the form creating module is used for receiving report design requirements and generating a target form template corresponding to the report to be generated based on the report design requirements; in this embodiment, the data filling module is further configured to fill the historical data corresponding to the acquired report parameter into the target form template, so as to obtain initial report data; and the data sorting module is used for receiving the data sorting instruction, and performing data sorting on the initial report data based on the data sorting instruction to obtain a report.
In one embodiment, the form creation module is specifically configured to create an Excel form, where the Excel form includes a pivot table workbook and a report workbook; and the form design module is used for determining the report form style of the report form workbook based on the report form design requirement.
In one embodiment, the data stuffing module is specifically configured to: filling historical data corresponding to the acquired report parameters into a data perspective table workbook; reading corresponding data from the pivot table workbook and filling the corresponding data into the report form workbook; and the data sorting module is used for calling a corresponding Excel function based on the data sorting instruction to perform data sorting on the report workbook and obtain the report.
In one embodiment, the apparatus further includes an operation instruction receiving module, configured to receive an operation instruction for the report; and the report presentation module is used for executing corresponding operation on the report according to the operation instruction.
For the specific limitations of the report generation device based on the configuration software, reference may be made to the above limitations of the report generation method based on the configuration software, which are not described herein again. All modules in the report generation device based on the configuration software can be completely or partially realized through software, hardware and a combination thereof. The modules can be embedded in a hardware form or independent from a processor in the computer device, and can also be stored in a memory in the computer device in a software form, so that the processor can call and execute operations corresponding to the modules.
In one embodiment, a computer device is provided, which may be a server, and its internal structure diagram 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 comprises a nonvolatile storage medium and an internal memory. The non-volatile storage medium stores an operating system, a computer program, and a database. The internal memory provides an environment for the operation of an operating system and computer programs in the non-volatile storage medium. The database of the computer device is used for storing data such as preset form templates, configuration files 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 is executed by a processor to realize a report generation method based on configuration software.
Those skilled in the art will appreciate that the architecture shown in fig. 9 is merely a block diagram of some of the structures associated with the disclosed aspects and is not intended to limit the computing devices to which the disclosed aspects apply, as particular computing devices may include more or less components than those shown, or may combine certain 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 a computer program stored therein, the processor implementing the following steps when executing the computer program:
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 the historical data corresponding to the report parameters from the target database corresponding to the configuration software; loading a preset form template corresponding to a report to be generated; filling historical data corresponding to the acquired report parameters into a preset form template to acquire initial report data; and receiving a data sorting instruction, and performing 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 with a database according to the software identification, calling a query tool to read historical data corresponding to report parameters from the database; 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 not to provide a standard access interface with a database according to the software identification, calling a configuration tool to obtain parameter variables of the configuration software, and obtaining 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 form template corresponding to the report to be generated exists or not, and if so, entering a step of loading the preset form template corresponding to the report to be generated; receiving a report design requirement, and generating a target form template corresponding to a report to be generated based on the report design requirement; filling historical data corresponding to the acquired report parameters into a target form template to acquire initial report data; and receiving a data sorting instruction, and performing 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 form, wherein an Excel form template comprises a data pivot table workbook and a report workbook; the report style of the report workbook is determined based on the report design requirements.
In one embodiment, the processor, when executing the computer program, further performs the steps of: filling historical data corresponding to the acquired report parameters into a data perspective table workbook; reading corresponding data from the pivot table workbook and filling the corresponding data into the report form workbook; and calling a corresponding Excel function based on the data sorting instruction to perform data sorting on the report workbook to obtain a report.
In one embodiment, the processor, when executing the computer program, further performs the steps of: receiving an operation instruction aiming at the 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 the historical data corresponding to the report parameters from the target database corresponding to the configuration software; loading a preset form template corresponding to a report to be generated; filling historical data corresponding to the acquired report parameters into a preset form template to acquire initial report data; and receiving a data sorting instruction, and performing 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 with a database according to the software identification, calling a query tool to read historical data corresponding to report parameters from the database; 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 not to provide a standard access interface with a database according to the software identification, calling a configuration tool to obtain parameter variables of the configuration software, and obtaining 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 parameter variables in the configuration file from the configuration software, and storing the acquired real-time data in 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 form template corresponding to the report to be generated exists or not, and if so, entering a step of loading the preset form template corresponding to the report to be generated; receiving a report design requirement, and generating a target form template corresponding to a report to be generated based on the report design requirement; filling historical data corresponding to the acquired report parameters into a target form template to acquire initial report data; and receiving a data sorting instruction, and performing 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 data pivot table workbook and a report workbook; the report style of the report workbook is determined based on the report design requirements.
In one embodiment, the computer program when executed by the processor further performs the steps of: filling historical data corresponding to the acquired report parameters into a data perspective table workbook; reading corresponding data from the pivot table workbook and filling the corresponding data into the report form workbook; and calling a corresponding Excel function based on the data sorting instruction to perform data sorting on the report workbook to obtain a report.
In one embodiment, the computer program when executed by the processor further performs the steps of: receiving an operation instruction aiming at the report; and executing corresponding operation on the report according to the operation instruction.
It will be understood by those skilled in the art that all or part of the processes of the methods of the embodiments described above can be implemented by hardware instructions of a computer program, which can be stored in a non-volatile computer-readable storage medium, and when executed, can include the processes of the embodiments of the methods described above. Any reference to memory, storage, database or other medium used in the embodiments provided herein can include at least one of non-volatile and volatile memory. Non-volatile Memory may include Read-Only Memory (ROM), magnetic tape, floppy disk, flash Memory, optical storage, or the like. Volatile Memory can include Random Access Memory (RAM) or external cache Memory. By way of illustration and not limitation, RAM can take many forms, such as Static Random Access Memory (SRAM) or Dynamic Random Access Memory (DRAM), among others.
The technical features of the above embodiments can be arbitrarily combined, and for the sake of brevity, all possible combinations of the technical features in the above embodiments are not described, but should be considered as the scope of the present specification as long as there is no contradiction between the combinations of the technical features.
The above-mentioned embodiments only express several embodiments of the present application, and the description thereof is more specific and detailed, but not construed as limiting the scope of the invention. It should be noted that, for a person skilled in the art, several variations and modifications can be made without departing from the concept of the present application, which falls within the scope of protection of the present application. Therefore, the protection scope of the present patent shall be subject to the appended claims.
Claims (10)
1. A report generation method based on configuration software is characterized by comprising 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 the 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 form template to acquire initial report data;
and receiving a data sorting instruction, and performing data sorting on the initial report data based on the data sorting instruction to obtain a report.
2. The method of claim 1, prior to receiving report generation instructions, further comprising:
acquiring a software identifier of configuration software;
the calling query tool reads the historical data corresponding to the report parameters from the target database corresponding to the configuration software, and the calling query tool comprises the following steps:
when the standard access interface provided by the self-contained database by the configuration software is determined according to the software identifier, calling a query tool 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.
3. The method of claim 2, wherein the invoking the query tool to read the historical data corresponding to the report parameters from the target database corresponding to the configuration software comprises:
when it is determined that the configuration software does not provide a standard access interface with a database according to the software identifier, calling a configuration tool to obtain parameter variables of the configuration software, and obtaining 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 parameter variables 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 the historical data corresponding to the report parameters from the preset database; the target database corresponding to the configuration software comprises the preset database.
4. The method of claim 1, further comprising, prior to loading the preset form template: inquiring whether a preset form template corresponding to the report to be generated exists or not, and if so, entering a step of loading the preset form template corresponding to the report to be generated;
when the preset form template corresponding to the report to be generated is not inquired, the method further comprises the following steps:
receiving a report design requirement, and generating a target form template corresponding to the report to be generated based on the report design requirement;
filling the acquired historical data corresponding to the report parameters into the target form template to acquire initial report data;
and receiving a data sorting instruction, and performing data sorting on the initial report data based on the data sorting instruction to obtain a report.
5. The method according to claim 4, wherein the generating a target form template corresponding to the report to be generated based on the report design requirement comprises:
creating an Excel table, wherein the Excel table comprises a data pivot table workbook and a report workbook;
and determining the report style of the report workbook based on the report design requirement, and obtaining the target form template.
6. The method of claim 5, wherein:
the step of filling the acquired historical data corresponding to the report parameters into the target form template to acquire initial report data, which includes: filling the acquired 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 form workbook;
the data sorting of the initial report data based on the data sorting instruction is performed to obtain a report, and the data sorting comprises the following steps: and calling a corresponding Excel function based on the data sorting instruction to perform data sorting on the report workbook to obtain the report.
7. The method according to any one of claims 1 to 6, 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.
8. A report generation device based on configuration software, the device comprising:
the instruction receiving module is used for receiving a report generation instruction, and 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 the historical data corresponding to the report parameters from the 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 acquiring 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.
9. A computer device comprising a memory and a processor, the memory storing a computer program, characterized in that the processor, when executing the computer program, implements the steps of the method of any of claims 1 to 7.
10. A computer-readable storage medium, on which a computer program is stored, which, when being executed by a processor, carries out the steps of the method of any one of claims 1 to 7.
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 true CN111680478A (en) | 2020-09-18 |
| CN111680478B 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) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113591448A (en) * | 2021-08-03 | 2021-11-02 | 京东科技控股股份有限公司 | Report generation method and device and storage medium |
| CN114077608A (en) * | 2021-11-23 | 2022-02-22 | 深圳供电局有限公司 | A report retrieval method and system based on SCADA historical data |
| CN114297994A (en) * | 2021-12-23 | 2022-04-08 | 中冶南方工程技术有限公司 | Method, system, device and storage medium for generating parameterized report |
Citations (6)
| 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 |
| US20130290822A1 (en) * | 2011-12-29 | 2013-10-31 | Bibo Labs, Inc. | Spreadsheet-based programming language adapted for report generation |
| 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 |
-
2020
- 2020-06-17 CN CN202010554339.1A patent/CN111680478B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130290822A1 (en) * | 2011-12-29 | 2013-10-31 | Bibo Labs, Inc. | Spreadsheet-based programming language adapted for report generation |
| 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 |
|---|
| 冯国川;宋延民;: "基于VB的新型报表系统研究", 自动化技术与应用, no. 12, 25 December 2010 (2010-12-25) * |
| 周小龙;刘芙蓉;范敏毅: "WinCC自定义数据库的数据查询和报表生成" * |
| 周小龙;刘芙蓉;范敏毅;: "WinCC自定义数据库的数据查询和报表生成", 工业控制计算机, no. 04, 25 April 2013 (2013-04-25), pages 26 - 27 * |
| 苗进立;: "iFIX历史数据报表使用经验总结", no. 04, pages 15 - 18 * |
| 郭建明;邢晨;刘清;: "WinCC组态软件中自定义复杂报表的实现", no. 02, pages 4 - 5 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN113591448A (en) * | 2021-08-03 | 2021-11-02 | 京东科技控股股份有限公司 | Report generation method and device and storage medium |
| CN114077608A (en) * | 2021-11-23 | 2022-02-22 | 深圳供电局有限公司 | A report retrieval method and system based on SCADA historical data |
| CN114297994A (en) * | 2021-12-23 | 2022-04-08 | 中冶南方工程技术有限公司 | Method, system, device and storage medium for generating parameterized report |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111680478B (en) | 2024-04-16 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN110377851B (en) | Method and device for realizing multi-stage linkage drop-down frame and computer equipment | |
| CN111680478B (en) | Report generation method, device, equipment and storage medium based on configuration software | |
| CN107798030B (en) | Splitting method and device of data table | |
| CN111026777A (en) | Entity class code generation method and device, computer equipment and storage medium | |
| CN112363695B (en) | PMML file and integration method of runtime environment and industrial software thereof | |
| CN111158715B (en) | Gray release control method and system | |
| CN107273104B (en) | Processing method and device for configuration data structure | |
| CN110362309B (en) | Front-end project development method, device, equipment and computer readable storage medium | |
| CN112090079B (en) | Game task running method and device, computer equipment and storage medium | |
| CN112765023A (en) | Test case generation method and device | |
| CN111061475A (en) | Software code generation method and device, computer equipment and storage medium | |
| CN112363694B (en) | Integration method of FMU file, solver running environment and industrial software | |
| CN112148700A (en) | Log data processing method and device, computer equipment and storage medium | |
| US7814123B2 (en) | Management of component members using tag attributes | |
| CN108255735B (en) | Associated environment testing method, electronic device and computer readable storage medium | |
| CN112001707A (en) | Business workflow generation method and system based on business data | |
| CN109542962B (en) | Data processing method, data processing device, computer equipment and storage medium | |
| CN112579705A (en) | Metadata acquisition method and device, computer equipment and storage medium | |
| EP4462276A1 (en) | Method and apparatus for generating association viewing model, and computer device and storage medium | |
| CN107832374A (en) | Construction method, electronic installation and the storage medium in standard knowledge storehouse | |
| CN110728118A (en) | Cross-data-platform data processing method, device, equipment and storage medium | |
| CN113971124B (en) | Sub-application debugging method and device, computer equipment and storage medium | |
| CN115061916B (en) | Method for automatically generating interface test case and related equipment thereof | |
| EP3722966A1 (en) | Enterprise resource planning system and supervision method of sql queries in such a system | |
| CN108681426B (en) | Method and system for performing feature processing on data |
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 |