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
CN109344375APending Publication Date: 2019-02-15周宁
4 Cites 1 Cited by

Patent Information

Authority / Receiving Office
CN · China
Patent Type
Applications(China)
Current Assignee / Owner
周宁
Publication Date
2019-02-15

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

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.
Need to check novelty before this filing date? Find Prior Art

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