CN111126015B - Report form compiling method and equipment - Google Patents
Report form compiling method and equipment Download PDFInfo
- Publication number
- CN111126015B CN111126015B CN201911167471.0A CN201911167471A CN111126015B CN 111126015 B CN111126015 B CN 111126015B CN 201911167471 A CN201911167471 A CN 201911167471A CN 111126015 B CN111126015 B CN 111126015B
- Authority
- CN
- China
- Prior art keywords
- formula
- data elements
- access
- report
- source
- 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.)
- Active
Links
- 238000000034 method Methods 0.000 title claims abstract description 45
- 238000004364 calculation method Methods 0.000 claims description 17
- 230000015654 memory Effects 0.000 claims description 17
- 238000005215 recombination Methods 0.000 claims description 12
- 230000006798 recombination Effects 0.000 claims description 12
- 238000000354 decomposition reaction Methods 0.000 claims description 8
- 230000002085 persistent effect Effects 0.000 claims description 3
- 230000006403 short-term memory Effects 0.000 claims description 2
- 230000008569 process Effects 0.000 description 15
- 238000010586 diagram Methods 0.000 description 5
- 238000002360 preparation method Methods 0.000 description 5
- 238000004590 computer program Methods 0.000 description 3
- 230000008878 coupling Effects 0.000 description 3
- 238000010168 coupling process Methods 0.000 description 3
- 238000005859 coupling reaction Methods 0.000 description 3
- 230000008859 change Effects 0.000 description 2
- 238000004891 communication Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 2
- 238000000926 separation method Methods 0.000 description 2
- 230000006870 function Effects 0.000 description 1
- 230000003287 optical effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/242—Query formulation
- G06F16/2433—Query languages
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Abstract
The embodiment of the application discloses a report form compiling method. The method comprises the following steps: the method comprises the steps that an acquisition unit cell comprises a report of a number taking formula, wherein the number taking formula consists of operation symbols and a plurality of data elements, and element values of the data elements are required to be derived from a plurality of different reports; decomposing the fetch formula to obtain data elements included in the fetch formula; acquiring element values of the plurality of data elements from the different reports by using a parameter interface; filling element values of the plurality of data elements into the access formula to obtain an operation result corresponding to the access formula; and filling the operation result into the cells of the number taking formula in the report.
Description
Technical Field
Embodiments of the present disclosure relate to the field of computers, and in particular, to a report generating method, apparatus, and computer program product.
Background
The report may be expressed as: the report is equal to various access formulas and dynamic data, and is mainly characterized in that the data is dynamic, the access formulas are various, the complete separation of the report data and the access formulas can be realized, and a user can only modify the data so as to change the results obtained by all the access formulas related to the data, or only modify the access formulas so as to obtain the calculation results of the data under different relations. The report can clearly show the relation between the filled data, and has important effect in various fields.
The report is composed of cells, and the cells can only contain a fetch formula or only contain data. For a report containing an access formula, cells containing the access formula generally display the result obtained by calculating data according to the access formula. The process of calculating the data according to the fetch formula and filling the calculation result into the corresponding cell is called the report preparation process. The source of the data in the access formula can come from the self or other multiple reports, and for the case of multiple reports of the data source, the report preparation process needs to use a Structured Query Language (SQL) canvas type report tool. The specific process of using the SQL canvas reporting tool comprises: setting report keywords, inputting SQL sentences for generating reports, defining display patterns of the reports and the like. The SQL canvas type report tool can be used for obtaining specific data from a plurality of reports, performing operation according to the rule of a numerical formula, then filling the data into a required report, and displaying the report according to a defined display style.
When an SQL canvas type report tool is used for inputting an SQL sentence for generating a report, the conventional report compiling method needs to compile a calculation rule of a fetch formula by using an SQL language. However, many business people are not familiar with the SQL language, and report preparation work is inconvenient.
Disclosure of Invention
The first aspect of the embodiment of the application provides a report preparation method:
the method comprises the steps that an acquisition unit cell comprises a report of a number taking formula, wherein the number taking formula consists of operation symbols and a plurality of data elements, and element values of the data elements are required to be derived from a plurality of different reports;
decomposing the fetch formula to obtain data elements included in the fetch formula;
acquiring element values of the plurality of data elements from the different reports by using a parameter interface;
filling element values of the plurality of data elements into the access formula to obtain an operation result corresponding to the access formula;
and filling the operation result into the cells of the number taking formula in the report.
Optionally, according to the first aspect of the embodiment of the present application, the element value of the data element further includes a preset known value.
Based on the first aspect of the embodiments of the present application, optionally, the decomposing the access formula to obtain a data element included in the access formula includes:
performing operation recombination on each data element in the number taking formula to obtain a plurality of single-source number taking formulas; the single-source numerical formula consists of operation symbols and data elements, wherein the data elements contained in the single-source numerical formula are derived from the same report, and a plurality of single-source numerical formulas are connected through the operation symbols;
filling element values of the plurality of data elements into the access formula to obtain an operation result corresponding to the access formula, wherein the operation result comprises:
filling element values of data elements contained in the single-source access formula into the single-source access formula to obtain an operation result of the single-source access formula;
and calculating the operation results of the plurality of single-source access formulas by using operation symbols for connecting the plurality of single-source access formulas to obtain the operation results corresponding to the access formulas.
Optionally, according to the first aspect of the embodiment of the present application, after filling the operation result into the cells of the get formula in the report, the method further includes:
receiving a data element query request, wherein the data element query request points to the fetch formula;
and displaying the element value of the data element contained in the fetch formula.
A second aspect of the embodiments of the present application provides a report forming apparatus, including:
the report acquisition unit is used for acquiring a report with a cell containing a numerical formula, wherein the numerical formula consists of operation symbols and a plurality of data elements, and the element values of the data elements are required to be derived from a plurality of different reports;
the decomposition unit is used for decomposing the access formula to obtain data elements included in the access formula;
an element obtaining unit, configured to obtain element values of the plurality of data elements from the different reports using a parameter interface;
and the calculation unit is used for filling element values of the plurality of data elements into the number-taking formula to obtain an operation result corresponding to the number-taking formula, and filling the operation result into the cells of the number-taking formula in the report.
Optionally, according to a second aspect of the embodiment of the present application, the element value of the data element further includes a preset known value.
Based on the second aspect of the embodiments of the present application, optionally, the decomposing unit is configured to decompose the number-taking formula, and when obtaining the data element included in the number-taking formula, the decomposing unit is specifically configured to: performing operation recombination on each data element in the number taking formula to obtain a plurality of single-source number taking formulas; the single-source numerical formula consists of operation symbols and data elements, wherein the data elements contained in the single-source numerical formula are derived from the same report, and a plurality of single-source numerical formulas are connected through the operation symbols;
the calculation unit is configured to fill element values of the plurality of data elements into the access formula to obtain an operation result corresponding to the access formula, and when the operation result is filled into the cells of the access formula in the report, the calculation unit is specifically configured to:
filling element values of data elements contained in the single-source access formula into the single-source access formula to obtain an operation result of the single-source access formula, calculating operation results of a plurality of single-source access formulas by using operation symbols for connecting a plurality of single-source access formulas to obtain operation results corresponding to the access formulas, and filling the operation results into the cells of the access formulas in the report.
Based on the second aspect of the embodiments of the present application, optionally, a query unit is configured to receive a data element query request, where the data element query request points to the access formula; and displaying the element value of the data element contained in the fetch formula.
A third aspect of the embodiments of the present application provides a report preparing apparatus, including:
a central processing unit and a memory;
the memory is a short-term memory or a persistent memory;
the central processor is configured to communicate with the memory, and to execute instruction operations in the memory on the reporting device to perform the method of any of the first aspects of the embodiments of the present application.
A fourth aspect of the embodiments provides a computer program product comprising instructions which, when run on a computer, cause the computer to perform the method according to any of the first aspects of the embodiments of the present application.
From the above technical solutions, the embodiments of the present application have the following advantages: the business personnel can directly carry out the compiling process on the report containing the data from different reports in the filling and taking formulas, thereby obtaining the report which is completed by compiling, and the SQL canvas type report tool is not needed.
Drawings
FIG. 1 is a schematic flow chart of a report creating method according to an embodiment of the present application;
FIG. 2 is a schematic diagram of another flow chart of a report creating method according to an embodiment of the present application;
FIG. 3 is a schematic diagram of a report forming apparatus according to an embodiment of the present application;
FIG. 4 is another schematic diagram of a report forming apparatus according to an embodiment of the present application;
fig. 5 is another schematic structural diagram of the report forming apparatus according to the embodiment of the present application.
Detailed Description
The report may be expressed as: the report is equal to various access formulas and dynamic data, and is mainly characterized in that the data is dynamic, the access formulas are various, the complete separation of the report data and the access formulas can be realized, and a user can only modify the data so as to change the results obtained by all the access formulas related to the data, or only modify the access formulas so as to obtain the calculation results of the data under different relations. The report can clearly show the relation between the filled data, and has important effect in various fields.
For modern enterprise work, the information recorded and represented by a single report is limited, the number of reports generated in daily work is often large, and the data recorded or the generated result of one report is often used by a plurality of reports, for example, for a financial system, a detail report corresponding to each data in a total financial report of a financial accounting system, some specific data in each detail report also forms a total liability report or a total income report, and each detail report may also have a corresponding auxiliary report and other special reports generated by the accounting system.
The data contained in the report includes two types, one is basic data obtained through manual input or other sources, the other is processing data obtained through numerical formula processing on the basic data, the numerical formula is an important component part of the report, although the numerical formula is not necessarily embodied intuitively, the numerical formula is a relation among the basic data, and the data processed through the numerical formula is generally more valuable data which are more hopeful for users.
For base data that is reused multiple times in different reports, the report may be obtained by loading from the same source. For the processed data obtained by the taking formula, there is no fixed data source, but there is always a certain relation between the processed data on one report and the processed data on another report, and in this case, if the processed data is manually taken by the report builder, the workload will be great and the efficiency will be lower.
The method now employed is typically using a Structured Query Language (SQL) canvas type reporting tool. The specific process of using the SQL canvas reporting tool comprises: setting report keywords, inputting SQL sentences for generating reports, defining display patterns of the reports and the like. The SQL canvas type report tool can be used for obtaining specific data from a plurality of reports, performing operation according to the rule of a numerical formula, then filling the data into a required report, and displaying the report according to a defined display style.
When an SQL canvas type report tool is used for inputting an SQL sentence for generating a report, the conventional report compiling method needs to compile a calculation rule of a fetch formula by using an SQL language. However, many business personnel are not familiar with the SQL language, the more the number of reports of SQL on data sources, the longer the SQL language needs to be written, the more errors are likely to occur for manual operation, and the more inconvenience is brought to the compiling work.
Referring to fig. 1, a report compiling method provided in an embodiment of the present application includes: steps 101-105.
101. The acquisition unit cell contains a report of the fetch formula.
The unit cell is the minimum unit for forming the report, the unit cell contains data elements, the numerical formula consists of operation symbols and a plurality of data elements, the relation among different data elements is reflected, the obtained data elements contained in the numerical formula come from different reports, and the operation result of the numerical formula cannot be written for a common report.
102. And decomposing the access formula to obtain the data elements included in the access formula.
The method comprises the steps of decomposing a numerical formula containing data elements from different reports, wherein the numerical formula is formed by connecting operator numbers and data elements, the decomposition can obtain single data elements and operation symbols among the single data elements, and the single data elements have address attributes, namely the information of the report where the single data elements are located and the position information of the single data elements in the table.
103. Element values of the plurality of data elements are obtained from the different reports using a parameter interface.
And using different parameter interfaces for data elements from different sources, wherein the parameter interfaces enable element values among different reports to be mutually read, reading the report where the data elements are located and the numerical value of the data elements at the corresponding position of the report, and further obtaining the element values endowed with the data elements in the report so as to facilitate calculation.
104. And filling element values of the plurality of data elements into the access formula to obtain an operation result corresponding to the access formula.
And filling the element values obtained through the parameter interface into the original access formula according to the corresponding data element positions, namely replacing the original data elements with the element values represented by the data elements, so that the access formula can be normally identified and operated to obtain the operation result of the access formula.
105. And filling the operation result into the cells of the number taking formula in the report.
And replacing the number-taking formula in the cell with an operation result, namely obtaining the result of the operation formula, and completing the writing process of the number-taking formula.
According to the embodiment of the invention, the business personnel can directly carry out the compiling process on the report containing the data from different reports in the filling and taking formulas, so that the report which is completed by compiling is obtained.
Referring to fig. 2, a report compiling method provided in an embodiment of the present application includes: step 201-step 207.
201. The acquisition unit cell contains a report of the fetch formula.
The unit cell is the minimum unit for forming the report, the unit cell contains data elements, the number formula consists of operation symbols and a plurality of data elements, the relation among different data elements is reflected, the acquired data elements contained in the number formula come from different reports, the data elements come from the report are included, the element values of the data elements come from the report can be some constant values filled in the report generating process, the constant values can be directly acquired from the report, the parameter interface is not needed to be used for reading other reports, the operation load on a terminal is reduced, and the feasibility of the scheme is improved.
202. And carrying out operation recombination on each data element in the number taking formula to obtain a plurality of single-source number taking formulas.
The arithmetic and recombination are carried out on the arithmetic and recombination formulas to obtain a single-source arithmetic and recombination formula, and the single-source arithmetic and recombination formula is composed of arithmetic symbol data elements and data elements, wherein the difference is that the data elements contained in the single-source arithmetic and recombination formula are all from the same report.
For example, for the formula (A1+B1+A2+B2), where A1 and A2 originate from the same report, B1 and B2 originate from another report, the formula can be split into two single source formulas (A1+A2) and (B1+B2) according to the step, and the relationship between the two single source formulas can be determined as addition according to the original formulas.
All the corresponding element values of the data elements from the same report can be obtained in one report reading process, and the same report does not need to be read for multiple times to obtain a plurality of element values of the data elements from the same report. The operation resource of the terminal is saved, the requirement on the operation speed of the terminal is reduced, and the feasibility of the scheme is increased.
203. Element values of the plurality of data elements are obtained from the different reports using a parameter interface.
And using different parameter interfaces for data elements from different sources to obtain element values endowed by the data elements so as to facilitate calculation, and for the data elements in the same single-source numerical formula, only one report can be called, so that all element values in the single-source numerical formula corresponding to the report can be obtained.
204. Filling the element values of the data elements contained in the single-source access formula into the single-source access formula to obtain the operation result of the single-source access formula.
Filling the data elements contained in the obtained single-source access formula into the single-source access formula to obtain the single-source access formula in a connection form of numerical values and operation symbols, calculating and obtaining the operation result of the single-source access formula, and repeating the process for different single-source access formulas until the operation result of the single-source access formula obtained by operation recombination of all access formulas is obtained.
205. And calculating the operation results of a plurality of single-source number-taking formulas by using operation symbols of the single-source number-taking formulas to obtain the operation results corresponding to the number-taking formulas.
And calculating the numerical results of all the single-source access formulas contained in the access formulas, substituting the calculated minimum access formula result into the access formula which is calculated and recombined, and calculating the access formula substituted into the minimum access formula result by using the operation symbols which are connected with each single-source access formula after the access formula is calculated and recombined, so as to finally obtain the operation result of the access formula.
For the (a1+a2) and (b1+b2) obtained by splitting in the step 202, the numerical results of the two single-source numerical formulas can be obtained, that is, a and B, a is the numerical result obtained by calculation after substituting the element values of A1 and A2 into the element values of A1 and A2, B is the numerical result obtained by calculation after substituting the element values of B1 and B2, then the numerical formulas are used to be calculated and recombined, and the operation symbol connected with each single-source numerical formula is used to calculate the numerical formula substituted for the minimum numerical formula result, that is, the sum is performed, and finally the operation result of the numerical formulas is obtained.
206. And filling the operation result into the cells of the number taking formula in the report.
The arithmetic formula in the cell is replaced by the operation result, namely the result of the operation formula is obtained, and the writing process of the arithmetic formula is completed, so that a user can use the result of the arithmetic formula.
207. And receiving a data element query request, and displaying element values of the data elements contained in the access formula.
After the table completes the preparation of the access formula, the data source of the prepared access formula can be inquired, and the method specifically comprises the following steps: and receiving a data element query request, wherein the receiving request can have a special data element query button, or can directly click a result obtained by the access formula to process query, and after the data element query request is received, the report forms can display detailed information such as specific data elements of the access formula and data sources of the specific data elements, the element values and the like. The user can clearly know the detailed information of the report or check the report.
Referring to fig. 3, a report forming apparatus provided in an embodiment of the present application includes:
the report obtaining unit 301 is configured to obtain a report in which a cell includes a number formula, where the number formula includes an operation symbol and a plurality of data elements, and element values of the data elements need to be derived from a plurality of different reports;
a decomposition unit 302, configured to decompose the access formula to obtain a data element included in the access formula;
an element obtaining unit 303, configured to obtain element values of the plurality of data elements from the different reports using a parameter interface;
and the calculating unit 304 is configured to fill element values of the plurality of data elements into the access formula to obtain an operation result corresponding to the access formula, and fill the operation result into the cells of the access formula in the report.
In this embodiment, the process executed by each unit and module in the report preparing apparatus is similar to the report preparing process described in the embodiment shown in fig. 1, and will not be repeated here.
Referring to fig. 4, another report forming apparatus provided in an embodiment of the present application includes:
report acquisition unit 401, decomposition unit 402, element acquisition unit 403, calculation unit 404, and query unit 405. The execution flow of the report acquiring unit 401 and the element acquiring unit 403 is the same as that of the corresponding unit in fig. 3, and will not be repeated here.
A decomposition unit 402, configured to perform operation recombination on each data element in the number-taking formulas to obtain a plurality of single-source number-taking formulas; the single-source numerical formula consists of operation symbols and data elements, wherein the data elements contained in the single-source numerical formula are derived from the same report, and a plurality of single-source numerical formulas are connected through the operation symbols;
a calculation unit 404, configured to fill element values of data elements included in the single-source access formula into the single-source access formula to obtain an operation result of the single-source access formula, calculate operation results of the single-source access formula by using operation symbols for connecting the single-source access formulas to obtain an operation result corresponding to the access formula, and fill the operation result into the cells of the access formula in the report;
and a query unit 405, configured to receive a data element query request, where the data element query request points to the access formula and displays an element value of a data element included in the access formula.
In this embodiment, the process executed by each unit and module in the report preparing apparatus is similar to the report preparing process described in the embodiment shown in fig. 2, and will not be repeated here.
Fig. 5 is a schematic structural diagram of a report forming apparatus provided in an embodiment of the present application, where the server 500 may include one or more Central Processing Units (CPUs) 501 and a memory 505, and one or more application programs or data are stored in the memory 505.
In this embodiment, the specific functional module division in the central processor 501 may be similar to the functional module division of the units such as the information obtaining unit, the map obtaining unit, the association unit, and the generating unit described in fig. 5, and will not be repeated here.
Wherein the memory 505 may be volatile storage or persistent storage. The program stored in the memory 505 may include one or more modules, each of which may include a series of instruction operations on a server. Still further, the central processor 501 may be configured to communicate with the memory 505 and execute a series of instruction operations in the memory 505 on the server 500.
The server 500 may also include one or more power supplies 502, one or more wired or wireless network interfaces 503, one or more input/output interfaces 504, and/or one or more operating systems, such as Windows ServerTM, macOSXTM, unixTM, linuxTM, freeBSDTM, etc.
The cpu 501 may perform the operations performed by the geographic information system in the embodiment shown in fig. 5, which are not described herein.
Embodiments of the present application also provide a computer program product comprising computer software instructions that can be loaded by a processor to implement the flow of any of the report forming methods of fig. 1 and 2.
It will be clear to those skilled in the art that, for convenience and brevity of description, specific working procedures of the above-described systems, apparatuses and units may refer to corresponding procedures in the foregoing method embodiments, which are not repeated herein.
In the several embodiments provided in this application, it should be understood that the disclosed systems, apparatuses, and methods may be implemented in other ways. For example, the apparatus embodiments described above are merely illustrative, e.g., the division of the units is merely a logical function division, and there may be additional divisions when actually implemented, e.g., multiple units or components may be combined or integrated into another system, or some features may be omitted or not performed. Alternatively, the coupling or direct coupling or communication connection shown or discussed with each other may be an indirect coupling or communication connection via some interfaces, devices or units, which may be in electrical, mechanical or other form.
The units described as separate units may or may not be physically separate, and units shown as units may or may not be physical units, may be located in one place, or may be distributed on a plurality of network units. Some or all of the units may be selected according to actual needs to achieve the purpose of the solution of this embodiment.
In addition, each functional unit in each embodiment of the present application may be integrated in one processing unit, or each unit may exist alone physically, or two or more units may be integrated in one unit. The integrated units may be implemented in hardware or in software functional units.
The integrated units, if implemented in the form of software functional units and sold or used as stand-alone products, may be stored in a computer readable storage medium. Based on such understanding, the technical solution of the present application may be embodied in essence or a part contributing to the prior art or all or part of the technical solution in the form of a software product stored in a storage medium, including several instructions to cause a computer device (which may be a personal computer, a server, or a network device, etc.) to perform all or part of the steps of the methods described in the embodiments of the present application. And the aforementioned storage medium includes: a U-disk, a removable hard disk, a read-only memory (ROM), a Random Access Memory (RAM), a magnetic disk, or an optical disk, or the like, which can store program codes.
Claims (7)
1. A method of reporting, comprising:
the method comprises the steps that an acquisition unit cell comprises a report of a number taking formula, wherein the number taking formula consists of operation symbols and a plurality of data elements, and element values of the data elements are required to be derived from a plurality of different reports;
decomposing the fetch formula to obtain data elements included in the fetch formula;
acquiring element values of the plurality of data elements from the different reports by using a parameter interface;
filling element values of the plurality of data elements into the access formula to obtain an operation result corresponding to the access formula;
filling the operation result into the cells of the number formula in the report;
the decomposing the access formula to obtain the data elements included in the access formula comprises the following steps:
performing operation recombination on each data element in the number taking formula to obtain a plurality of single-source number taking formulas; the single-source numerical formula consists of operation symbols and data elements, wherein the data elements contained in the single-source numerical formula are derived from the same report, and a plurality of single-source numerical formulas are connected through the operation symbols;
filling element values of the plurality of data elements into the access formula to obtain an operation result corresponding to the access formula, wherein the operation result comprises:
filling element values of data elements contained in the single-source access formula into the single-source access formula to obtain an operation result of the single-source access formula;
and calculating the operation results of the plurality of single-source access formulas by using operation symbols for connecting the plurality of single-source access formulas to obtain the operation results corresponding to the access formulas.
2. The reporting method of claim 1 wherein the element values of the data elements further comprise a predetermined known value.
3. The report forming method according to claim 1, wherein said filling said operation result into said cells of said report with said fetch formula further comprises:
receiving a data element query request, wherein the data element query request points to the fetch formula;
and displaying the element value of the data element contained in the fetch formula.
4. A reporting apparatus, comprising:
the report acquisition unit is used for acquiring a report with a cell containing a numerical formula, wherein the numerical formula consists of operation symbols and a plurality of data elements, and the element values of the data elements are required to be derived from a plurality of different reports;
the decomposition unit is used for decomposing the access formula to obtain data elements included in the access formula;
an element obtaining unit, configured to obtain element values of the plurality of data elements from the different reports using a parameter interface;
the calculation unit is used for filling element values of the plurality of data elements into the number-taking formula to obtain an operation result corresponding to the number-taking formula, and filling the operation result into the cells of the number-taking formula in the report;
the decomposition unit is configured to decompose the access formula, and when obtaining a data element included in the access formula, the decomposition unit is specifically configured to: performing operation recombination on each data element in the number taking formula to obtain a plurality of single-source number taking formulas; the single-source numerical formula consists of operation symbols and data elements, wherein the data elements contained in the single-source numerical formula are derived from the same report, and a plurality of single-source numerical formulas are connected through the operation symbols;
the calculation unit is configured to fill element values of the plurality of data elements into the access formula to obtain an operation result corresponding to the access formula, and when the operation result is filled into the cells of the access formula in the report, the calculation unit is specifically configured to:
filling element values of data elements contained in the single-source access formula into the single-source access formula to obtain an operation result of the single-source access formula, calculating operation results of a plurality of single-source access formulas by using operation symbols for connecting a plurality of single-source access formulas to obtain operation results corresponding to the access formulas, and filling the operation results into the cells of the access formulas in the report.
5. The reporting device of claim 4 wherein the element values of the data elements further comprise preset known values.
6. The reporting device of claim 4, further comprising:
the query unit is used for receiving a data element query request, wherein the data element query request points to the fetch formula; and displaying the element value of the data element contained in the fetch formula.
7. A reporting apparatus, comprising:
a central processing unit and a memory;
the memory is a short-term memory or a persistent memory;
the central processor is configured to communicate with the memory, and to execute instruction operations in the memory on the reporting device to perform the method of any one of claims 1 to 3.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911167471.0A CN111126015B (en) | 2019-11-25 | 2019-11-25 | Report form compiling method and equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201911167471.0A CN111126015B (en) | 2019-11-25 | 2019-11-25 | Report form compiling method and equipment |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111126015A CN111126015A (en) | 2020-05-08 |
| CN111126015B true CN111126015B (en) | 2023-12-26 |
Family
ID=70496590
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201911167471.0A Active CN111126015B (en) | 2019-11-25 | 2019-11-25 | Report form compiling method and equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111126015B (en) |
Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103034553A (en) * | 2012-12-20 | 2013-04-10 | 厦门亿力吉奥信息科技有限公司 | Intelligent verification algorithm, method and device for report designer |
| CN104461538A (en) * | 2014-12-08 | 2015-03-25 | 畅捷通信息技术股份有限公司 | Report generation method and report generation system |
| CN105868174A (en) * | 2016-03-25 | 2016-08-17 | 浪潮通用软件有限公司 | Multi-unit statement parallel computation method and system |
| CN107491561A (en) * | 2017-09-25 | 2017-12-19 | 北京航空航天大学 | A kind of urban transportation heterogeneous data integrated system and method based on body |
| CN107967246A (en) * | 2016-10-19 | 2018-04-27 | 航天信息股份有限公司 | Report computational methods and device |
| CN108132777A (en) * | 2016-11-30 | 2018-06-08 | 上海驭创信息科技有限公司 | Across the table exploitation system and method for one kind |
| CN108170638A (en) * | 2017-12-21 | 2018-06-15 | 平安科技（深圳）有限公司 | Computational methods, device, equipment and storage medium based on Excel tables |
| CN108241742A (en) * | 2018-01-02 | 2018-07-03 | 联想(北京)有限公司 | Database inquiry system and method |
| CN109829144A (en) * | 2018-12-28 | 2019-05-31 | 陈德芹 | A kind of across table reference method and device of online table |
-
2019
- 2019-11-25 CN CN201911167471.0A patent/CN111126015B/en active Active
Patent Citations (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103034553A (en) * | 2012-12-20 | 2013-04-10 | 厦门亿力吉奥信息科技有限公司 | Intelligent verification algorithm, method and device for report designer |
| CN104461538A (en) * | 2014-12-08 | 2015-03-25 | 畅捷通信息技术股份有限公司 | Report generation method and report generation system |
| CN105868174A (en) * | 2016-03-25 | 2016-08-17 | 浪潮通用软件有限公司 | Multi-unit statement parallel computation method and system |
| CN107967246A (en) * | 2016-10-19 | 2018-04-27 | 航天信息股份有限公司 | Report computational methods and device |
| CN108132777A (en) * | 2016-11-30 | 2018-06-08 | 上海驭创信息科技有限公司 | Across the table exploitation system and method for one kind |
| CN107491561A (en) * | 2017-09-25 | 2017-12-19 | 北京航空航天大学 | A kind of urban transportation heterogeneous data integrated system and method based on body |
| CN108170638A (en) * | 2017-12-21 | 2018-06-15 | 平安科技（深圳）有限公司 | Computational methods, device, equipment and storage medium based on Excel tables |
| CN108241742A (en) * | 2018-01-02 | 2018-07-03 | 联想(北京)有限公司 | Database inquiry system and method |
| CN109829144A (en) * | 2018-12-28 | 2019-05-31 | 陈德芹 | A kind of across table reference method and device of online table |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111126015A (en) | 2020-05-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11714841B2 (en) | Systems and methods for processing a natural language query in data tables | |
| RU2408074C2 (en) | Method, system and apparatus for providing access to workbook models through remote function calls | |
| CN109766529B (en) | Report generation method and equipment | |
| CN111177231A (en) | Report generation method and report generation device | |
| CN111126019B (en) | Report generation method and device based on mode customization and electronic equipment | |
| CN110955410B (en) | Code automatic generation method, device, equipment and medium | |
| CN112287013A (en) | Data conversion method and adapter | |
| CN106055535B (en) | Chart generation method and device | |
| CN111367976A (en) | Method and device for exporting EXCEL file data based on JAVA reflection mechanism | |
| CN110806866A (en) | Generation method and device of front-end management system | |
| CN110704635B (en) | Method and device for converting triplet data in knowledge graph | |
| CN111126015B (en) | Report form compiling method and equipment | |
| US20120041989A1 (en) | Generating assessment data | |
| CN109697234B (en) | Multi-attribute information query method, device, server and medium for entity | |
| CN112926008A (en) | Method and device for generating form page, electronic equipment and storage medium | |
| CN112347748A (en) | Data report generation method and device, computer equipment and readable storage medium | |
| CN110555185A (en) | Page customization method and system based on PC client | |
| CN114116877B (en) | Data conversion method, device, computer equipment and medium | |
| CN106569785B (en) | Method and device for generating job form | |
| US20240104297A1 (en) | Analysis of spreadsheet table in response to user input | |
| CN115168673B (en) | Data graphical processing method, device, equipment and storage medium | |
| CN113326042B (en) | Method, device, storage medium and processor for visual configuration salary | |
| CN117540704A (en) | Data reverse perspective conversion method, device, equipment and medium of data table | |
| CN114330265A (en) | Typical case generation method and typical case template configuration method for asset evaluation | |
| CN114996758A (en) | Data desensitization method and device and electronic equipment |
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 | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |