Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

Self-defined statistical report form generating system based on EXCEL form

A technology of EXCEL and self-defined reports, applied in the field of communication, can solve the problems of insufficient flexibility and time lag, and achieve the effect of reducing manual operation time, good and efficient management, and realizing efficient management

Inactive Publication Date: 2013-01-02
镇江雅迅软件有限责任公司
View PDF3 Cites 17 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0006] The purpose of the present invention is to: aim at the deficiencies in the prior art above, provide a kind of generation system based on the self-defined statistical report form of EXCEL form, to overcome the problems of insufficient flexibility and time lag in the prior art

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
  • Self-defined statistical report form generating system based on EXCEL form
  • Self-defined statistical report form generating system based on EXCEL form
  • Self-defined statistical report form generating system based on EXCEL form

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0031] Use the Microsoft VisualStudio.Net development tool to develop the client running software, and use the special database management tool SqlServer2000 on the market to establish the database required by the system. The specific method is as follows:

[0032] Import module - import the local EXCEL table, the import module includes:

[0033] Upload sub-module: realize local EXCEL form upload;

[0034] Recognition sub-module: Realize the recognition of the table operation relationship in the local EXCEL table.

[0035] Matching module - match the recognized EXCEL form with the fields in the database. The matching module includes:

[0036] Database reading sub-module: realize reading data tables and data fields from the business database;

[0037] Binding sub-module: realize binding the data fields in the data table with the imported form.

[0038] Verification module - its data verification sub-module verifies the correctness of the matching content;

[0039] Generatio...

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 relates to a self-defined statistical report form generating system, in particular to a self-defined statistical report form generating system based on an EXCEL form and relates to the technical field of communication. The self-defined statistical report form generating system based on the EXCEL form is characterized in that a local EXCEL form can be uploaded, and an introducing module for a cell operation method, a matching module, a verification module and a generation module are automatically recognized. The matching module completes binding of an introduced form and a data field in a business database. The verification module completes verification of legitimacy of binding the introduced form and the data field in the business database. The generation module completes self-defined statistical report form generation and automatic conversion of the recognized operation method into a statistical method applied in a business system. A traditional self-defined report form generation mode relying on setting redundant fields in a database and presetting a redundant statistical calculation formula in program design is broken through, and requirements of people for self-defined statistical report forms in the business system are better met.

Description

technical field [0001] The invention relates to a system for generating a self-defined statistical report, in particular to a system for generating a self-defined statistical report based on an EXCEL form. The invention belongs to the technical field of communication. Background technique [0002] With the development of information technology, more and more businesses rely on business software systems. An important application in various business software systems is various reporting tools. It is very useful for users to customize reports. , can make related report output according to the requirements of the enterprise itself, and non-professionals can customize the data processing process very flexibly. [0003] The application and design of custom reports are getting more and more attention from software developers. At present, the method of making custom reports mainly relies on software developers to set redundant fields in the database and preset as many redundant fie...

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/24G06F17/30
Inventor 李骁淳
Owner 镇江雅迅软件有限责任公司
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products