A dynamic report formula assembling and reporting method and system

A formula and report technology, applied in the computer field, to achieve strong portability, expand the scope, and promote the effect of application value

Pending Publication Date: 2019-04-26
INSPUR COMMON SOFTWARE
View PDF4 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] The technical task of the present invention is to provide a method and system for assembling and filling in dynamic report formulas, so as to solve how to realize the dynamic formation of rep

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 dynamic report formula assembling and reporting method and system
  • A dynamic report formula assembling and reporting method and system
  • A dynamic report formula assembling and reporting method and system

Examples

Experimental program
Comparison scheme
Effect test

Example Embodiment

[0062] Example 1:

[0063] The method for assembling and filling the dynamic report formula of the present invention includes the following steps:

[0064] S1. Perform various configurations on dynamic reports; specifically include the following:

[0065] (1) Dynamic report access logic configuration: add access logic configuration table, which is used to record which table or view the configuration data is taken from, and determine which data the report is based on according to the basic access logic; The access logic configuration table uses the table FYBT_REPORT_RESOURCE record, as shown in the following table:

[0066]

[0067] This table mainly configures the report access table (view) and access logic. For example, report A accesses the number from table B_Table, and the access condition is C_COL = '1' AND D_COL = '2'.

[0068] (2) Form the multi-level header logic configuration of the dynamic report column: add a multi-level header configuration table, configure the multi-level ...

Example Embodiment

[0117] Example 2:

[0118] As attached figure 1 As shown, the dynamic report formula assembly and reporting system of the present invention includes:

[0119] Data configuration module for data configuration of dynamic reports;

[0120] The cross-table formula module is used to complete all the data according to the basic configuration of each dynamic report, and then form the basic table sample according to the classification and summary rules of the configuration row and column and whether to add the total row rule, and then determine whether there are rows and columns that are not included in the total. Sum up the row and column formulas; then determine whether it is necessary to form a cross-table formula to form a KEY; finally obtain the cell range to be referenced through KEY, replace the constants configured by the formula, and form its cross-table formula;

[0121] The row total formula logic module is used to form the row total formula logic of the organization dynamic repor...

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 method and a system for assembling and filling a dynamic report formula. A computer belongs to the technical field of computers, The technical problem to be solved by the invention is how to dynamically form an inter-table formula and an in-table row formula for dynamically forming a report. According to the technical scheme, the dynamic report formula assembling and filling method comprises the following steps that S1, various configurations are conducted on a dynamic report, and manual report compiling is not needed, so that the working efficiency is greatly improved; S2, forming a cross-table formula; S3, organizing the line summation formula logic of the dynamic report; And S4, cross-table formula logic for organizing the dynamic report is formed. And (2) thedynamic report formula assembling and filling system comprises a data configuration module, a cross-table formula module, a row summation formula logic module and a cross-table formula logic module.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a method and system for assembling and filling in dynamic report formulas. Background technique [0002] Among the existing reporting tools, the most common reports are fixed-like reports and floating tables with fixed headers. Dynamic reports and dynamic formulas for fixed reports are also often seen, but there is no mature and effective solution to achieve dynamic The main reason for the dynamic formula of the report is that the existing dynamic formulas are configured dynamically based on the fixed cells of the fixed report, and most of the cells of the dynamic report are not fixed, and there is no "coordinate" to configure formula. Once the customer has this kind of demand, it cannot be realized and the customer can only add it manually. If the amount of report data is large, the compilation, inspection and summary of the report will bring great trouble to the customer, an...

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/24
CPCG06F40/18G06F40/174
Inventor 刘含涛吴玉林史艳庆
Owner INSPUR COMMON SOFTWARE
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