JSON self-definition-based report generation system and method

A report generation and customization technology, applied in special data processing applications, instruments, electronic digital data processing, etc., can solve the problems of lack of historical data review, inability to change the report display mode at will, and low efficiency.

Inactive Publication Date: 2017-05-10
AUTOMATION RES & DESIGN INST OF METALLURGICAL IND
View PDF3 Cites 29 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The first is to use manual filling in Excel to generate reports. The format of this report is relatively free, and it is mainly filled in manually. The efficiency is relatively low, and there is no historical data query.
The seco

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
  • JSON self-definition-based report generation system and method
  • JSON self-definition-based report generation system and method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0045] Example 1: Ironworks Energy Report

[0046] (1) Open the general report configuration form, fill in the report name as ironworks energy report, fill in the group name as ironworks, check the start time as the query condition, select days for the time period, and select summary flow for the row type (representing ironmaking The summary of the consumption of each energy medium in the plant), the flow filter selects the occurrence and consumption, and the button is not selected to indicate the default (export Excel and drawing). In the column definition, select the workshop through the column template, fill in the workshop in the column name; select Field in the type, and fill in Node.Name in the field or formula; do not fill in the others. Then select the medium in the column template, fill in the medium in the list, select Field in the type selection, fill in MaterialType.Name in the field or formula, and do not fill in the others. Select production consumption in the c...

Embodiment 2

[0050] Example 2: Process Energy Consumption Report

[0051] (1) Open the free report template and generate a 21*9 form. Right-click the table cell, a menu appears, copy, paste, set, delete and add other data. Copy can copy the cell data to other cells, paste is used to paste the data in other report cells, set the properties used to configure the cell, you can configure the cell offset, offset cycle number, unit, properties such as functions. Save after configuring all the cells on the table in turn.

[0052] (2) Open the report release, select the process energy consumption report in the report template tree, select coking in the node tree, select coking in the column, select process energy consumption in the type, click OK, and the process energy consumption will be published to the release file .

[0053] (3) Open the report browsing module, click on the process energy consumption, select the process energy consumption in the coking plant column, and click to view the ...

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 invention discloses a JSON self-definition-based report generation system and method, and belongs to the field of industrial enterprise data statistics. An industrial enterprise report system comprises a system configuration module, a report template configuration module, a report service module, a report release module, a report browsing module, a permission management module and a report viewing module. All the modules are deployed in a Web server of an enterprise local area network, and a client accesses the server through the local area network. The client is mainly a browser installed in a computer, an IP address of the Web server of the local area network is input through an address bar of the browser, and a system is accessed through an Http protocol. The system and the method have the advantages that an interactive process of report template configuration is simplified, so that the template configuration efficiency is improved; the problems that enterprise complex reports only can be manually filled through Excel and do not have historical data query are solved, so that the working efficiency of enterprise statistical personnel is improved; and report browsing provides query of data point trends in the reports, so that the data observation correctness of business personnel is facilitated.

Description

technical field [0001] The present invention relates to the technical field of industrial enterprise data processing, in particular to a custom report generation system and method based on JSON and Web, which is a simple and efficient industrial enterprise report system and generation method Background technique [0002] Reports are a very important enterprise management tool in industrial enterprises. With the development of computer technology, in the current practical application, three methods are mainly used to generate reports. The first is to use manual filling in Excel to generate reports. The format of this report is relatively free, and it is mainly filled in manually. The efficiency is relatively low, and there is no historical data query. The second is to pour data in the database into hard-coded tables in various application systems to generate viewable reports. This method can dynamically view historical data, but cannot change the display mode of the report a...

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
IPC IPC(8): G06F17/22G06F17/24G06F17/30
CPCG06F16/156G06F16/248G06F40/14G06F40/18
Inventor 盛刚徐化岩刘庆贺李勇
Owner AUTOMATION RES & DESIGN INST OF METALLURGICAL IND
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