A configurable dynamic report generation method and system

A technology for report generation and table configuration, applied in special data processing applications, instruments, electrical digital data processing, etc., can solve the problems of poor report data analysis, low code reuse rate, low development efficiency, etc., to improve development Efficiency, improvement of analysis effect, effect of reducing development amount

Active Publication Date: 2018-04-03
北京思特奇信息技术股份有限公司
View PDF6 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] However, the current report data display method requires developers to repeatedly develop codes for the data to be displayed. The development efficiency is low, the code reuse rate is low, and the effect of report data analysis is not good.

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • A configurable dynamic report generation method and system
  • A configurable dynamic report generation method and system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0033] The principles and features of the present invention are described below in conjunction with the accompanying drawings, and the examples given are only used to explain the present invention, and are not intended to limit the scope of the present invention.

[0034] Such as figure 1 As shown, a configurable dynamic report generation method includes the following steps:

[0035] Step 1, create a report template;

[0036] Step 2, establish a report configuration table and a report condition table, and configure the report configuration table and report condition table according to the business logic;

[0037] Step 3, analyzing the report condition table, establishing a report display area, and automatically generating a query page;

[0038] Step 4, receiving the query condition input by the user on the query page, and generating a query statement in combination with the report configuration table and the report condition table;

[0039] Step 5, execute the query stateme...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

PUM

No PUM Login to view more

Abstract

The present invention relates to a configurable dynamic report generation method and system, including establishing a report template; establishing a report configuration table and a report condition table, configuring the report configuration table and the report condition table according to business logic; analyzing the report condition table, Create a report display area and automatically generate a query page; receive the query conditions entered by the user on the query page, and generate query statements in combination with the report configuration table and report condition table; execute the query statement on the specified database to obtain the result data set; according to the obtained results The data set and the report template created in step 1 generate a temporary excel file and save it in the specified directory. The present invention can automatically display report statistical data in a batch configurable manner, use configurable reports, improve the development efficiency of statistical analysis reports, reduce the development amount of repeated codes, improve code reusability, and improve report data analysis effects .

Description

technical field [0001] The invention relates to the technical field of report processing, in particular to a configurable dynamic report generation method and system. Background technique [0002] With the rise of enterprise information system integration and enterprise e-commerce system construction, reports, as an important information carrier, play an extremely important role in the system, and configurable report display is more and more concerned by software developers. With the increase of data and the improvement of demand, there are more and more applications for display and analysis results of reports. [0003] However, the current report data display method requires developers to repeatedly develop codes for the data to be displayed, which leads to low development efficiency, low code reuse rate, and poor report data analysis results. Contents of the invention [0004] The technical problem to be solved by the present invention is to provide a configurable dynam...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to view more

Application Information

Patent Timeline
no application Login to view more
Patent Type & Authority Patents(China)
IPC IPC(8): G06F17/24G06F17/30
Inventor 孙丽华
Owner 北京思特奇信息技术股份有限公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap