CN111581230B - Method, equipment and medium for generating data analysis report - Google Patents
Method, equipment and medium for generating data analysis report Download PDFInfo
- Publication number
- CN111581230B CN111581230B CN202010241469.XA CN202010241469A CN111581230B CN 111581230 B CN111581230 B CN 111581230B CN 202010241469 A CN202010241469 A CN 202010241469A CN 111581230 B CN111581230 B CN 111581230B
- Authority
- CN
- China
- Prior art keywords
- analysis report
- data analysis
- data
- identification information
- report template
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
- 238000007405 data analysis Methods 0.000 title claims abstract description 157
- 238000000034 method Methods 0.000 title claims abstract description 59
- 238000004364 calculation method Methods 0.000 claims description 5
- 230000006870 function Effects 0.000 description 9
- 230000006872 improvement Effects 0.000 description 8
- 238000004590 computer program Methods 0.000 description 7
- 238000010586 diagram Methods 0.000 description 6
- 238000005516 engineering process Methods 0.000 description 5
- 230000008569 process Effects 0.000 description 5
- 238000012545 processing Methods 0.000 description 5
- 238000004458 analytical method Methods 0.000 description 4
- 230000005540 biological transmission Effects 0.000 description 2
- 238000012217 deletion Methods 0.000 description 2
- 230000037430 deletion Effects 0.000 description 2
- 238000004519 manufacturing process Methods 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 230000003287 optical effect Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 230000001413 cellular effect Effects 0.000 description 1
- 230000008859 change Effects 0.000 description 1
- 238000004891 communication Methods 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000005055 memory storage Effects 0.000 description 1
- 229920001296 polysiloxane Polymers 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 239000010979 ruby Substances 0.000 description 1
- 229910001750 ruby Inorganic materials 0.000 description 1
- 230000003068 static effect Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2428—Query predicate definition using graphical user interfaces, including menus and forms
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2457—Query processing with adaptation to user needs
-
- 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)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- Computational Linguistics (AREA)
- General Physics & Mathematics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Mathematical Physics (AREA)
- Human Computer Interaction (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- General Health & Medical Sciences (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The application discloses a method, equipment and medium for generating a data analysis report, comprising the following steps: loading a query condition object associated with the required data analysis report template; receiving a query parameter value input in a query condition object and generating a data analysis report template; determining data identification information written in the data analysis report template in advance according to the data analysis report template; acquiring a corresponding number formula according to the data identification information; inputting the query parameter value into a numerical formula, and determining the data to be queried; and writing data into the data analysis report template according to the position of the data identification information so as to form a data analysis report. According to the embodiment of the application, the data to be queried is determined by receiving the query parameter value input in the query condition object, and is written into the data analysis report template to form the data analysis report, so that compared with the case of manually making the data analysis report, the time for making the data analysis report is reduced.
Description
Technical Field
The present disclosure relates to the field of computer technologies, and in particular, to a method, an apparatus, and a medium for generating a data analysis report.
Background
The content of data analysis reports often involves a very large amount of information, including many lateral and longitudinal data comparison analyses. Meanwhile, because the sources of data are very large, a great deal of time is often required to make data analysis reports, and a lot of manpower is input. In addition, in the manually-made data analysis report, the situation of statistical errors is very easy to occur, so that the accuracy of the data analysis report is greatly reduced.
Disclosure of Invention
In view of the foregoing, embodiments of the present application provide a method, an apparatus, and a medium for generating a data analysis report, which are used to solve the problems of the manually-made data analysis report mentioned in the background art.
The embodiment of the application adopts the following technical scheme:
the embodiment of the application provides a method for generating a data analysis report, which specifically comprises the following steps:
loading a query condition object associated with the required data analysis report template;
receiving a query parameter value input in the query condition object, and generating the data analysis report template;
determining data identification information written in the data analysis report template in advance according to the data analysis report template;
acquiring a corresponding access formula according to the data identification information;
inputting the query parameter value into the number formula to determine the data to be queried;
and writing the data into the data analysis report template according to the position of the data identification information so as to form a data analysis report.
Further, prior to loading the query term object associated with the desired data analysis report template, the method further comprises:
inserting corresponding type data identification information in the corresponding position of the data analysis report template according to the requirement, wherein,
the type of the data identification information includes one or more of numeric type data, table type data, and graphic type data.
Further, prior to loading the query term object associated with the desired data analysis report template, the method further comprises:
setting the type of the query parameter value and the type of the query condition object, wherein,
the query parameter value comprises a parameter name and a variable, and the type of the query parameter value is set as one or more of a character string, a value and a date;
the types of the query terms objects include one or more of a text box, a numeric text box, a date control, a drop down list control, a check box, and a radio box.
Further, after the data identification information of the corresponding type is inserted into the position corresponding to the data analysis report template according to the requirement, the method further comprises:
reading the data identification information in the data analysis report template, and storing the obtained data identification information and the type of the data identification into a database.
Further, prior to loading the query term object associated with the desired data analysis report template, the method further comprises:
and setting the number of the data analysis report template, and associating the number of the data analysis report template with the corresponding query condition object.
Further, before the corresponding access formula is obtained according to the data identification information, the method further includes:
loading the data identification information, and setting a corresponding access formula according to the identification information.
Further, after the forming the data analysis report, the method further includes:
and loading the data analysis report in a preset mode so as to realize online browsing of the data analysis report.
Further, the loading the data analysis report in a preset manner specifically includes:
and loading the data analysis report by adopting an NTKO control.
The embodiment of the application also provides a device for generating the data analysis report, which comprises:
at least one processor; the method comprises the steps of,
a memory communicatively coupled to the at least one processor; wherein,
the memory stores instructions executable by the at least one processor to enable the at least one processor to:
loading a query condition object associated with the required data analysis report template;
receiving a query parameter value input in the query condition object, and generating the data analysis report template;
determining data identification information written in the data analysis report template in advance according to the data analysis report template;
acquiring a corresponding access formula according to the data identification information;
inputting the query parameter value into the number formula to determine the data to be queried;
and writing the data into the data analysis report template according to the position of the data identification information so as to form a data analysis report.
The embodiment of the application further provides a data analysis report generating medium, storing computer executable instructions, where the computer executable instructions are configured to:
loading a query condition object associated with the required data analysis report template;
receiving a query parameter value input in the query condition object, and generating the data analysis report template;
determining data identification information written in the data analysis report template in advance according to the data analysis report template;
acquiring a corresponding access formula according to the data identification information;
inputting the query parameter value into the number formula to determine the data to be queried;
and writing the data into the data analysis report template according to the position of the data identification information so as to form a data analysis report.
The above-mentioned at least one technical scheme that this application embodiment adopted can reach following beneficial effect: according to the embodiment of the application, the data to be queried is determined by receiving the query parameter value input in the query condition object, and is written into the data analysis report template to form the data analysis report, so that compared with the case of manually making the data analysis report, the time for making the data analysis report is reduced. Meanwhile, the data analysis report is generated through the embodiment of the application, so that accuracy can be improved.
Drawings
The accompanying drawings, which are included to provide a further understanding of the application and are incorporated in and constitute a part of this application, illustrate embodiments of the application and together with the description serve to explain the application and do not constitute an undue limitation to the application. In the drawings:
fig. 1 is a flowchart of a method for generating a data analysis report according to an embodiment of the present disclosure;
fig. 2 is a flowchart of a method for generating a data analysis report according to a second embodiment of the present disclosure.
Detailed Description
For the purposes, technical solutions and advantages of the present application, the technical solutions of the present application will be clearly and completely described below with reference to specific embodiments of the present application and corresponding drawings. It will be apparent that the described embodiments are only some, but not all, of the embodiments of the present application. All other embodiments, which can be made by one of ordinary skill in the art without undue burden from the present disclosure, are within the scope of the present disclosure.
The following describes in detail the technical solutions provided by the embodiments of the present application with reference to the accompanying drawings.
Fig. 1 is a flow chart of a method for generating a data analysis report according to an embodiment of the present disclosure, where the embodiment of the present disclosure may be executed by a system for generating a data analysis report, and specifically includes:
step S101, loading a query condition object associated with the required data analysis report template.
Step S102, receiving the query parameter values input in the query condition object and generating the data analysis report template.
Step S103, determining the data identification information written in the data analysis report template in advance according to the data analysis report template.
Step S104, obtaining a corresponding access formula according to the data identification information.
Step S105, inputting the query parameter value into the access formula, and determining the data to be queried.
And step S106, writing the data in the data analysis report template according to the position of the data identification information so as to form a data analysis report.
According to the embodiment of the application, the data to be queried is determined by receiving the query parameter value input in the query condition object, and is written into the data analysis report template to form the data analysis report, so that compared with the case of manually making the data analysis report, the time for making the data analysis report is reduced. Meanwhile, the data analysis report is generated through the embodiment of the application, so that accuracy can be improved.
Corresponding to the first embodiment of the present disclosure, fig. 2 is a schematic flow chart of a method for generating a data analysis report according to the second embodiment of the present disclosure, where the embodiment of the present disclosure may be executed by a system for generating a data analysis report, and specifically includes:
step S201, inserting corresponding type data identification information in the corresponding position of the data analysis report template according to the requirement.
In step S201 of the embodiment of the present specification, the type of the data identification information includes one or more of data of a numeric type, data of a table type, and data of a graphic type.
Specifically, for the data of the numerical value type, "insert bookmark" can be selected, and the bookmark name can be used as the identification of the data; for data of a form type, "insert object" may be selected, and the object name may be an identification of the data; for data of a graphics type, an "insert object" may be selected, and an object name may be used as an identification of the data.
Further, after executing the step of inserting the corresponding type of data identification information at the position corresponding to the data analysis report template according to the requirement, the method further includes:
and setting the name and the name corresponding number of the data analysis report template by the data analysis report generation system, and associating the number of the data analysis report template with the corresponding query condition object.
Reading the data identification information in the data analysis report template, and storing the obtained data identification information and the type of the data identification into a database, wherein the database comprises one or more of SqlServer, oracle and Mysql.
Step S202, setting the type of the query parameter value and the type of the query condition object.
In step S202 of the embodiment of the present specification, the query parameter value may include a parameter name and a variable, and the type of the query parameter value may be set to one or more of a character string, a value, and a date;
the types of the query terms objects include one or more of a text box, a numeric text box, a date control, a drop down list control, a check box, and a radio box.
Wherein the drop down list control may set the source of the data and the name and value of the input data.
Meanwhile, the query condition object may be set to a default value of a parameter, allowed to be empty (allowed to query without inputting a query parameter value), allowed to be edited (allowed to query a parameter value), for example, the query condition object is preset to a default value of 5; the query parameter value is space.
The query condition object may set layout information, where the layout information includes attributes such as a position, a size, and the like of the query condition object, and the query condition object may be a query window.
Step S203, a query condition object associated with the required data analysis report template is loaded.
In step S203 of the embodiment of the present specification, the user may input the number of the analysis report template to be used according to the need, and load the query condition object associated with the analysis report template of the required data through the input number of the analysis report template.
In step S203 of the embodiment of the present specification, the setting of the query condition object is completed according to the above-described steps, which only need to load the query condition object associated with the required data analysis report template.
Step S204, receiving the query parameter values input in the query condition object, and generating the data analysis report template.
In step S203 of the embodiment of the present specification, the user inputs a query parameter value in the query condition object, and downloads a corresponding data analysis report template in the system.
Step S205, determining the data identification information written in the data analysis report template in advance according to the data analysis report template.
Step S206, obtaining a corresponding access formula according to the data identification information.
In step S206 of the embodiment of the present disclosure, before the step is performed, the method further includes:
loading the data identification information, and setting a corresponding access formula according to the identification information.
The constant formula can be pi; the calculation formula can be addition, subtraction, multiplication, division and brackets, such as (10×30+40); the SQL fetch formula can be a set SQL statement; the stored procedure fetch formula may be a preset PROC () statement.
It should be noted that, in the embodiment of the present disclosure, the accuracy of the data may be set, for example, the accuracy may be accurate to thousandth, and meanwhile, deletion and addition of different types of data identification information may be supported.
Step S207, inputting the query parameter value into the access formula, and determining the data to be queried.
In step S207 of the embodiment of the present disclosure, the query parameter value is input into the access formula, and the related data is queried in the database.
And step S208, writing the data in the data analysis report template according to the position of the data identification information so as to form a data analysis report.
Step S209, loading the data analysis report in a preset mode so as to realize online browsing of the data analysis report.
In step S207 of the embodiment of the present specification, the NTKO control is used to load the data analysis report.
It should be noted that, the data analysis report generated in the embodiment of the present disclosure may be in Word format. The decimal place can be reserved for the data of the numerical value type, a micrometer display format is set, in addition, an interface of a Word document can be called to store the calculation result of the numerical formula to the corresponding position of the data analysis report template; for data of a table type, the data can be written into a table object, the table object can be an Excel table object, a first sheet page is the data, and the data is written into the first sheet page; for graphics type data, the data may be written to a graphics object, which may be an Excel table object, with a first sheet being the graphic and a second sheet being the data, the data being written to the second sheet.
After the data analysis report is generated, the data analysis report can be automatically opened and uploaded into the system.
It should be noted that, the data analysis report generated in the embodiment of the present disclosure may support uploading an existing historical data analysis report to the system; deletion of invalid and expired data analysis reports can be supported; the method can support online checking of the data analysis report, and the NTKO control is used for loading the content of the data analysis report; downloading data analysis reports to the local may be supported.
According to the embodiment of the application, the data to be queried is determined by receiving the query parameter value input in the query condition object, and is written into the data analysis report template to form the data analysis report, so that compared with the case of manually making the data analysis report, the time for making the data analysis report is reduced. Meanwhile, the data analysis report is generated through the embodiment of the application, so that accuracy can be improved.
The embodiment of the application also provides a device for generating the data analysis report, which comprises:
at least one processor; the method comprises the steps of,
a memory communicatively coupled to the at least one processor; wherein,
the memory stores instructions executable by the at least one processor to enable the at least one processor to:
loading a query condition object associated with the required data analysis report template;
receiving a query parameter value input in the query condition object, and generating the data analysis report template;
determining data identification information written in the data analysis report template in advance according to the data analysis report template;
acquiring a corresponding access formula according to the data identification information;
inputting the query parameter value into the number formula to determine the data to be queried;
and writing the data into the data analysis report template according to the position of the data identification information so as to form a data analysis report.
The embodiment of the application further provides a data analysis report generating medium, storing computer executable instructions, where the computer executable instructions are configured to:
loading a query condition object associated with the required data analysis report template;
receiving a query parameter value input in the query condition object, and generating the data analysis report template;
determining data identification information written in the data analysis report template in advance according to the data analysis report template;
acquiring a corresponding access formula according to the data identification information;
inputting the query parameter value into the number formula to determine the data to be queried;
and writing the data into the data analysis report template according to the position of the data identification information so as to form a data analysis report.
In the 90 s of the 20 th century, improvements to one technology could clearly be distinguished as improvements in hardware (e.g., improvements to circuit structures such as diodes, transistors, switches, etc.) or software (improvements to the process flow). However, with the development of technology, many improvements of the current method flows can be regarded as direct improvements of hardware circuit structures. Designers almost always obtain corresponding hardware circuit structures by programming improved method flows into hardware circuits. Therefore, an improvement of a method flow cannot be said to be realized by a hardware entity module. For example, a programmable logic device (Programmable Logic Device, PLD) (e.g., field programmable gate array (Field Programmable Gate Array, FPGA)) is an integrated circuit whose logic function is determined by the programming of the device by a user. A designer programs to "integrate" a digital system onto a PLD without requiring the chip manufacturer to design and fabricate application-specific integrated circuit chips. Moreover, nowadays, instead of manually manufacturing integrated circuit chips, such programming is mostly implemented by using "logic compiler" software, which is similar to the software compiler used in program development and writing, and the original code before the compiling is also written in a specific programming language, which is called hardware description language (Hardware Description Language, HDL), but not just one of the hdds, but a plurality of kinds, such as ABEL (Advanced Boolean Expression Language), AHDL (Altera Hardware Description Language), confluence, CUPL (Cornell University Programming Language), HDCal, JHDL (Java Hardware Description Language), lava, lola, myHDL, PALASM, RHDL (Ruby Hardware Description Language), etc., VHDL (Very-High-Speed Integrated Circuit Hardware Description Language) and Verilog are currently most commonly used. It will also be apparent to those skilled in the art that a hardware circuit implementing the logic method flow can be readily obtained by merely slightly programming the method flow into an integrated circuit using several of the hardware description languages described above.
The controller may be implemented in any suitable manner, for example, the controller may take the form of, for example, a microprocessor or processor and a computer readable medium storing computer readable program code (e.g., software or firmware) executable by the (micro) processor, logic gates, switches, application specific integrated circuits (Application Specific Integrated Circuit, ASIC), programmable logic controllers, and embedded microcontrollers, examples of which include, but are not limited to, the following microcontrollers: ARC 625D, atmel AT91SAM, microchip PIC18F26K20, and Silicone Labs C8051F320, the memory controller may also be implemented as part of the control logic of the memory. Those skilled in the art will also appreciate that, in addition to implementing the controller in a pure computer readable program code, it is well possible to implement the same functionality by logically programming the method steps such that the controller is in the form of logic gates, switches, application specific integrated circuits, programmable logic controllers, embedded microcontrollers, etc. Such a controller may thus be regarded as a kind of hardware component, and means for performing various functions included therein may also be regarded as structures within the hardware component. Or even means for achieving the various functions may be regarded as either software modules implementing the methods or structures within hardware components.
The system, apparatus, module or unit set forth in the above embodiments may be implemented in particular by a computer chip or entity, or by a product having a certain function. One typical implementation is a computer. In particular, the computer may be, for example, a personal computer, a laptop computer, a cellular telephone, a camera phone, a smart phone, a personal digital assistant, a media player, a navigation device, an email device, a game console, a tablet computer, a wearable device, or a combination of any of these devices.
For convenience of description, the above devices are described as being functionally divided into various units, respectively. Of course, the functions of each element may be implemented in one or more software and/or hardware elements when implemented in the present application.
It will be appreciated by those skilled in the art that embodiments of the present invention may be provided as a method, system, or computer program product. Accordingly, the present invention may take the form of an entirely hardware embodiment, an entirely software embodiment or an embodiment combining software and hardware aspects. Furthermore, the present invention may take the form of a computer program product embodied on one or more computer-usable storage media (including, but not limited to, disk storage, CD-ROM, optical storage, and the like) having computer-usable program code embodied therein.
The present invention is described with reference to flowchart illustrations and/or block diagrams of methods, apparatus (systems) and computer program products according to embodiments of the invention. It will be understood that each flow and/or block of the flowchart illustrations and/or block diagrams, and combinations of flows and/or blocks in the flowchart illustrations and/or block diagrams, can be implemented by computer program instructions. These computer program instructions may be provided to a processor of a general purpose computer, special purpose computer, embedded processor, or other programmable data processing apparatus to produce a machine, such that the instructions, which execute via the processor of the computer or other programmable data processing apparatus, create means for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be stored in a computer-readable memory that can direct a computer or other programmable data processing apparatus to function in a particular manner, such that the instructions stored in the computer-readable memory produce an article of manufacture including instruction means which implement the function specified in the flowchart flow or flows and/or block diagram block or blocks.
These computer program instructions may also be loaded onto a computer or other programmable data processing apparatus to cause a series of operational steps to be performed on the computer or other programmable apparatus to produce a computer implemented process such that the instructions which execute on the computer or other programmable apparatus provide steps for implementing the functions specified in the flowchart flow or flows and/or block diagram block or blocks.
In one typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.
The memory may include volatile memory in a computer-readable medium, random Access Memory (RAM) and/or nonvolatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). Memory is an example of computer-readable media.
Computer readable media, including both non-transitory and non-transitory, removable and non-removable media, may implement information storage by any method or technology. The information may be computer readable instructions, data structures, modules of a program, or other data. Examples of storage media for a computer include, but are not limited to, phase change memory (PRAM), static Random Access Memory (SRAM), dynamic Random Access Memory (DRAM), other types of Random Access Memory (RAM), read Only Memory (ROM), electrically Erasable Programmable Read Only Memory (EEPROM), flash memory or other memory technology, compact disc read only memory (CD-ROM), digital Versatile Disks (DVD) or other optical storage, magnetic cassettes, magnetic tape disk storage or other magnetic storage devices, or any other non-transmission medium, which can be used to store information that can be accessed by a computing device. Computer-readable media, as defined herein, does not include transitory computer-readable media (transmission media), such as modulated data signals and carrier waves.
It should also be noted that the terms "comprises," "comprising," or any other variation thereof, are intended to cover a non-exclusive inclusion, such that a process, method, article, or apparatus that comprises a list of elements does not include only those elements but may include other elements not expressly listed or inherent to such process, method, article, or apparatus. Without further limitation, an element defined by the phrase "comprising one … …" does not exclude the presence of other like elements in a process, method, article or apparatus that comprises the element.
The application may be described in the general context of computer-executable instructions, such as program modules, being executed by a computer. Generally, program modules include routines, programs, objects, components, data structures, etc. that perform particular tasks or implement particular abstract data types. The application may also be practiced in distributed computing environments where tasks are performed by remote processing devices that are linked through a communications network. In a distributed computing environment, program modules may be located in both local and remote computer storage media including memory storage devices.
In this specification, each embodiment is described in a progressive manner, and identical and similar parts of each embodiment are all referred to each other, and each embodiment mainly describes differences from other embodiments. In particular, for system embodiments, since they are substantially similar to method embodiments, the description is relatively simple, as relevant to see a section of the description of method embodiments.
The foregoing is merely exemplary of the present application and is not intended to limit the present application. Various modifications and changes may be made to the present application by those skilled in the art. Any modifications, equivalent substitutions, improvements, etc. which are within the spirit and principles of the present application are intended to be included within the scope of the claims of the present application.
Claims (9)
1. A method of generating a data analysis report, the method comprising:
setting the type of the query parameter value and the type of the query condition object, wherein,
the query parameter value comprises a parameter name and a variable, and the type of the query parameter value is set as one or more of a character string, a value and a date;
the type of the query condition object comprises one or more of a text box, a numerical text box, a date control, a drop-down list control, a check box and a radio box;
loading a query condition object associated with the required data analysis report template;
receiving a query parameter value input in the query condition object, and generating the data analysis report template;
determining data identification information written in the data analysis report template in advance according to the data analysis report template;
acquiring a corresponding access formula according to the data identification information, wherein the access formula comprises a constant formula, a calculation formula, an SQL access formula and a stored procedure access formula;
inputting the query parameter value into the number formula to determine the data to be queried;
and writing the data into the data analysis report template according to the position of the data identification information so as to form a data analysis report.
2. The method of claim 1, wherein prior to loading the query condition object associated with the desired data analysis report template, the method further comprises:
inserting corresponding type data identification information in the corresponding position of the data analysis report template according to the requirement, wherein,
the type of the data identification information includes one or more of numeric type data, table type data, and graphic type data.
3. The method for generating a data analysis report according to claim 1, wherein after the data identification information of the corresponding type is inserted at the position corresponding to the data analysis report template according to the requirement, the method further comprises:
reading the data identification information in the data analysis report template, and storing the obtained data identification information and the type of the data identification into a database.
4. The method of claim 1, wherein prior to loading the query condition object associated with the desired data analysis report template, the method further comprises:
and setting the number of the data analysis report template, and associating the number of the data analysis report template with the corresponding query condition object.
5. The method of claim 1, wherein prior to obtaining the corresponding access formula from the data identification information, the method further comprises:
loading the data identification information, and setting a corresponding access formula according to the identification information.
6. The method of claim 1, wherein after the forming the data analysis report, the method further comprises:
and loading the data analysis report in a preset mode so as to realize online browsing of the data analysis report.
7. The method for generating a data analysis report according to claim 6, wherein the loading the data analysis report in a preset manner specifically comprises:
and loading the data analysis report by adopting an NTKO control.
8. A device for generating a data analysis report, the device comprising:
at least one processor; the method comprises the steps of,
a memory communicatively coupled to the at least one processor; wherein,
the memory stores instructions executable by the at least one processor to enable the at least one processor to:
setting the type of the query parameter value and the type of the query condition object, wherein,
the query parameter value comprises a parameter name and a variable, and the type of the query parameter value is set as one or more of a character string, a value and a date;
the type of the query condition object comprises one or more of a text box, a numerical text box, a date control, a drop-down list control, a check box and a radio box;
loading a query condition object associated with the required data analysis report template;
receiving a query parameter value input in the query condition object, and generating the data analysis report template;
determining data identification information written in the data analysis report template in advance according to the data analysis report template;
acquiring a corresponding access formula according to the data identification information, wherein the access formula comprises a constant formula, a calculation formula, an SQL access formula and a stored procedure access formula;
inputting the query parameter value into the number formula to determine the data to be queried;
and writing the data into the data analysis report template according to the position of the data identification information so as to form a data analysis report.
9. A generation medium storing computer executable instructions for data analysis reporting, the computer executable instructions configured to:
setting the type of the query parameter value and the type of the query condition object, wherein,
the query parameter value comprises a parameter name and a variable, and the type of the query parameter value is set as one or more of a character string, a value and a date;
the type of the query condition object comprises one or more of a text box, a numerical text box, a date control, a drop-down list control, a check box and a radio box;
loading a query condition object associated with the required data analysis report template;
receiving a query parameter value input in the query condition object, and generating the data analysis report template;
determining data identification information written in the data analysis report template in advance according to the data analysis report template;
acquiring a corresponding access formula according to the data identification information, wherein the access formula comprises a constant formula, a calculation formula, an SQL access formula and a stored procedure access formula;
inputting the query parameter value into the number formula to determine the data to be queried;
and writing the data into the data analysis report template according to the position of the data identification information so as to form a data analysis report.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010241469.XA CN111581230B (en) | 2020-03-31 | 2020-03-31 | Method, equipment and medium for generating data analysis report |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010241469.XA CN111581230B (en) | 2020-03-31 | 2020-03-31 | Method, equipment and medium for generating data analysis report |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111581230A CN111581230A (en) | 2020-08-25 |
| CN111581230B true CN111581230B (en) | 2024-03-19 |
Family
ID=72113575
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010241469.XA Active CN111581230B (en) | 2020-03-31 | 2020-03-31 | Method, equipment and medium for generating data analysis report |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111581230B (en) |
Families Citing this family (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112052658A (en) * | 2020-09-04 | 2020-12-08 | 深圳市长隆科技有限公司 | Method, system and equipment for automatically generating detection report of water quality detector |
| CN112116274A (en) * | 2020-09-28 | 2020-12-22 | 中国建设银行股份有限公司 | Automatic generation method and device of survey report |
| CN114911544B (en) * | 2021-02-09 | 2024-04-05 | 北京同邦卓益科技有限公司 | Method and device for generating data analysis report, electronic equipment and storage medium |
| CN113127762A (en) * | 2021-04-21 | 2021-07-16 | 北京字节跳动网络技术有限公司 | Information display method, information processing method and device |
| CN115617874A (en) * | 2022-10-21 | 2023-01-17 | 北京领雁科技股份有限公司 | Data analysis system, method, electronic device, and computer-readable medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107122344A (en) * | 2017-05-24 | 2017-09-01 | 中国农业银行股份有限公司 | A kind of report-generating method and system |
| CN107423276A (en) * | 2017-08-14 | 2017-12-01 | 山东浪潮通软信息科技有限公司 | A kind of analysis report generation method and device |
| CN108460140A (en) * | 2018-03-13 | 2018-08-28 | 广州供电局有限公司 | Equipment-patrolling report-generating method, device, system and computer equipment |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20110307771A1 (en) * | 2010-06-15 | 2011-12-15 | Lok Wai Man | Method for generating financial report |
-
2020
- 2020-03-31 CN CN202010241469.XA patent/CN111581230B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107122344A (en) * | 2017-05-24 | 2017-09-01 | 中国农业银行股份有限公司 | A kind of report-generating method and system |
| CN107423276A (en) * | 2017-08-14 | 2017-12-01 | 山东浪潮通软信息科技有限公司 | A kind of analysis report generation method and device |
| CN108460140A (en) * | 2018-03-13 | 2018-08-28 | 广州供电局有限公司 | Equipment-patrolling report-generating method, device, system and computer equipment |
Non-Patent Citations (1)
| Title |
|---|
| 基于模版定制的报告自动生成方法;黄兵锋;盛俏;刘杰畅;吴桐;谭密;;湖北汽车工业学院学报(04);全文 * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111581230A (en) | 2020-08-25 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN111581230B (en) | Method, equipment and medium for generating data analysis report | |
| CN116541451A (en) | Data export method and device | |
| CN110134668B (en) | Data migration method, device and equipment applied to blockchain | |
| CN107622080B (en) | Data processing method and equipment | |
| CN110263050B (en) | Data processing method, device, equipment and storage medium | |
| CN108255471B (en) | System configuration item configuration device, method and equipment based on configuration suite | |
| CN115617799A (en) | Data storage method, device, equipment and storage medium | |
| CN116303625B (en) | Data query method and device, storage medium and electronic equipment | |
| CN111444163B (en) | Map data management and electronic map rollback method and device | |
| CN109062918A (en) | A kind of method and device of SQL statement conversion | |
| CN112528614A (en) | Table editing method and device and electronic equipment | |
| CN110276056B (en) | Document editing method, device, equipment and system | |
| CN116136952A (en) | Simulation test method and device for components | |
| CN112434486B (en) | Automatic paging method, device, equipment and medium for device in PCB design | |
| CN112015702A (en) | Message file name processing method, device and equipment | |
| CN111581357B (en) | Processing method, device, equipment and medium based on special auxiliary accounting | |
| CN111596946A (en) | Recommendation method, device and medium for intelligent contracts of block chains | |
| CN116521713B (en) | Data query method, device, equipment and storage medium | |
| CN113590490B (en) | Automatic test method, device and equipment | |
| CN111651450B (en) | Block copy method, device, equipment and medium based on block chain | |
| CN116204533B (en) | Metadata model-based field index mapping method, device and storage medium | |
| CN116880905B (en) | Data storage method and device, storage medium and electronic equipment | |
| CN117033420B (en) | Visual display method and device for entity data under same concept of knowledge graph | |
| CN115952859B (en) | Data processing method, device and equipment | |
| CN107391525B (en) | Instruction processing method and device for database |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20240221 Address after: 250000 Langchao Science Park, No. 1036, Langchao Road, high tech Zone, Jinan, Shandong Applicant after: Inspur Genersoft Co.,Ltd. Country or region after: China Address before: 250101 Inspur science and Technology Park, 1036 Inspur Road, hi tech Zone, Jinan City, Shandong Province Applicant before: SHANDONG INSPUR GENESOFT INFORMATION TECHNOLOGY Co.,Ltd. Country or region before: China |
|
| TA01 | Transfer of patent application right | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |