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

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 to solve how to realize dynamic formation of report forms and formulas between tables and row formulas in tables without manually compiling such reports, greatly improving work Efficiency, avoiding the problem of human error

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

Embodiment 1

[0063] The method for assembling and filling in dynamic report form formula of the present invention, the method comprises the following steps:

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

[0065] (1) Dynamic report access logic configuration: Add an 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 based on the basic access logic; The access logic configuration table is recorded in the table FYBT_REPORT_RESOURCE, 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 data from table B_Table, and the access condition is C_COL=‘1’AND D_COL=‘2’.

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

Embodiment 2

[0118] as attached figure 1 As shown, the dynamic report form formula assembly filling system of the present invention includes,

[0119] Data configuration module, used 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 a basic table sample according to the configuration row and column classification and summary rules and whether to add total rows, and then judge whether there are rows and columns that are not included in the total, and form Sum up the row and column formulas; then judge whether it is necessary to form a cross-table formula to form a KEY; finally obtain the cell range to be referenced by the KEY, replace the constant configured by the formula, and form a cross-table formula;

[0121] The row total formula logic module is used to form the row total formula logic of the organization's dynamic report, in which the columns 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 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 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