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

Realization method for realizing crosstab rapidly

An implementation method, a technology of cross-tabulation, applied in the direction of instruments, etc., to achieve the effect of facilitating integration and use, reducing system expenses, and improving display speed and efficiency

Inactive Publication Date: 2011-04-20
INSPUR COMMON SOFTWARE
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This method solves the problem of data cross-display when displaying reports, and improves the display speed and efficiency of similar data tables

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
  • Realization method for realizing crosstab rapidly
  • Realization method for realizing crosstab rapidly
  • Realization method for realizing crosstab rapidly

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0018] As shown in accompanying drawing 1,2,3, the realization method of fast realization crosstab of the present invention comprises the following steps:

[0019] Sort the query results according to the row titles (can be omitted if the results are already sorted). That is, array A1: ((sales one, Zhang San, training fee, 100.00), (sales one, Gao Bao, material fee, 200.00), (sales two, Li Cai, material fee, 300.00), (sales two Department, Li Si, postage, 400.00)).

[0020] The process is as follows:

[0021] Since the A1 array is a sorted array, in the loop, the new row headers can be obtained sequentially based on the comparison of the row header information of the current row with the row header information of the previous row. At the same time, for the new column headers, the length of the general array is not large , the new column title can be obtained and the subscript information of the new column title can be recorded at the same time through loop judgment, so that t...

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 realization method for realizing a crosstab rapidly, belonging to the technical field of computer application. In the invention, based on memory array processing, data processing is carried out on the original array data by adopting a one-way circulating processing mode. Compared with the prior art, the realization method for realizing the crosstab rapidly has the characteristics of high performance and high efficiency and the like, is easy for integration usage, can be widely applied to display of query results of various Chinese type report forms and has good popularization and application value.

Description

technical field [0001] The invention relates to a computer application technology, in particular to a method for quickly realizing a cross table. Background technique [0002] In ERP application, how to display the data in ERP is a part that every enterprise must consider and realize. It is a commonly used method, but in computer-based program processing, especially in data statistics based on relational databases, the form of "Table-1" (as shown in Figure 1) is easy to implement. [0003] In the prior art, in order to realize the cross-display of data from "Table-1" to "Table-2", the cross-table needs to confirm the part of the data that needs to be cross-displayed in a circular manner. usually to determine row header Information (office, name), reconfirmation column header After the information (expense item) is determined, the specific amount data information is determined according to the title information of the rows and columns. If it is through the SQL method of ...

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): G06Q10/00
Inventor 肖祝川
Owner INSPUR COMMON SOFTWARE
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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com