A report tool and method based on an office software

A reporting tool and office software technology, applied in the computer field, can solve problems such as difficult to support complex report requirements, poor complex report support ability, long cycle, etc., to achieve the effect of shortening the report production cycle, reducing the difficulty of report production, and simple operation and use

Pending Publication Date: 2019-02-15
周宁
View PDF4 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] 1. Poor ease of use: making reports requires writing SQL statements or even programming, which can only be done by professionals, which is difficult
[0004] 2. The production cycle is long: business personnel need to make demands on professionals, and the professionals will make reports and give feedback, modify them until they reach usability, and the cycle is too long
[0005] 3. The ability to support complex reports is poor: the report format is not flexible, complex statistical calculations require a lot of programming, and it is difficult to support complex report requirements
[0006] 4. Low performance: report query and browsing takes a long time, and the user experience is poor

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 report tool and method based on an office software
  • A report tool and method based on an office software
  • A report tool and method based on an office software

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0097] see Figure 1 to Figure 5 , a report tool based on office software, characterized in that it mainly includes a computer memory, a PC display screen, a database, a report tool main interface, a query condition setting interface, a data extraction interface and an operation result display interface.

[0098] The computer memory stores the data of the database, the report tool main interface, the query condition setting interface, the data extraction interface and the operation result display interface.

[0099] The PC display screen displays a report tool main interface, a query condition setting interface, a data extraction interface and an operation result display interface.

[0100] The main interface of the report tool mainly includes a basic setting module and a display module.

[0101] The basic setting module mainly includes a file button, a start button, an insert button, a page layout button, a formula button, a data button, a review button, a team button, and a...

Embodiment 2

[0151] see Figure 6 to Figure 8, a method for using the reporting tool based on office software, mainly comprising the following steps:

[0152] 1) Create a database.

[0153] The data source and its binding relationship with the cells are saved in a special worksheet (the worksheet is uniformly named DATADEF and hidden for program access only), and other worksheets of EXCEL, WPS or other office form software are reserved All fill, quote, format, formula, report definition and chart definition information. DATADEF describes the named query instance called by EXCEL data (named query: save and name the data query condition, so that it can be referenced and executed in the program and get the query result. One named query can correspond to multiple named query instances), and the named query instance corresponds to The query conditions, the location (cell) information bound to the query instance, and the filling direction (it is convenient to fill the query data into the corre...

Embodiment 3

[0163] A method for performing report query using the report tool based on office software, mainly comprising the following steps:

[0164] 1) Parse the table header.

[0165] According to the report type and query parameters, a header is generated, and the control type and parameter selection method in the header are determined.

[0166] 2) Generate header files.

[0167] 3) Query the initial settings, the main steps are as follows:

[0168] 3.1) Find the table header.

[0169] 3.2) Initial parsing header.

[0170] 3.3) Judging whether the table header defines a cache, if not, splicing the table header and the parsed report, and storing and displaying the report. If yes, go to step 3.4.

[0171] 3.4) Judging whether there has been a query. If not, the table header and the parsed report are spliced, and the report is stored and displayed. If so, stitch the header and cache the report.

[0172] 3.5) Display the report.

[0173] 4) Report query, the main steps are as fo...

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 report tool and a method based on an office software. The report tool mainly includes a computer memory, a PC display, a database, a report tool main interface, a query criteria setting interface, a data extraction interface and a running results display interface. The method comprises the main steps of 1) establishing the database; 2) setting and selecting named queriesto invoke data in the database; 3) using the SDC toolbar plug-in to add operation data button in the main interface of the report tool; 4) clicking the data extraction button to execute the named query; 5) preparing a report according to that query result; 6) displaying the EXCEL report template made by the report tool in HTML5 web page. The invention develops a tool software for making report forms based on daily office software (WPS or EXCEL), which is simple in operation and use, accords with daily operation habit, supports business personnel to independently customize the report forms, andremarkably improves ease of use.

Description

technical field [0001] The invention relates to the technical field of computers, in particular to a reporting tool and method based on office software. Background technique [0002] Reports are the rigid requirements of various enterprises, institutions and various information management systems, involving a wide range and a huge workload. The current report tool software has the following problems: [0003] 1. Poor ease of use: making reports requires writing SQL statements or even programming, which can only be done by professionals and is difficult. [0004] 2. The production cycle is long: business personnel need to make demands on professionals, and the professionals will make reports and give feedback, and modify them until they reach usability. The cycle is too long. [0005] 3. The ability to support complex reports is poor: the report format is not flexible, complex statistical calculations require a lot of programming, and it is difficult to support complex repor...

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 Applications(China)
IPC IPC(8): G06F17/24G06F9/451
CPCG06F9/451G06F40/18
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