CN109684616A - Dynamic statement formula assembles the method and system made a report on - Google Patents
Dynamic statement formula assembles the method and system made a report on Download PDFInfo
- Publication number
- CN109684616A CN109684616A CN201811524792.7A CN201811524792A CN109684616A CN 109684616 A CN109684616 A CN 109684616A CN 201811524792 A CN201811524792 A CN 201811524792A CN 109684616 A CN109684616 A CN 109684616A
- Authority
- CN
- China
- Prior art keywords
- formula
- row
- report
- configuration
- column
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
- 238000000034 method Methods 0.000 title claims abstract description 25
- 230000015572 biosynthetic process Effects 0.000 claims abstract description 26
- 238000005308 sum rule Methods 0.000 claims description 7
- 238000005516 engineering process Methods 0.000 abstract description 3
- 238000013480 data collection Methods 0.000 description 2
- 238000010586 diagram Methods 0.000 description 1
- 238000007689 inspection Methods 0.000 description 1
- 230000035800 maturation Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/177—Editing, e.g. inserting or deleting of tables; using ruled lines
- G06F40/18—Editing, e.g. inserting or deleting of tables; using ruled lines of spreadsheets
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F40/00—Handling natural language data
- G06F40/10—Text processing
- G06F40/166—Editing, e.g. inserting or deleting
- G06F40/174—Form filling; Merging
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Health & Medical Sciences (AREA)
- Artificial Intelligence (AREA)
- Audiology, Speech & Language Pathology (AREA)
- Computational Linguistics (AREA)
- General Health & Medical Sciences (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of dynamic statement formula to assemble the method and system made a report on, belong to field of computer technology, the technical problem to be solved in the present invention is formula and table expert's formula between the dynamic formation table for how realizing dynamic formation report, without by formulating and submitting such report by hand, increase substantially working efficiency, the technical solution of use are as follows: dynamic statement formula assembles the method made a report on, and this method comprises the following steps: every configuration S1, is carried out to dynamic statement；S2, across table formula is formed；S3, the row of dynamic statement is organized to add up to formula logic；S4, across the table formula logic for forming tissue dynamic statement.2. it includes data configuration module, across table formula module, the total formula logic module of row and across table formula logic module that the system system is made a report in a kind of assembling of dynamic statement formula.
Description
Technical field
The present invention relates to field of computer technology, specifically a kind of dynamic statement formula assembles the method made a report on and is
System.
Background technique
In existing report tool, the most common report is exactly the relocation table of fixed table sample report and fixed gauge outfit, is moved
The dynamic formula of state report and fixed report also can often be seen, but there are no an effective schemes of maturation to realize dynamic
The dynamic formula of report, main cause are that existing dynamic formula is all based on the fixed cell lattice of fixed report to be configured
Dynamic formation, and the most cell of dynamic statement be all it is unfixed, none " coordinate " carrys out allocation formula.Once
Client has this demand, just cannot realize can only client go to add by hand, if report data amount is larger, the establishment inspection of report and
Very big puzzlement can be brought to client by summarizing, and also be easier mistake occur.Therefore how to realize the dynamic of dynamic formation report
State forms formula and table expert's formula between table, without increasing substantially working efficiency, avoiding out by formulating and submitting such report by hand
Existing mistake is current technical problem urgently to be solved.
The patent document of Patent No. CN105138501B discloses a kind of configurable dynamic report generation method and is
System, including establish report template；Report allocation list and report condition table are established, according to service logic to report allocation list and report
Condition table is configured；The report condition table is parsed, report display area is established, automatically generates query page；Receive user
In the querying condition of query page input, query statement is generated in conjunction with report allocation list and report condition table；In specified data
Query statement is executed on library, obtains result data collection；It is raw according to the report template established in the result data collection and step 1 of acquisition
At interim excel file, it is stored on specified directory.But the technical method not can solve how to realize dynamic formation report
Formula and table expert's formula between dynamic formation table, without increasing substantially working efficiency, avoiding by formulating and submitting such report by hand
There is the problem of mistake.
Summary of the invention
Technical assignment of the invention is to provide a kind of dynamic statement formula and assembles the method and system made a report on, come solve how
Formula and table expert's formula between the dynamic formation table of realization dynamic formation report, without formulating and submitting such report by manual, substantially
The problem of degree improves working efficiency, avoids the occurrence of mistake.
Technical assignment of the invention realizes that dynamic statement formula assembles the method made a report on, this method in the following manner
Include the following steps:
S1, every configuration is carried out to dynamic statement；
S2, across table formula is formed, specific as follows:
1., all data are completed according to the configurations of each dynamic statement；
2., according to configuration ranks Classifying Sum rule and whether increase the regular basis of formation table sample of total row；
3., judge whether there is and be not counted in total ranks, form total ranks formula；
4., judge whether to need to form across table formula, form KEY；
5., pass through KEY and obtain the range of cells to be quoted, the constant of replacement formula configuration forms across table formula；
S3, the row of dynamic statement is organized to add up to formula logic, wherein carrying out total column, to have eliminated column total
The column total without row are arranged and are separately configured, and to carry out total behavior will increase the sub-line of total formula row, and should
List, which does not include, to be met without total sub-line；
S4, across the table formula logic for forming tissue dynamic statement.
Preferably, the step S1, which carries out every configuration to dynamic statement, specifically includes following content:
(1), dynamic statement access logic configuration: increase access logic allocation list, the allocation list is for recording configuration data
It is derived from which table or which view, and determines that report is formed according to which data according to basic access logic；
(2), it forms dynamic statement and arranges multistage gauge outfit logic configuration: increasing multistage gauge outfit allocation list, configure dynamic statement
Multi-level table head formation rule and being confirmed whether needs total column (such as: being grouped and summarize according to which or which field)；
(3), dynamic statement detail column configuration: increasing detail column allocation list, configures the detail column of report, configuration column name, column
Formula and across table formula；
(4), dynamic statement row Classifying Sum configures: increasing row Classifying Sum allocation list, configures the row Classifying Sum of report
Rule and whether need total row；
(5), dynamic statement row unique identification configures: increasing row unique identification allocation list, configures the row unique identification of report
Or unique identification rule；
(6), it is configured in dynamic statement without executing the special ranks of formula: increasing and match without the special ranks for executing formula
Table is set, configuration report is not necessarily to carry out total ranks and executes condition, and configuration is without executing row and execution across table formula
Condition；
(7), program parsing configuration tissue dynamic statement and dynamic formula.
More preferably, specific step is as follows for program parsing configuration tissue dynamic statement and dynamic formula in the step (7):
1., according to configuration formed report ranks and ranks add up to formula；
2., according to configuration formed report need to form dynamic formula cell KEY value；
3., matched according to KEY value, obtain the cell to be quoted, and the formula needed is formed according to configuration.
More preferably, access logic allocation list is recorded using table FYBT_REPORT_RESOURCE in the step (1).
More preferably, multistage gauge outfit allocation list is recorded using table FYBT_REPORT_COLGROUP in the step (2)；
The configuration content of multistage gauge outfit allocation list is as follows:
1., database column be month, group names form logic are as follows: counts stockpile number@Value@month, grouping needs
Adduction meter column；Total column name are as follows: total, sortord is from small to large；
2., database column be grade, group names formed logic are as follows:@grade of@Value, grouping without adduction meter arrange, sort
Mode is from small to large.
More preferably, detail column allocation list is recorded using table FYBT_REPORT_COL in the step (3)；
The gauge outfit configuration content of detail column allocation list is as follows:
Database column name: quantity in stock, column name are empty (if configuration, can be further added by a line gauge outfit, not meet to be shown
Form), column type: Database field value, column rule are as follows: grouping field _ detail column field@GROUP@_@COL@.
More preferably, row Classifying Sum allocation list is recorded using table FYBT_REPORT_ROWGROUP in the step (4)；
The gauge outfit configuration content of row Classifying Sum allocation list is as follows:
1., database column be tissue Internal Code: group names are as follows: company, grouping need adduction meter row；Total column name are as follows:
Subtotal, sortord are from small to large；
2., database column be post: group names form logic are as follows: post, grouping are not necessarily to adduction meter row, and sortord is
From small to large.
More preferably, without executing the special ranks allocation list of formula using table FYBT_REPORT_ in the step (6)
HLCONF record；
Special ranks allocation list without executing formula does not execute unified formula shape for configuring special row or column
At；When ROW is total row, this formula is not executed, then configures trigger condition are as follows: ROW_KEY=GROUP_HJ, the place after triggering
Reason be disregard fall in lines it is total.
System is made a report in a kind of assembling of dynamic statement formula, which includes,
Data configuration module, the data configuration for dynamic statement；
Across table formula module, for completing all data according to the configurations of each dynamic statement, further according to configuration
Ranks Classifying Sums rule and the regular basis of formation table sample for whether increasing total row, then judge whether there is be not counted in it is total
Ranks, form total ranks formula；Judge whether to need to form across table formula again, forms KEY；It is obtained finally by KEY
The range of cells to be quoted, the constant of replacement formula configuration, forms its across table formula；
The total formula logic module of row, the row for being used to form tissue dynamic statement adds up to formula logic, wherein to be closed
The column of meter are to eliminate the total column of column and the column total without row are separately configured, and to carry out total behavior will increase
The sub-line of adduction meter formula row, and the list does not include the sub-line met without adding up to；
Across table formula logic module is used to form across the table formula logic of tissue dynamic statement.
Preferably, the dynamic statement data configuration module includes,
Logic configuration module of fetching increases access logic allocation list, the allocation list for dynamic statement access logic configuration
Determine that report is counted according to which for recording configuration data is derived from which table or which view, and according to basic access logic
According to formation；
Multistage gauge outfit logic configuration module is arranged, dynamic statement is used to form and arranges multistage gauge outfit logic configuration, increase multi-level table
Head allocation list configures the multi-level table head formation rule of dynamic statement and is confirmed whether to need total column；
Detail column configuration module increases detail column allocation list, configures the detail of report for the column configuration of dynamic statement detail
Column, configuration column name, column formula and across table formula；
Row Classifying Sum configuration module is configured for dynamic statement row Classifying Sum, is increased row Classifying Sum allocation list, is matched
It sets the row Classifying Sum rule of report and whether needs total row；
Row unique identification configuration module is configured for dynamic statement row unique identification, is increased row unique identification allocation list, is matched
Set the row unique identification or unique identification rule of report；
Special ranks configuration module increases for the special ranks configuration in dynamic statement without executing formula without holding
The special ranks allocation list of row formula, configuration report are not necessarily to carry out total ranks and execute condition, configuration without execute across
The row and execution condition of table formula；
Program parses configuration module, is used to form program parsing configuration tissue dynamic statement and dynamic formula.
The method and system that dynamic statement formula assembling of the invention is made a report on have the advantage that
(1), the present invention solve the problems, such as dynamic formation report can not formula and table expert's formula between dynamic formation table, make
Report is not only according to data and configuration dynamic formation, but also formula between formula and table can be dynamically formed in table on guarantor's table, is suitble to
Unfixed ranks can only be according to data and service logic dynamic formation, while needing the report of some data of formula manipulation again
Table, it is no longer necessary to by formulating and submitting such report by hand, increase substantially the working efficiency of client, have and promote and apply valence well
Value；
(2), the present invention supports existing report form, report ranks and formula to support to configure, primary to realize
It is widely applied, there is stronger portability, while having expanded the range that report tool realizes report form type, increase substantially
Business personnel handles this type report working efficiency；
(3), configurable which ranks of report value table of the present invention, will obtain the value of which ranks of which report, and can match
It sets and carries out matched unique identification between value table and data source report；Formula content between configurable report table simultaneously allows public between table
Formula supports complicated formulas；
(4), the present invention realize report dynamic row (column) is configurable, the logical relation in report dynamic row (column) table can
Logical relation between configuration and report dynamic row-column list is configurable.
Detailed description of the invention
The following further describes the present invention with reference to the drawings.
Attached drawing 1 is the structural block diagram that system is made a report in the assembling of dynamic statement formula.
Specific embodiment
The method and system made a report on are assembled to dynamic statement formula of the invention referring to Figure of description and specific embodiment
It is described in detail below.
Embodiment 1:
Dynamic statement formula of the invention assembles the method made a report on, and this method comprises the following steps:
S1, every configuration is carried out to dynamic statement；Specifically include following content:
(1), dynamic statement access logic configuration: increase access logic allocation list, the allocation list is for recording configuration data
It is derived from which table or which view, and determines that report is formed according to which data according to basic access logic；Access is patrolled
Allocation list is collected to record using table FYBT_REPORT_RESOURCE, as shown in the table:
The table mainly configures report form figure selection table (view) and access logic, if report A fetches from table B_Table, item of fetching
Part is ' 1 ' AND D_COL=' 2 ' of C_COL=.
(2), it forms dynamic statement and arranges multistage gauge outfit logic configuration: increasing multistage gauge outfit allocation list, configure dynamic statement
Multi-level table head formation rule and being confirmed whether needs total column (such as: being grouped and summarize according to which or which field)；
Multistage gauge outfit allocation list is recorded using table FYBT_REPORT_COLGROUP, as shown in the table:
The table needs to configure when only report has multistage gauge outfit, as shown in the table:
The configuration content of multistage gauge outfit allocation list is as follows:
1., database column be month, group names form logic are as follows: counts stockpile number@Value@month, grouping needs
Adduction meter arranges (1)；Total column name are as follows: total, sortord is from small to large (0)；
2., database column be grade, group names formed logic are as follows:@grade of@Value, grouping without adduction meter column (0), arrange
Sequential mode is from small to large (0).
(3), dynamic statement detail column configuration: increasing detail column allocation list, configures the detail column of report, configuration column name, column
Formula and across table formula；
Detail column allocation list is recorded using table FYBT_REPORT_COL, as shown in the table:
The gauge outfit configuration content of detail column allocation list is as follows:
Database column name: quantity in stock, column name are empty (if configuration, can be further added by a line gauge outfit, not meet to be shown
Form), column type: Database field value (0), column rule are as follows: grouping field _ detail column field@GROUP@_@COL@.
(4), dynamic statement row Classifying Sum configures: increasing row Classifying Sum allocation list, configures the row Classifying Sum of report
Rule and whether need total row；
Row Classifying Sum allocation list is recorded using table FYBT_REPORT_ROWGROUP, as shown in the table:
The table needs to configure when only report has multistage gauge outfit, as shown in the table:
The gauge outfit configuration content of row Classifying Sum allocation list is as follows:
1., database column be tissue Internal Code: group names are as follows: company, grouping need adduction meter row (0)；Total column name
Are as follows: subtotal, sortord are from small to large (0)；
2., database column be post: group names formed logic are as follows: post, grouping be not necessarily to adduction meter row (0), sequence side
Formula is from small to large (0).
(5), dynamic statement row unique identification configures: increasing row unique identification allocation list, configures the row unique identification of report
Or unique identification rule；The KEY rule for configuring dynamic statement detail row, is recorded with table FYBT_REPORT_ROW, such as following table institute
Show:
Table configuration line KEY rule, table gauge outfit as above then need to configure；
Line discipline are as follows: grouping field (@GROUP@)
(6), it is configured in dynamic statement without executing the special ranks of formula: increasing and match without the special ranks for executing formula
Table is set, configuration report is not necessarily to carry out total ranks and executes condition, and configuration is without executing row and execution across table formula
Condition；Special ranks allocation list without executing formula is recorded using table FYBT_REPORT_HLCONF, as shown in the table:
Special ranks allocation list without executing formula does not execute unified formula shape for configuring special row or column
At；When ROW is total row, this formula is not executed, then configures trigger condition are as follows: ROW_KEY=GROUP_HJ, the place after triggering
Reason is to disregard fall in lines total (0).
(7), program parsing configuration tissue dynamic statement and dynamic formula, the specific steps are as follows:
1., according to configuration formed report ranks and ranks add up to formula；
2., according to configuration formed report need to form dynamic formula cell KEY value；
3., matched according to KEY value, obtain the cell to be quoted, and the formula needed is formed according to configuration.
S2, across table formula is formed, specific as follows:
1., all data are completed according to the configurations of each dynamic statement；
2., according to configuration ranks Classifying Sum rule and whether increase the regular basis of formation table sample of total row；
3., judge whether there is and be not counted in total ranks, form total ranks formula；
4., judge whether to need to form across table formula, form KEY；
5., pass through KEY and obtain the range of cells to be quoted, the constant of replacement formula configuration forms across table formula；
S3, the row of dynamic statement is organized to add up to formula logic, wherein carrying out total column, to have eliminated column total
The column total without row are arranged and are separately configured, and to carry out total behavior will increase the sub-line of total formula row, and should
List, which does not include, to be met without total sub-line；Partial key code is as follows:
S4, across the table formula logic for forming tissue dynamic statement, Partial key code are as follows:
Embodiment 2:
As shown in Fig. 1, system is made a report in dynamic statement formula assembling of the invention, which includes,
Data configuration module, the data configuration for dynamic statement；
Across table formula module, for completing all data according to the configurations of each dynamic statement, further according to configuration
Ranks Classifying Sums rule and the regular basis of formation table sample for whether increasing total row, then judge whether there is be not counted in it is total
Ranks, form total ranks formula；Judge whether to need to form across table formula again, forms KEY；It is obtained finally by KEY
The range of cells to be quoted, the constant of replacement formula configuration, forms its across table formula；
The total formula logic module of row, the row for being used to form tissue dynamic statement adds up to formula logic, wherein to be closed
The column of meter are to eliminate the total column of column and the column total without row are separately configured, and to carry out total behavior will increase
The sub-line of adduction meter formula row, and the list does not include the sub-line met without adding up to；
Across table formula logic module is used to form across the table formula logic of tissue dynamic statement.
Preferably, the dynamic statement data configuration module includes,
Logic configuration module of fetching increases access logic allocation list, the allocation list for dynamic statement access logic configuration
Determine that report is counted according to which for recording configuration data is derived from which table or which view, and according to basic access logic
According to formation；
Multistage gauge outfit logic configuration module is arranged, dynamic statement is used to form and arranges multistage gauge outfit logic configuration, increase multi-level table
Head allocation list configures the multi-level table head formation rule of dynamic statement and is confirmed whether to need total column；
Detail column configuration module increases detail column allocation list, configures the detail of report for the column configuration of dynamic statement detail
Column, configuration column name, column formula and across table formula；
Row Classifying Sum configuration module is configured for dynamic statement row Classifying Sum, is increased row Classifying Sum allocation list, is matched
It sets the row Classifying Sum rule of report and whether needs total row；
Row unique identification configuration module is configured for dynamic statement row unique identification, is increased row unique identification allocation list, is matched
Set the row unique identification or unique identification rule of report；
Special ranks configuration module increases for the special ranks configuration in dynamic statement without executing formula without holding
The special ranks allocation list of row formula, configuration report are not necessarily to carry out total ranks and execute condition, configuration without execute across
The row and execution condition of table formula；
Program parses configuration module, is used to form program parsing configuration tissue dynamic statement and dynamic formula.
Finally, it should be noted that the above embodiments are only used to illustrate the technical solution of the present invention., rather than its limitations；To the greatest extent
Pipe present invention has been described in detail with reference to the aforementioned embodiments, those skilled in the art should understand that: its according to
So be possible to modify the technical solutions described in the foregoing embodiments, or to some or all of the technical features into
Row equivalent replacement；And these are modified or replaceed, various embodiments of the present invention technology that it does not separate the essence of the corresponding technical solution
The range of scheme.
Claims (10)
1. dynamic statement formula assembles the method made a report on, which is characterized in that this method comprises the following steps:
S1, every configuration is carried out to dynamic statement；
S2, across table formula is formed, specific as follows:
1., all data are completed according to the configurations of each dynamic statement；
2., according to configuration ranks Classifying Sum rule and whether increase the regular basis of formation table sample of total row；
3., judge whether there is and be not counted in total ranks, form total ranks formula；
4., judge whether to need to form across table formula, form KEY；
5., pass through KEY and obtain the range of cells to be quoted, the constant of replacement formula configuration forms across table formula；
S3, organize the row of dynamic statement to add up to formula logic, wherein to carry out total column be eliminate the total column of column with
And the column total without row are separately configured, and to carry out total behavior will increase the sub-line of total formula row, and the list
Not comprising the sub-line met without adding up to；
S4, across the table formula logic for forming tissue dynamic statement.
2. dynamic statement formula according to claim 1 assembles the method made a report on, which is characterized in that the step S1 is to dynamic
State report carries out every configuration and specifically includes following content:
(1), dynamic statement access logic configuration: increasing access logic allocation list, which is derived from for recording configuration data
Which table or which view, and determine that report is formed according to which data according to basic access logic；
(2), it forms dynamic statement and arranges multistage gauge outfit logic configuration: increasing multistage gauge outfit allocation list, configure the multistage of dynamic statement
Gauge outfit formation rule and being confirmed whether needs total column；
(3), dynamic statement detail column configuration: increasing detail column allocation list, configures the detail column of report, configures column name, column formula
And across table formula；
(4), dynamic statement row Classifying Sum configures: increasing row Classifying Sum allocation list, configures the row Classifying Sum rule of report
And whether need total row；
(5), dynamic statement row unique identification configure: increase row unique identification allocation list, configure report row unique identification or
Unique identification rule；
(6), it is configured in dynamic statement without executing the special ranks of formula: increasing the special ranks configuration without executing formula
Table, configuration report are not necessarily to carry out total ranks and execute condition, and configuration is without executing the row across table formula and executing item
Part；
(7), program parsing configuration tissue dynamic statement and dynamic formula.
3. dynamic statement formula according to claim 2 assembles the method made a report on, which is characterized in that in the step (7)
Specific step is as follows for program parsing configuration tissue dynamic statement and dynamic formula:
1., according to configuration formed report ranks and ranks add up to formula；
2., according to configuration formed report need to form dynamic formula cell KEY value；
3., matched according to KEY value, obtain the cell to be quoted, and the formula needed is formed according to configuration.
4. dynamic statement formula according to claim 2 or 3 assembles the method made a report on, which is characterized in that the step (1)
Middle access logic allocation list is recorded using table FYBT_REPORT_RESOURCE.
5. dynamic statement formula according to claim 4 assembles the method made a report on, which is characterized in that in the step (2)
Multistage gauge outfit allocation list is recorded using table FYBT_REPORT_COLGROUP；
The configuration content of multistage gauge outfit allocation list is as follows:
1., database column be month, group names form logic are as follows: counts stockpile number@Value@month, be grouped and need adduction
Meter column；Total column name are as follows: total, sortord is from small to large；
2., database column be grade, group names formed logic are as follows:@grade of@Value, grouping without adduction meter column, sortord
For from small to large.
6. dynamic statement formula according to claim 5 assembles the method made a report on, which is characterized in that in the step (3)
Detail column allocation list is recorded using table FYBT_REPORT_COL；
The gauge outfit configuration content of detail column allocation list is as follows:
Database column name: quantity in stock, column name are sky, column type: Database field value, column rule are as follows: grouping field _ detail column
Field@GROUP@_@COL@.
7. dynamic statement formula according to claim 6 assembles the method made a report on, which is characterized in that in the step (4)
Row Classifying Sum allocation list is recorded using table FYBT_REPORT_ROWGROUP；
The gauge outfit configuration content of row Classifying Sum allocation list is as follows:
1., database column be tissue Internal Code: group names are as follows: company, grouping need adduction meter row；Total column name are as follows: subtotal,
Sortord is from small to large；
2., database column be post: group names form logic are as follows: post, grouping are not necessarily to adduction meter row, and sortord is from small
To big.
8. dynamic statement formula according to claim 7 assembles the method made a report on, which is characterized in that in the step (6)
Special ranks allocation list without executing formula is recorded using table FYBT_REPORT_HLCONF；
Special ranks allocation list without executing formula does not execute unified formula and is formed for configuring special row or column；When
When ROW is total row, this formula is not executed, then configures trigger condition are as follows: ROW_KEY=GROUP_HJ, the processing after triggering be,
Disregard fall in lines it is total.
9. system is made a report in a kind of assembling of dynamic statement formula, which is characterized in that the system includes,
Data configuration module, the data configuration for dynamic statement；
Across table formula module, for completing all data according to the configurations of each dynamic statement, further according to configuration ranks
Classifying Sum rule and the regular basis of formation table sample for whether increasing total row, then judge whether there is and be not counted in total row
Column form total ranks formula；Judge whether to need to form across table formula again, forms KEY；Obtaining it finally by KEY will draw
Range of cells, the constant of replacement formula configuration, forms its across table formula；
The total formula logic module of row, the row for being used to form tissue dynamic statement adds up to formula logic, wherein to carry out total
Column are to eliminate the total column of column and the column total without row are separately configured, and to carry out total behavior will increase conjunction
The sub-line of formula row is counted, and the list does not include the sub-line met without adding up to；
Across table formula logic module is used to form across the table formula logic of tissue dynamic statement.
10. system is made a report in dynamic statement formula assembling according to claim 9, which is characterized in that the dynamic statement number
Include according to configuration module,
Logic configuration module of fetching increases access logic allocation list, which is used for for dynamic statement access logic configuration
Record configuration data is derived from which table or which view, and determines which data shape report is according to according to basic access logic
At；
Multistage gauge outfit logic configuration module is arranged, dynamic statement is used to form and arranges multistage gauge outfit logic configuration, increase multistage gauge outfit and match
Table is set, the multi-level table head formation rule of dynamic statement is configured and is confirmed whether to need total column；
Detail column configuration module increases detail column allocation list for the column configuration of dynamic statement detail, configures the detail column of report,
Configure column name, column formula and across table formula；
Row Classifying Sum configuration module is configured for dynamic statement row Classifying Sum, increases row Classifying Sum allocation list, configuration report
The row Classifying Sum of table is regular and whether needs total row；
Row unique identification configuration module is configured for dynamic statement row unique identification, increases row unique identification allocation list, configuration report
Row unique identification or the unique identification rule of table；
Special ranks configuration module increases for the special ranks configuration in dynamic statement without executing formula without executing public affairs
The special ranks allocation list of formula, configuration report are not necessarily to carry out total ranks and execute condition, and configuration is without executing across table public affairs
The row and execution condition of formula；
Program parses configuration module, is used to form program parsing configuration tissue dynamic statement and dynamic formula.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811524792.7A CN109684616B (en) | 2018-12-13 | 2018-12-13 | Method and system for assembling and filling dynamic report formula |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811524792.7A CN109684616B (en) | 2018-12-13 | 2018-12-13 | Method and system for assembling and filling dynamic report formula |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN109684616A true CN109684616A (en) | 2019-04-26 |
| CN109684616B CN109684616B (en) | 2023-04-07 |
Family
ID=66187708
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811524792.7A Active CN109684616B (en) | 2018-12-13 | 2018-12-13 | Method and system for assembling and filling dynamic report formula |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109684616B (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110728122A (en) * | 2019-10-12 | 2020-01-24 | 京东数字科技控股有限公司 | Table generation method and device |
| CN111898348A (en) * | 2020-07-16 | 2020-11-06 | 厦门熵基科技有限公司 | Method, device, equipment and medium for dynamically assembling data report header |
| CN112580317A (en) * | 2020-12-29 | 2021-03-30 | 江苏金财信息技术有限公司 | Method for rapidly generating dynamic cross two-dimensional table with hierarchical summary |
| CN113779160A (en) * | 2021-08-24 | 2021-12-10 | 北京元年科技股份有限公司 | Method and device for acquiring data of multidimensional database |
| CN114416832A (en) * | 2022-01-26 | 2022-04-29 | 重庆允丰科技有限公司 | Method for configuring formula field and report and computer storage medium |
| WO2023280145A1 (en) * | 2021-07-06 | 2023-01-12 | 北京字跳网络技术有限公司 | Information citing method, system and apparatus, and electronic device |
| CN117436423A (en) * | 2023-11-06 | 2024-01-23 | 北京鑫陇科技有限公司 | Financial statement template formula configuration method and system, and statement generation method and system |
| CN117610519A (en) * | 2024-01-22 | 2024-02-27 | 山东浪潮数字商业科技有限公司 | Method and system for dynamically rendering report based on index model |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| AU2005220268A1 (en) * | 2005-10-10 | 2007-04-26 | Canon Kabushiki Kaisha | A method of applying a function to a set of data |
| CN105138501A (en) * | 2015-08-10 | 2015-12-09 | 北京思特奇信息技术股份有限公司 | Configurable dynamic report generating method and system |
| CN108491467A (en) * | 2018-03-06 | 2018-09-04 | 广州微易软件有限公司 | An a kind of key generates the method and platform of analysis of financial statement report |
-
2018
- 2018-12-13 CN CN201811524792.7A patent/CN109684616B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| AU2005220268A1 (en) * | 2005-10-10 | 2007-04-26 | Canon Kabushiki Kaisha | A method of applying a function to a set of data |
| CN105138501A (en) * | 2015-08-10 | 2015-12-09 | 北京思特奇信息技术股份有限公司 | Configurable dynamic report generating method and system |
| CN108491467A (en) * | 2018-03-06 | 2018-09-04 | 广州微易软件有限公司 | An a kind of key generates the method and platform of analysis of financial statement report |
Non-Patent Citations (2)
| Title |
|---|
| 成红伦等: "如何实现SAP ERP财务报表的灵活定制", 《电脑与电信》 * |
| 赵剑秋: "基于动态模板的利率报备系统的设计与实现", 《中国金融电脑》 * |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110728122A (en) * | 2019-10-12 | 2020-01-24 | 京东数字科技控股有限公司 | Table generation method and device |
| CN111898348A (en) * | 2020-07-16 | 2020-11-06 | 厦门熵基科技有限公司 | Method, device, equipment and medium for dynamically assembling data report header |
| CN112580317A (en) * | 2020-12-29 | 2021-03-30 | 江苏金财信息技术有限公司 | Method for rapidly generating dynamic cross two-dimensional table with hierarchical summary |
| WO2023280145A1 (en) * | 2021-07-06 | 2023-01-12 | 北京字跳网络技术有限公司 | Information citing method, system and apparatus, and electronic device |
| CN113779160A (en) * | 2021-08-24 | 2021-12-10 | 北京元年科技股份有限公司 | Method and device for acquiring data of multidimensional database |
| CN114416832A (en) * | 2022-01-26 | 2022-04-29 | 重庆允丰科技有限公司 | Method for configuring formula field and report and computer storage medium |
| CN114416832B (en) * | 2022-01-26 | 2022-11-15 | 重庆允丰科技有限公司 | Method for configuring formula field and report and computer storage medium |
| CN117436423A (en) * | 2023-11-06 | 2024-01-23 | 北京鑫陇科技有限公司 | Financial statement template formula configuration method and system, and statement generation method and system |
| CN117610519A (en) * | 2024-01-22 | 2024-02-27 | 山东浪潮数字商业科技有限公司 | Method and system for dynamically rendering report based on index model |
| CN117610519B (en) * | 2024-01-22 | 2024-05-03 | 山东浪潮数字商业科技有限公司 | Method and system for dynamically rendering report based on index model |
Also Published As
| Publication number | Publication date |
|---|---|
| CN109684616B (en) | 2023-04-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN109684616A (en) | Dynamic statement formula assembles the method and system made a report on | |
| CN113342821B (en) | Report configuration method, device, equipment and computer storage medium | |
| CN110633292B (en) | Query method, device, medium, equipment and system for heterogeneous database | |
| CN108038222B (en) | System of entity-attribute framework for information system modeling and data access | |
| US7406477B2 (en) | Database system with methodology for automated determination and selection of optimal indexes | |
| US8712972B2 (en) | Query optimization with awareness of limited resource usage | |
| CN101971165B (en) | Graphic representations of data relationships | |
| US8892544B2 (en) | Testing efficiency and stability of a database query engine | |
| US20120089612A1 (en) | Flexible fully integrated real-time document indexing | |
| CN110442620B (en) | Big data exploration and cognition method, device, equipment and computer storage medium | |
| CN107977441A (en) | The method for processing business and transaction processing system of rule-based engine | |
| CN108280234B (en) | Data query method and device | |
| US20120259865A1 (en) | Automated correlation discovery for semi-structured processes | |
| CN1987861A (en) | System and method for processing database query | |
| US11461333B2 (en) | Vertical union of feature-based datasets | |
| US7765219B2 (en) | Sort digits as number collation in server | |
| CN111858567A (en) | Method and system for cleaning government affair data through standard data elements | |
| CN103077192B (en) | A kind of data processing method and system thereof | |
| CN111061733A (en) | Data processing method and device, electronic equipment and computer readable storage medium | |
| CN105630986A (en) | Method for acquiring multidimensional data from database for grid display | |
| US8423567B1 (en) | Dynamic query data visualizer | |
| CN113297458A (en) | Paging query method, device and equipment | |
| CN112989775A (en) | Report generation method and system | |
| US20090164445A1 (en) | System and method to perform bulk operation database cleanup | |
| CN113360517A (en) | Data processing method and device, electronic equipment and storage medium |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| TA01 | Transfer of patent application right | ||
| TA01 | Transfer of patent application right |
Effective date of registration: 20230308 Address after: 250000 Langchao Road, Jinan, Shandong Applicant after: Inspur Genersoft Co.,Ltd. Address before: 250100 No. 2877 Kehang Road, Sun Village Town, Jinan High-tech District, Shandong Province Applicant before: SHANDONG INSPUR GENESOFT INFORMATION TECHNOLOGY Co.,Ltd. |
|
| GR01 | Patent grant | ||
| GR01 | Patent grant |