Excel-like report processing method

A processing method, excel technology, applied in the field of data processing, can solve problems such as simplicity, user barriers, and complex report formats, and achieve the effect of convenient use

Inactive Publication Date: 2011-01-12
CHINA ENFI ENGINEERING CORPORATION
View PDF3 Cites 32 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0007] Disadvantages: There are certain limitations in the production of complex reports. Generally, only regular and simple-format reports can be displayed, and it is difficult to handle fill-in reports.
[0011] Disadvantages: There is basically no or very simple data interface with the database, and the integration with the database is not very close. The statistical data in the report needs to be implemented by the program code and then filled in the form
[0014] 2. There are extremely complex formula references between each worksheet
[0015] 3. The report format is complex
[0016] Therefore, these features will caus...

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
  • Excel-like report processing method
  • Excel-like report processing method
  • Excel-like report processing method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0047] Embodiments of the present invention are described in detail below, examples of which are shown in the drawings, wherein the same or similar reference numerals designate the same or similar elements or elements having the same or similar functions throughout. The embodiments described below by referring to the figures are exemplary only for explaining the present invention and should not be construed as limiting the present invention.

[0048]In the present invention, the development environment adopts X3Business Studio of Justep Company, the language and components of the development platform are basically consistent with Delphi, and the basic components in Delphi are integrated. In addition, the platform can also import third-party Delphi components or ActiveX controls written by other tools. In addition, in order to achieve the operation interface similar to the Excel mode, the present invention considers components with Excel partial functions in component selection...

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 provides an excel-like report processing method. The method comprises the following steps of: generating a user report template which at least comprises report type information, report data area setting information, base value setting information, report format setting information and formula setting information; compressing the generated user report template and storing the compressed report template in a structured query language (SQL) database server; selecting the report type needed to be filled by a user and obtaining a corresponding user report template from the SQL database sever; decompressing the obtained user report template and generating report basic data; loading the user report template and monthly reported basic data to a client for the user to fill the report; and generating report data by using the user report filled by the user and storing the report data in the SQL database server.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to an Excel-like report processing method. Background technique [0002] As the level of user needs continues to deepen, users have higher and higher requirements for reports. They no longer only meet related needs such as report statistics, but need more control over the report interface and data display. Users need Ability to customize the report and customize the report you need in your own way. In order for users to customize the report, it is very important to actually conform to the user's usage habits. The Excel-like operation method just meets the habits of most users, and this operation method is exactly what you can do without training. A way of direct acceptance. Custom functions have become a new trend of report products. Compared with simply allowing users to modify the display form of reports in the past, users' requirements for customization have been impro...

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/24G06F9/44G06F17/30
Inventor 何煦春陈进丁涛李伟马平
Owner CHINA ENFI ENGINEERING CORPORATION
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