CN111581230A - Method, device and medium for generating data analysis report - Google Patents
Method, device and medium for generating data analysis report Download PDFInfo
- Publication number
- CN111581230A CN111581230A CN202010241469.XA CN202010241469A CN111581230A CN 111581230 A CN111581230 A CN 111581230A CN 202010241469 A CN202010241469 A CN 202010241469A CN 111581230 A CN111581230 A CN 111581230A
- 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.)
- Granted
Links
- 238000007405 data analysis Methods 0.000 title claims abstract description 160
- 238000000034 method Methods 0.000 title claims abstract description 59
- 239000000126 substance Substances 0.000 claims description 3
- 230000006870 function Effects 0.000 description 9
- 230000006872 improvement Effects 0.000 description 9
- 238000010586 diagram Methods 0.000 description 8
- 230000008569 process Effects 0.000 description 8
- 238000004590 computer program Methods 0.000 description 7
- 238000005516 engineering process Methods 0.000 description 5
- 238000012545 processing Methods 0.000 description 5
- 238000004458 analytical method Methods 0.000 description 3
- 238000004364 calculation method Methods 0.000 description 3
- 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
- 230000005540 biological transmission 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
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000004519 manufacturing process 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
- 230000003068 static effect Effects 0.000 description 1
Images
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, which comprise the following steps: loading a query condition object associated with a desired data analysis report template; receiving query parameter values input in the 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 access formula according to the data identification information; inputting the query parameter values into an access formula, and determining data to be queried; and writing data in the data analysis report template according to the position of the data identification information to form a data analysis report. According to the data analysis report generating method and device, the data needing to be inquired are determined by receiving the inquiry parameter values input in the inquiry condition objects, the data needing to be inquired are written into the data analysis report template, and the data analysis report is formed.
Description
Technical Field
The present application relates to the field of computer technologies, and in particular, to a method, a device, and a medium for generating a data analysis report.
Background
The content of the data analysis report is often related to a large amount of information, and comprises a plurality of transverse and longitudinal data contrastive analyses. Meanwhile, because the data sources are very many, a lot of time is often spent on making data analysis reports, and much labor is invested. In addition, in the data analysis report made manually, the condition of statistical errors is easy to occur, so that the accuracy of the data analysis report is greatly reduced.
Disclosure of Invention
In view of this, 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 in the background art that a data analysis report is artificially created.
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 a desired data analysis report template;
receiving query parameter values 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 values into the access formula to determine data to be queried;
and writing the data into the data analysis report template according to the position of the data identification information to form a data analysis report.
Further, before the loading the query condition object associated with the required data analysis report template, the method further comprises:
inserting data identification information of corresponding types into the corresponding position of the data analysis report template according to requirements, wherein,
the type of the data identification information comprises one or more of data of a numerical value type, data of a table type and data of a graph type.
Further, before the loading the query condition object associated with the required 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 values comprise parameter names and variables, and the types of the query parameter values are set to be one or more of character strings, numerical values and dates;
the types of the query condition 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 inserting the data identification information of the corresponding type into the corresponding position of the data analysis report template according to the requirement, the method further includes:
and 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 in a database.
Further, before the loading the query condition object associated with the required 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 obtaining of the corresponding access formula according to the data identification information, the method further includes:
and loading the data identification information, and setting a corresponding access formula according to the identification information.
Further, after the forming of the data analysis report, the method further comprises:
and loading the data analysis report in a preset mode 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.
An embodiment of the present application further provides a device for generating a data analysis report, where the device includes:
at least one processor; and the number of the first and second groups,
a memory communicatively coupled to the at least one processor; wherein the content of the first and second substances,
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 a desired data analysis report template;
receiving query parameter values 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 values into the access formula to determine data to be queried;
and writing the data into the data analysis report template according to the position of the data identification information to form a data analysis report.
An embodiment of the present application further provides a medium for generating a data analysis report, where the medium stores computer-executable instructions, and the computer-executable instructions are configured to:
loading a query condition object associated with a desired data analysis report template;
receiving query parameter values 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 values into the access formula to determine data to be queried;
and writing the data into the data analysis report template according to the position of the data identification information to form a data analysis report.
The embodiment of the application adopts at least one technical scheme which can achieve the following beneficial effects: according to the data analysis report generating method and device, the data needing to be inquired are determined by receiving the inquiry parameter values input in the inquiry condition objects, the data needing to be inquired are written into the data analysis report template, and the data analysis report is formed. Meanwhile, the data analysis report is generated through the embodiment of the application, so that the 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 embodiment(s) of the application and together with the description serve to explain the application and not to limit the application. In the drawings:
fig. 1 is a schematic flow chart of a method for generating a data analysis report according to a first embodiment of the present disclosure;
fig. 2 is a schematic flow chart of a method for generating a data analysis report according to a second embodiment of the present disclosure.
Detailed Description
In order to make the objects, technical solutions and advantages of the present application more apparent, the technical solutions of the present application will be described in detail and completely with reference to the following specific embodiments of the present application and the accompanying drawings. It should be apparent that the described embodiments are only some of the embodiments of the present application, and not all of the embodiments. All other embodiments, which can be derived by a person skilled in the art from the embodiments given herein without making any creative effort, shall fall within the protection scope of the present application.
The technical solutions provided by the embodiments of the present application are described in detail below with reference to the accompanying drawings.
Fig. 1 is a schematic flow chart of a method for generating a data analysis report according to a first embodiment of the present specification, where the embodiment of the present specification can be executed by a system for generating a data analysis report, and specifically includes:
step S101, a query condition object associated with the required data analysis report template is loaded.
Step S102, receiving the query parameter value input in the query condition object, and generating the data analysis report template.
Step S103, determining data identification information written in the data analysis report template in advance according to the data analysis report template.
And step S104, acquiring a corresponding access formula according to the data identification information.
And step S105, inputting the query parameter values into the access formula, and determining the data to be queried.
And step S106, writing the data into the data analysis report template according to the position of the data identification information to form a data analysis report.
According to the data analysis report generating method and device, the data needing to be inquired are determined by receiving the inquiry parameter values input in the inquiry condition objects, the data needing to be inquired are written into the data analysis report template, and the data analysis report is formed. Meanwhile, the data analysis report is generated through the embodiment of the application, so that the accuracy can be improved.
Corresponding to the embodiment of the present specification, fig. 2 is a schematic flow chart of a method for generating a data analysis report provided in the second embodiment of the present specification, where the embodiment of the present specification can be executed by a system for generating a data analysis report, and specifically includes:
step S201, inserting data identification information of corresponding type into 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 numerical value type, data of a table type, and data of a graphic type.
Specifically, for data of a numerical type, "insert bookmark" may be selected, and a bookmark name may be used as an identifier of the data; for data of a table type, an "insert object" may be selected, and an object name may be used as an identifier of the data; for graphic type data, an "insert object" may be selected, and the object name may serve as an identification for the data.
Further, after the step of inserting the data identification information of the corresponding type into the corresponding position of the data analysis report template according to the requirement is executed, the method further includes:
and the generation system of the data analysis report sets the name and the number corresponding to the name of the data analysis report template, and associates the number of the data analysis report template with the corresponding query condition object.
And reading data identification information in the data analysis report template, and storing the obtained data identification information and the type of the data identification in 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 this specification embodiment, 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 numerical value, and a date;
the types of the query condition 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 can set the name and value of the data source and the input data.
Meanwhile, the query condition object may be set to a parameter default, allowed to be empty (allowing query without inputting a query parameter value), allowed to be edited (allowing a query parameter value), for example, the query condition object is preset to a default of 5; the query parameter value is a space.
The query condition object may set layout information, where the layout information includes attributes such as a position and a size of the query condition object, and the query condition object may be a query window.
Step S203 loads the query condition object associated with the required data analysis report template.
In step S203 of this embodiment, the user may input the number of the analysis report template to be used as required, and load the query condition object associated with the required data analysis report template through the input number of the analysis report template.
In step S203 in the embodiment of the present specification, the setting of the query condition object is completed according to the above-mentioned steps, and this step only needs to load out the query condition object associated with the required data analysis report template.
Step S204, receiving the query parameter value input in the query condition object, and generating the data analysis report template.
In step S203 in the embodiment of the present specification, the user inputs the query parameter value in the query condition object, and downloads the corresponding data analysis report template in the system.
Step S205, determining data identification information written in the data analysis report template in advance according to the data analysis report template.
And step S206, acquiring a corresponding access formula according to the data identification information.
In step S206 in the embodiment of the present specification, before this step is executed, the method further includes:
and loading the data identification information, and setting a corresponding access formula according to the identification information.
The access formula comprises a constant formula, a calculation formula, an SQL access formula and a storage process access formula, wherein the constant formula can be pi; the calculation formula can be plus, minus, multiply, divide and bracket, such as (10 × 30+ 40); the SQL access formula can be a set SQL statement; the stored procedure fetch formula may be a pre-set PROC () statement.
It should be noted that, in the embodiment of the present specification, the accuracy of the data may be set, for example, the accuracy may be to a thousandth of a bit, and at the same time, 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 specification, the query parameter value is input into the access formula, and the relevant data is queried in the database.
Step S208, writing the data in the data analysis report template according to the position of the data identification information to form a data analysis report.
And S209, loading the data analysis report in a preset mode to realize online browsing of the data analysis report.
In step S207 of this embodiment of the present specification, the data analysis report is loaded using an NTKO control.
It should be noted that the data analysis report generated in the embodiment of the present specification may be in Word format. The decimal place can be reserved for the data of the numerical value type, the display format of the decimal place is set, and in addition, the interface of the Word document can be called to store the calculation result of the access formula to the corresponding position of the data analysis report template; for data of a form type, writing the data into a form object, wherein the form object can be an Excel form object, a first sheet page is data, and writing the data into the first sheet page; for data of a graphic type, the data can be written into a graphic object, the graphic object can be an Excel table object, a first sheet page is a graphic, a second sheet page is data, and the data is written into the second sheet page.
After the data analysis report is generated, the data analysis report can be automatically opened and uploaded to the system.
It should be noted that the data analysis report generated in the embodiment of the present specification may support uploading of an existing historical data analysis report to a system; invalid and expired data analysis reports can be deleted; the online viewing of the data analysis report can be supported, and the data analysis report content is loaded by using an NTKO control; downloading of data analysis reports to the local may be supported.
According to the data analysis report generating method and device, the data needing to be inquired are determined by receiving the inquiry parameter values input in the inquiry condition objects, the data needing to be inquired are written into the data analysis report template, and the data analysis report is formed. Meanwhile, the data analysis report is generated through the embodiment of the application, so that the accuracy can be improved.
An embodiment of the present application further provides a device for generating a data analysis report, where the device includes:
at least one processor; and the number of the first and second groups,
a memory communicatively coupled to the at least one processor; wherein the content of the first and second substances,
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 a desired data analysis report template;
receiving query parameter values 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 values into the access formula to determine data to be queried;
and writing the data into the data analysis report template according to the position of the data identification information to form a data analysis report.
An embodiment of the present application further provides a medium for generating a data analysis report, where the medium stores computer-executable instructions, and the computer-executable instructions are configured to:
loading a query condition object associated with a desired data analysis report template;
receiving query parameter values 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 values into the access formula to determine data to be queried;
and writing the data into the data analysis report template according to the position of the data identification information to form a data analysis report.
In the 90 s of the 20 th century, improvements in a technology could clearly distinguish between improvements in hardware (e.g., improvements in circuit structures such as diodes, transistors, switches, etc.) and improvements in software (improvements in process flow). However, as technology advances, many of today's process flow improvements have been seen as direct improvements in hardware circuit architecture. Designers almost always obtain the corresponding hardware circuit structure by programming an improved method flow into the hardware circuit. Thus, it cannot be said that an improvement in the process flow cannot be realized by hardware physical modules. For example, a Programmable Logic Device (PLD), such as a Field Programmable Gate Array (FPGA), is an integrated circuit whose Logic functions are determined by programming the Device by a user. A digital system is "integrated" on a PLD by the designer's own programming without requiring the chip manufacturer to design and fabricate application-specific integrated circuit chips. Furthermore, nowadays, instead of manually making an integrated Circuit chip, such Programming is often implemented by "logic compiler" software, which is similar to a software compiler used in program development and writing, but the original code before compiling is also written by a specific Programming Language, which is called Hardware Description Language (HDL), and HDL is not only one but many, such as abel (advanced Boolean Expression Language), ahdl (alternate Language Description Language), traffic, pl (core unified Programming Language), HDCal, JHDL (Java Hardware Description Language), langue, Lola, HDL, laspam, hardsradware (Hardware Description Language), vhjhd (Hardware Description Language), and vhigh-Language, which are currently used in most common. It will also be apparent to those skilled in the art that hardware circuitry that implements the logical method flows can be readily obtained by merely slightly programming the method flows into an integrated circuit using 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, an Application Specific Integrated Circuit (ASIC), a programmable logic controller, and an embedded microcontroller, 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 for the memory. Those skilled in the art will also appreciate that, in addition to implementing the controller as pure computer readable program code, the same functionality can be implemented by logically programming method steps such that the controller is in the form of logic gates, switches, application specific integrated circuits, programmable logic controllers, embedded microcontrollers and the like. Such a controller may thus be considered a hardware component, and the means included therein for performing the various functions may also be considered as a structure within the hardware component. Or even means for performing the functions may be regarded as being both a software module for performing the method and a structure within a hardware component.
The systems, devices, modules or units illustrated in the above embodiments may be implemented by a computer chip or an entity, or by a product with certain functions. One typical implementation device is a computer. In particular, the computer may be, for example, a personal computer, a laptop computer, a cellular telephone, a camera phone, a smartphone, 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 divided into various units by function, and are described separately. Of course, the functionality of the units may be implemented in one or more software and/or hardware when implementing the present application.
As will be appreciated by one skilled in the art, 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 flow diagrams and/or block diagrams, and combinations of flows and/or blocks in the flow diagrams 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 a typical configuration, a computing device includes one or more processors (CPUs), input/output interfaces, network interfaces, and memory.
The memory may include forms of volatile memory in a computer readable medium, Random Access Memory (RAM) and/or non-volatile memory, such as Read Only Memory (ROM) or flash memory (flash RAM). Memory is an example of a computer-readable medium.
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 computer storage media 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 Discs (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. As defined herein, a computer readable medium does not include a transitory computer readable medium such as a modulated data signal and a carrier wave.
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 an … …" 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.
The embodiments in the present specification are described in a progressive manner, and the same and similar parts among the embodiments are referred to each other, and each embodiment focuses on the differences from the other embodiments. In particular, for the system embodiment, since it is substantially similar to the method embodiment, the description is simple, and for the relevant points, reference may be made to the partial description of the method embodiment.
The above description is only an example of the present application and is not intended to limit the present application. Various modifications and changes may occur to those skilled in the art. Any modification, equivalent replacement, improvement, etc. made within the spirit and principle of the present application should be included in the scope of the claims of the present application.
Claims (10)
1. A method for generating a data analysis report, the method comprising:
loading a query condition object associated with a desired data analysis report template;
receiving query parameter values 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 values into the access formula to determine data to be queried;
and writing the data into the data analysis report template according to the position of the data identification information to form a data analysis report.
2. The method of generating a data analysis report of claim 1 wherein prior to said loading a query condition object associated with a desired data analysis report template, said method further comprises:
inserting data identification information of corresponding types into the corresponding position of the data analysis report template according to requirements, wherein,
the type of the data identification information comprises one or more of data of a numerical value type, data of a table type and data of a graph type.
3. The method of generating a data analysis report of claim 1 wherein prior to said loading a query condition object associated with a desired data analysis report template, said method further comprises:
setting the type of the query parameter value and the type of the query condition object, wherein,
the query parameter values comprise parameter names and variables, and the types of the query parameter values are set to be one or more of character strings, numerical values and dates;
the types of the query condition 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.
4. The method for generating a data analysis report according to claim 3, wherein after inserting the data identification information of the corresponding type into the corresponding position of the data analysis report template according to the requirement, the method further comprises:
and 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 in a database.
5. The method of generating a data analysis report of claim 1 wherein prior to said loading a query condition object associated with a desired data analysis report template, said 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.
6. The method of generating a data analysis report of claim 1, wherein before the obtaining the corresponding access formula according to the data identification information, the method further comprises:
and loading the data identification information, and setting a corresponding access formula according to the identification information.
7. The method of generating a data analysis report of claim 1 wherein after said forming a data analysis report, said method further comprises:
and loading the data analysis report in a preset mode to realize online browsing of the data analysis report.
8. The method for generating a data analysis report according to claim 7, wherein the loading the data analysis report in a preset manner specifically includes:
and loading the data analysis report by adopting an NTKO control.
9. An apparatus for generating a data analysis report, the apparatus comprising:
at least one processor; and the number of the first and second groups,
a memory communicatively coupled to the at least one processor; wherein the content of the first and second substances,
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 a desired data analysis report template;
receiving query parameter values 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 values into the access formula to determine data to be queried;
and writing the data into the data analysis report template according to the position of the data identification information to form a data analysis report.
10. A medium for generating a data analysis report, the medium storing computer-executable instructions, the computer-executable instructions configured to:
loading a query condition object associated with a desired data analysis report template;
receiving query parameter values 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 values into the access formula to determine data to be queried;
and writing the data into the data analysis report template according to the position of the data identification information 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 true CN111581230A (en) | 2020-08-25 |
CN111581230B 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) |
Cited By (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 |
CN113127762A (en) * | 2021-04-21 | 2021-07-16 | 北京字节跳动网络技术有限公司 | Information display method, information processing method and device |
CN114911544A (en) * | 2021-02-09 | 2022-08-16 | 北京同邦卓益科技有限公司 | Data analysis report generation method and device, electronic equipment and storage medium |
CN115617874A (en) * | 2022-10-21 | 2023-01-17 | 北京领雁科技股份有限公司 | Data analysis system, method, electronic device, and computer-readable medium |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20110307771A1 (en) * | 2010-06-15 | 2011-12-15 | Lok Wai Man | Method for generating financial report |
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 |
-
2020
- 2020-03-31 CN CN202010241469.XA patent/CN111581230B/en active Active
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US20110307771A1 (en) * | 2010-06-15 | 2011-12-15 | Lok Wai Man | Method for generating financial report |
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 |
---|
黄兵锋;盛俏;刘杰畅;吴桐;谭密;: "基于模版定制的报告自动生成方法", 湖北汽车工业学院学报 * |
Cited By (6)
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 |
CN114911544A (en) * | 2021-02-09 | 2022-08-16 | 北京同邦卓益科技有限公司 | Data analysis report generation method and device, electronic equipment and storage medium |
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 |
Also Published As
Publication number | Publication date |
---|---|
CN111581230B (en) | 2024-03-19 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN111581230A (en) | Method, device and medium for generating data analysis report | |
CN107622080B (en) | Data processing method and equipment | |
CN110968601A (en) | Data query processing method and device | |
CN110245002B (en) | System interaction method, device, equipment and storage medium | |
CN107679056B (en) | Method for generating SQL (structured query language) statement, electronic device and readable storage medium | |
CN110263050B (en) | Data processing method, device, equipment and storage medium | |
CN108846069B (en) | Document execution method and device based on markup language | |
CN108255471B (en) | System configuration item configuration device, method and equipment based on configuration suite | |
CN112463135A (en) | Code generation method, code generator, electronic device, and storage medium | |
CN107391529B (en) | Method and device for realizing Object Relation Mapping (ORM) | |
CN115617799A (en) | Data storage method, device, equipment and storage medium | |
CN108536660B (en) | Custom report generation method and terminal | |
CN112231531A (en) | Data display method, equipment and medium based on openstb | |
CN107239270B (en) | Code processing method and device | |
CN112015702A (en) | Message file name processing method, device and equipment | |
CN111596946A (en) | Recommendation method, device and medium for intelligent contracts of block chains | |
CN110704742A (en) | Feature extraction method and device | |
CN112000329A (en) | Data display method, device, equipment and medium | |
CN117952074A (en) | Data importing method, device and medium | |
CN107391525B (en) | Instruction processing method and device for database | |
CN111581357A (en) | Processing method, device, equipment and medium based on special auxiliary accounting | |
CN112434486A (en) | Automatic device paging method, device, equipment and medium in PCB design | |
CN112579627B (en) | SQL time parameter configuration method, system, electronic equipment and storage medium | |
CN117033420B (en) | Visual display method and device for entity data under same concept of knowledge graph | |
CN111930855A (en) | Account book accounting method, device, equipment and medium |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
PB01 | Publication | ||
PB01 | Publication | ||
SE01 | Entry into force of request for substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
TA01 | Transfer of patent application right | ||
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 |
|
GR01 | Patent grant | ||
GR01 | Patent grant |