CN111460778B - Method for processing data between reports - Google Patents
Method for processing data between reports Download PDFInfo
- Publication number
- CN111460778B CN111460778B CN202010241318.4A CN202010241318A CN111460778B CN 111460778 B CN111460778 B CN 111460778B CN 202010241318 A CN202010241318 A CN 202010241318A CN 111460778 B CN111460778 B CN 111460778B
- Authority
- CN
- China
- Prior art keywords
- task
- report
- month
- current
- acquiring
- 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
- 238000012545 processing Methods 0.000 title claims abstract description 45
- 238000000034 method Methods 0.000 title claims abstract description 24
- 238000004364 calculation method Methods 0.000 claims description 25
- 230000008520 organization Effects 0.000 claims description 12
- 230000003442 weekly effect Effects 0.000 claims description 9
- 239000003086 colorant Substances 0.000 claims description 3
- 230000000737 periodic effect Effects 0.000 claims description 3
- 238000003780 insertion Methods 0.000 description 4
- 230000037431 insertion Effects 0.000 description 4
- 238000005516 engineering process Methods 0.000 description 2
- 238000004321 preservation Methods 0.000 description 2
- 238000004458 analytical method Methods 0.000 description 1
- 238000011161 development Methods 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000010365 information processing Effects 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000006467 substitution reaction Methods 0.000 description 1
Landscapes
- Storage Device Security (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The embodiment of the invention discloses a method for processing data between reports, which comprises the following steps: acquiring a pre-stored inter-table access formula among a plurality of reports, wherein the inter-table access formula is used for marking a calling rule of specific data distributed in the plurality of reports; calling the specific data from the multiple reports according to the inter-table access formula; and processing the specific data to obtain a data processing result. The embodiment of the invention can call data from a plurality of reports, and realize interconnection and intercommunication of data among the cross-reports.
Description
Technical Field
The invention relates to the field of report data processing, in particular to a method for processing data between reports.
Background
With the continuous development of information technology, report data information processing is gradually increased. For example, in ERP (Enterprise Resource Planning) management systems, and in web applications, it is often necessary to present and modify report data via report tools, and report-like functionality is very widely used.
At present, most reports are subjected to operations such as data accounting and pulling in the present table, and if the business crossing the table is involved, the business is not guaranteed.
Disclosure of Invention
The embodiment of the invention provides a method for processing data among reports, which can call data from a plurality of reports and realize interconnection and intercommunication of data among the cross-reports.
The embodiment of the invention adopts the following technical scheme:
a method of inter-report data processing, comprising:
acquiring a pre-stored inter-table access formula among a plurality of reports, wherein the inter-table access formula is used for marking a calling rule of specific data distributed in the plurality of reports;
calling the specific data from the multiple reports according to the inter-table access formula;
and processing the specific data to obtain a data processing result.
Optionally, the table access formula includes:
the report types and report numbers of the multiple reports, and the cell positions, row numbers and column numbers of the specific data in the multiple reports;
and the report number selection range is the report with authority of the organization where the current user is located.
Optionally, the table access formula further includes: at least one of a task period, or a year and month date, a task number and a current level code;
the task number range is the task with authority of the current user; the task period selection range is determined according to the selected task type, and the task period represents a target task period determined by a user; the selection range of the current level code is the current level code of the task corresponding to the task number and the task period; the year and month date represents a difference between a target date determined by a user and a current date.
Optionally, the method further comprises: displaying the inter-table number formula in a cell, and matching different background colors according to the type of the inter-table number formula;
and saving the inter-table number formula into js object, wherein the js object position is report_variable.
Optionally, when the table access formula is stored, the version of the acquired data report is acquired according to the task corresponding to the task number and the task period, the corresponding row orde and column orde are acquired according to the cell position, and the row orde and column orde are inserted into the corresponding position of the table access formula for storage.
Optionally, if the specific data is periodic data, then:
when the current task type is daily report, acquiring the specific data from the daily report;
the current task type is five-day time reporting, and the specific data are acquired from the five-day time reporting;
when the current task type is a weekly report, acquiring the specific data from the weekly report;
when the current task type is a month report, acquiring the specific data from the month report, the season report and the year report;
when the current task type is a season report, acquiring the specific data from a month report, a season report and a year report;
and when the current task type is annual report, acquiring the specific data from the month report, the season report and the annual report.
Optionally, when the task type corresponding to the task number is the same as the current task type:
if the task type corresponding to the task number is daily report, calculating according to year, month and day to obtain the selected task period;
if the task number corresponds to the task type of five days, acquiring the filing date of the current period, and calculating to acquire the corresponding annual period when the year is not 0; when the month and the day are not 0, calculating and acquiring the filing date of the selected task period, and acquiring the selected task period, wherein the day is a multiple of 5 and is between 0 and-25;
if the task type corresponding to the task number is a weekly report, acquiring the filing date of the current period, and calculating to acquire the corresponding annual period when the year is not 0, wherein the month is ignored; dividing the day by the number of cycles of the 7 judgment interval when the day is 0 or a multiple of 7 and less than or equal to 0 and the day is not 0, and calculating and obtaining a target task period;
if the task type corresponding to the task number is a month report, calculating according to the year and month to obtain a target task period, wherein the month is between 0 and-11, and the day is ignored;
if the task number corresponds to the task type which is a quaternary report, calculating according to the year and month to obtain a target task period, wherein the date is ignored, the month is between 0 and-9 and is a multiple of 3, and the period number is divided by 3 during calculation;
and if the task type corresponding to the task number is annual report, calculating and acquiring a target task period according to the year, and neglecting month and day.
Optionally, when the task type corresponding to the task number is different from the current task type:
when the current task is a month report, if the selected task is a quarter report, calculating the quarter of the target month according to the year and month, obtaining the target task period, and neglecting the day, wherein the month is 0 or less than 0 and is a multiple of 3; if the selected task is a annual newspaper, acquiring data in the annual newspaper in the current year or the past few years, wherein the annual newspaper is 0 or less than 0, and the month and the day are ignored;
when the current task is a quarter report, if the selected task is a month report, acquiring the month in the current quarter according to the year and month, and neglecting the day, wherein the month is 0, -1 and-2; if the selected task is a annual newspaper, acquiring data in the annual newspaper in the current year or the past few years, wherein the annual newspaper is 0 or less than 0, and the month and the day are ignored;
when the current task is annual report, if the selected task is monthly report, acquiring month data in the current year or the last years according to the year and month, wherein the date is ignored, and the month is 0 and less than 0; if the selected task is a quarter report, the date is ignored according to the quarter of the year and month where the target date is acquired, and the month is 0 and less than 0.
Optionally, the processing the specific data to obtain a data processing result includes:
distinguishing multi-report calculation and single-report calculation, if the single-report calculation is performed, acquiring all inter-table number formulas in the report, and if the single-report calculation is performed, acquiring all reports with authority of the organization of the current user under the current task, and circularly performing inter-table number formula calculation on each report;
acquiring whether a target annual month date and a task period are set or not according to a defined inter-table access formula, and if so, obtaining the current report access formula as a cross-period access formula;
acquiring whether a target level code is set or not according to a defined inter-table access formula, and if so, obtaining the current report access formula as a cross-structure access formula;
acquiring whether the task number is set and is different from the current task number according to a defined inter-table access formula, and if so, obtaining the current report access formula as a cross-task access formula;
if the cross-task number formula is obtained, judging whether the data authority of the task corresponding to the task number exists or not;
if the task number is a cross-period number formula, judging whether to set the annual month date or the task period, and if the annual month date is set, calculating the task period of the date determined by the user according to the task type corresponding to the task number;
if the formula is a cross-organization formula, acquiring information of a cover of the target organization;
and acquiring a data result through the data query sql, organizing a formula calculation result, and obtaining the processing result together with other types of formula calculation results.
Optionally, after the specific data is processed to obtain a data processing result, the method further includes:
inserting the data processing result into an object formula result, wherein the format is HashMap type, the key is row-column order, and the value is the data processing result;
and inserting the data processing result into a report according to the content in the formula result, wherein the insertion time is before the insertion of the change data.
According to the method for processing the data among the reports based on the technical scheme, the inter-table access formula of calling rules for marking specific data distributed in the multiple reports among the prestored multiple reports is obtained, the specific data is called from the multiple reports according to the inter-table access formula, and the specific data is processed to obtain a data processing result, so that the data can be called from the multiple reports, and interconnection and intercommunication of the data among the cross-reports can be realized.
It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the disclosure.
Drawings
The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the invention and together with the description, serve to explain the principles of the invention.
FIG. 1 is a flowchart of a method for inter-report data processing according to an embodiment of the present invention;
fig. 2 is a table access formula preservation reference example provided in an embodiment of the present invention.
Detailed Description
Reference will now be made in detail to exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, the same numbers in different drawings refer to the same or similar elements, unless otherwise indicated. The implementations described in the following exemplary examples do not represent all implementations consistent with the invention. Rather, they are merely examples of apparatus and methods consistent with aspects of the invention as detailed in the accompanying claims.
As shown in FIG. 1, the method for processing data between reports according to this embodiment includes:
11. acquiring a pre-stored inter-table access formula among a plurality of reports, wherein the inter-table access formula is used for marking a calling rule of specific data distributed in the plurality of reports;
12. calling the specific data from the multiple reports according to the inter-table access formula;
13. and processing the specific data to obtain a data processing result.
According to the method for processing the data among the reports, the inter-table access formula of the calling rules for marking the specific data distributed in the multiple reports among the prestored multiple reports is obtained, the specific data is called from the multiple reports according to the inter-table access formula, and the specific data is processed to obtain the data processing result, so that the data can be called from the multiple reports, and interconnection and intercommunication of the data among the cross-reports can be realized.
In one embodiment, the inter-table access formula includes:
the report types (row change table, column change table, floating table, etc.) and report numbers of the multiple reports, and the cell positions, row numbers and column numbers of the specific data in the multiple reports;
and the report number selection range is the report with authority of the current user organization under the version of the selected task in the selection period.
In one embodiment, the inter-table access formula further comprises: at least one of a task period, or a year and month date, a task number and a current level code;
the task number range is the task with authority of the current user; the task period selection range is determined according to the selected task type, specifically, the task is defined before the report is defined, the task type is divided into daily report, monthly report, quarterly report and annual report, the task period is displayed differently according to different types, for example, daily report is 20200331, annual report is 2020; the task period represents a target task period determined by a user; the selection range of the current level code is the current level code of the task corresponding to the task number and the task period; the year and month date represents a difference between a target date determined by a user and a current date.
In one embodiment, the annual month date, the task number, the task period, the report type, the current level code and the report number are unnecessary items, and if not set, the current task period, the cover and the report information are all default to be empty strings in the formula. The cell information is a requisite item and represents the coordinates of a target cell, the formats are as B2 and C35, and the row numbers and the column numbers automatically acquire corresponding row ordes and column ordes according to the coordinates of the cell when the formula is stored. FIG. 2 is an example of a table-wise access formula preservation reference.
In one embodiment, further comprising: displaying the inter-table number formula in a cell (which can be selected by a user), and matching different background colors according to the type of the inter-table number formula; for example, the background color is blue (macro formula is light purple, basic formula is yellow, and analysis formula is white).
And saving the inter-table number formula into js object, wherein the js object position is report_variable.
In one embodiment, when the inter-table access formula is stored, the version of the acquired data report is acquired according to the task corresponding to the task number and the task period, the corresponding row orde and column orde are acquired according to the cell position, and the row orde and column orde are inserted into the corresponding position of the inter-table access formula to be stored.
In one embodiment, if the specific data is periodic data, then:
when the current task type is daily report, acquiring the specific data from the daily report;
the current task type is five-day time reporting, and the specific data are acquired from the five-day time reporting;
when the current task type is a weekly report, acquiring the specific data from the weekly report;
when the current task type is a month report, acquiring the specific data from the month report, the season report and the year report;
when the current task type is a season report, acquiring the specific data from a month report, a season report and a year report;
and when the current task type is annual report, acquiring the specific data from the month report, the season report and the annual report.
In one embodiment, when the task number corresponds to the same task type as the current task type:
if the task type corresponding to the task number is daily report, calculating according to year, month and day to obtain the selected task period;
if the task number corresponds to the task type of five days, acquiring the filing date of the current period, and calculating to acquire the corresponding annual period when the year is not 0; when the month and the day are not 0, calculating and acquiring the filing date of the selected task period, and acquiring the selected task period, wherein the day is a multiple of 5 and is between 0 and-25; if the current period is 2019004011008 (2019, 04, 06, 04, 10), and the time of year, month, day are-1, 10 respectively, the target task period is 2018005021008 (2018, 05, 16, 05, 20);
if the task type corresponding to the task number is a weekly report, acquiring the filing date of the current period, and calculating to acquire the corresponding annual period when the year is not 0, wherein the month is ignored; dividing the day by the number of cycles of the 7 judgment interval when the day is 0 or a multiple of 7 and less than or equal to 0 and the day is not 0, and calculating and obtaining a target task period; if the current period is 2019015002 (15 th week, 04 th month, 08 th month, 14 th month, 2019) and the year and day are-1 and-14 respectively, the target task period is 2018013002 (26 th month, 2018, 03, and 01 th month, 04 th month);
if the task type corresponding to the task number is a month report, calculating according to the year and month to obtain a target task period, wherein the month is between 0 and-11, and the day is ignored;
if the task number corresponds to the task type which is a quaternary report, calculating according to the year and month to obtain a target task period, wherein the date is ignored, the month is between 0 and-9 and is a multiple of 3, and the period number is divided by 3 during calculation;
and if the task type corresponding to the task number is annual report, calculating and acquiring a target task period according to the year, and neglecting month and day.
In this embodiment, the tasks may be classified into multiple types, and the calculation and the acquisition modes of the tasks are different, and the data is calculated and acquired in the current task type.
In one embodiment, when the task number corresponds to a task type that is different from the current task type:
when the current task is a month report, if the selected task is a quarter report, calculating the quarter of the target month according to the year and month, obtaining the target task period, and neglecting the day, wherein the month is 0 or less than 0 and is a multiple of 3; if the selected task is a annual newspaper, acquiring data in the annual newspaper in the current year or the past few years, wherein the annual newspaper is 0 or less than 0, and the month and the day are ignored;
when the current task is a quarter report, if the selected task is a month report, acquiring the month in the current quarter according to the year and month, and neglecting the day, wherein the month is 0, -1 and-2; if the selected task is a annual newspaper, acquiring data in the annual newspaper in the current year or the past few years, wherein the annual newspaper is 0 or less than 0, and the month and the day are ignored;
when the current task is annual report, if the selected task is monthly report, acquiring month data in the current year or the last years according to the year and month, wherein the date is ignored, and the month is 0 and less than 0; if the selected task is a quarter report, the date is ignored according to the quarter of the year and month where the target date is acquired, the month is 0 and less than 0, if the month is 0 to-2, the quarter is a fourth quarter, and the month is-6 to-8, and the quarter is a second quarter.
In one embodiment, the processing the specific data to obtain a data processing result includes:
distinguishing multi-report calculation and single-report calculation, if the single-report calculation is performed, acquiring all inter-table number formulas in the report, and if the single-report calculation is performed, acquiring all reports with authority of the organization of the current user under the current task, and circularly performing inter-table number formula calculation on each report; therefore, under the same task type, the user takes the number from the report with authority to view, and the condition of acquiring data by override is prevented.
Acquiring whether a target annual month date and a task period are set or not according to a defined inter-table access formula, and if so, obtaining the current report access formula as a cross-period access formula;
acquiring whether a target level code is set or not according to a defined inter-table access formula, and if so, obtaining the current report access formula as a cross-structure access formula;
acquiring whether the task number is set and is different from the current task number according to a defined inter-table access formula, and if so, obtaining the current report access formula as a cross-task access formula;
if the cross-task number formula is obtained, judging whether the data authority of the task corresponding to the task number exists or not;
if the task number is a cross-period number formula, judging whether to set the annual month date or the task period, and if the annual month date is set, calculating the task period of the date determined by the user according to the task type corresponding to the task number;
if the formula is a cross-organization formula, acquiring information of a cover of the target organization; specifically, the report is hung under the organization, and different organizations have own report and data, and if the number of the report and the data is required to be fetched across the organization, the report carries the identification information (cover) of the organization, so that the report and the data can be traced back to the target data conveniently.
Assembling the fetch sql according to the set content: SELECT nrprwbbsj_data, nrprwbbsj_ TEXT FROM NRPRWBBSJ WHERE NRPRWBBSJ _rwbh='? 'AND bbzd_bh='? 'AND sjzd_bh='? 'AND hzd_orde='? 'AND lzd_orde='? 'AND bbzd_date='? 'AND sjzd_bblx='? '.
And acquiring a data result through the data query sql, organizing a formula calculation result, and obtaining the processing result together with other types of formula calculation results.
In one embodiment, after the specific data is processed to obtain a data processing result, the method further includes:
inserting the data processing result into an object formula result, wherein the format is HashMap type, the key is row-column order, and the value is the data processing result;
and inserting the data processing result into a report according to the content in the formula result, wherein the insertion time is before the insertion of the change data.
The data configuration table structure of the embodiment of the invention is as follows:
according to the method for processing the data among the reports, the inter-table access formula of the calling rules for marking the specific data distributed in the multiple reports among the prestored multiple reports is obtained, the specific data is called from the multiple reports according to the inter-table access formula, and the specific data is processed to obtain the data processing result, so that the data can be called from the multiple reports, and interconnection and intercommunication of the data among the cross-reports can be realized.
The foregoing description of embodiments of the invention has been presented for purposes of illustration and description, and is not intended to be exhaustive or limited to the embodiments disclosed. Many modifications and variations will be apparent to those of ordinary skill in the art without departing from the scope and spirit of the various embodiments described. The terminology used herein was chosen in order to best explain the principles of the embodiments, the practical application, or the improvement of technology in the marketplace, or to enable others of ordinary skill in the art to understand the embodiments disclosed herein.
Any reference in this specification to "one embodiment," "an example embodiment," etc., means that a particular feature, structure, or characteristic described in connection with the embodiment is included in at least one embodiment of the invention. The appearances of such phrases in various places in the specification are not necessarily all referring to the same embodiment. Furthermore, when a particular feature, structure, or characteristic is described in connection with any embodiment, it is submitted that it is within the purview of one skilled in the art to effect such feature, structure, or characteristic in connection with the embodiment.
The foregoing is merely illustrative of the present invention, and the present invention is not limited thereto, and any person skilled in the art will readily recognize that variations or substitutions are within the scope of the present invention. Therefore, the protection scope of the invention is subject to the protection scope of the claims.
Claims (9)
1. A method for inter-report data processing, comprising:
acquiring a pre-stored inter-table access formula among a plurality of reports, wherein the inter-table access formula is used for marking a calling rule of specific data distributed in the plurality of reports;
calling the specific data from the multiple reports according to the inter-table access formula;
processing the specific data to obtain a data processing result;
the data processing result comprises the following steps:
distinguishing multi-report calculation and single-report calculation, if the single-report calculation is performed, acquiring all inter-table number formulas in the report, and if the single-report calculation is performed, acquiring all reports with authority of the organization of the current user under the current task, and circularly performing inter-table number formula calculation on each report;
acquiring whether a target annual month date and a task period are set or not according to a defined inter-table access formula, and if so, obtaining the current report access formula as a cross-period access formula;
acquiring whether a target level code is set or not according to a defined inter-table access formula, and if so, obtaining the current report access formula as a cross-structure access formula;
acquiring whether the task number is set and is different from the current task number according to a defined inter-table access formula, and if so, obtaining the current report access formula as a cross-task access formula;
if the cross-task number formula is obtained, judging whether the data authority of the task corresponding to the task number exists or not;
if the task number is a cross-period number formula, judging whether to set the annual month date or the task period, and if the annual month date is set, calculating the task period of the date determined by the user according to the task type corresponding to the task number;
if the formula is a cross-organization formula, acquiring information of a cover of the target organization;
and acquiring a data result through the data query sql, organizing a formula calculation result, and obtaining the processing result together with other types of formula calculation results.
2. The method of claim 1, wherein the inter-table access formula comprises:
the report types and report numbers of the multiple reports, and the cell positions, row numbers and column numbers of the specific data in the multiple reports;
and the report number selection range is the report with authority of the organization where the current user is located.
3. The method of claim 2, wherein the inter-table access formula further comprises: at least one of a task period, or a year and month date, a task number and a current level code;
the task number range is the task with authority of the current user; the task period selection range is determined according to the selected task type, and the task period represents a target task period determined by a user; the selection range of the current level code is the current level code of the task corresponding to the task number and the task period; the year and month date represents a difference between a target date determined by a user and a current date.
4. A method according to claim 3, further comprising: displaying the inter-table number formula in a cell, and matching different background colors according to the type of the inter-table number formula;
and saving the inter-table number formula into js object, wherein the js object position is report_variable.
5. The method of claim 4, wherein when the inter-table access formula is stored, the version of the acquired data report is acquired according to the task corresponding to the task number and the task period, the corresponding row orde and column orde are acquired according to the cell position, and the corresponding position of the inter-table access formula is inserted for storage.
6. The method of claim 4, wherein if the specific data is periodic data, then:
when the current task type is daily report, acquiring the specific data from the daily report;
the current task type is five-day time reporting, and the specific data are acquired from the five-day time reporting;
when the current task type is a weekly report, acquiring the specific data from the weekly report;
when the current task type is a month report, acquiring the specific data from the month report, the season report and the year report;
when the current task type is a season report, acquiring the specific data from a month report, a season report and a year report;
and when the current task type is annual report, acquiring the specific data from the month report, the season report and the annual report.
7. The method of claim 6, wherein the task number corresponds to a task type that is the same as a current task type:
if the task type corresponding to the task number is daily report, calculating according to year, month and day to obtain the selected task period;
if the task number corresponds to the task type of five days, acquiring the filing date of the current period, and calculating to acquire the corresponding annual period when the year is not 0; when the month and the day are not 0, calculating and acquiring the filing date of the selected task period, and acquiring the selected task period, wherein the day is a multiple of 5 and is between 0 and-25;
if the task type corresponding to the task number is a weekly report, acquiring the filing date of the current period, and calculating to acquire the corresponding annual period when the year is not 0, wherein the month is ignored; dividing the day by the number of cycles of the 7 judgment interval when the day is 0 or a multiple of 7 and less than or equal to 0 and the day is not 0, and calculating and obtaining a target task period;
if the task type corresponding to the task number is a month report, calculating according to the year and month to obtain a target task period, wherein the month is between 0 and-11, and the day is ignored;
if the task number corresponds to the task type which is a quaternary report, calculating according to the year and month to obtain a target task period, wherein the date is ignored, the month is between 0 and-9 and is a multiple of 3, and the period number is divided by 3 during calculation;
and if the task type corresponding to the task number is annual report, calculating and acquiring a target task period according to the year, and neglecting month and day.
8. The method according to claim 6 or 7, wherein the task number corresponds to a task type different from a current task type:
when the current task is a month report, if the selected task is a quarter report, calculating the quarter of the target month according to the year and month, obtaining the target task period, and neglecting the day, wherein the month is 0 or less than 0 and is a multiple of 3; if the selected task is a annual newspaper, acquiring data in the annual newspaper in the current year or the past few years, wherein the annual newspaper is 0 or less than 0, and the month and the day are ignored;
when the current task is a quarter report, if the selected task is a month report, acquiring the month in the current quarter according to the year and month, and neglecting the day, wherein the month is 0, -1 and-2; if the selected task is a annual newspaper, acquiring data in the annual newspaper in the current year or the past few years, wherein the annual newspaper is 0 or less than 0, and the month and the day are ignored;
when the current task is annual report, if the selected task is monthly report, acquiring month data in the current year or the last years according to the year and month, wherein the date is ignored, and the month is 0 and less than 0; if the selected task is a quarter report, the date is ignored according to the quarter of the year and month where the target date is acquired, and the month is 0 and less than 0.
9. The method of claim 8, wherein the processing the specific data to obtain a data processing result further comprises:
inserting the data processing result into an object formula result, wherein the format is HashMap type, the key is row-column order, and the value is the data processing result;
and inserting the data processing result into a report according to the content in the formulaseresult.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010241318.4A CN111460778B (en) | 2020-03-31 | 2020-03-31 | Method for processing data between reports |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN202010241318.4A CN111460778B (en) | 2020-03-31 | 2020-03-31 | Method for processing data between reports |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN111460778A CN111460778A (en) | 2020-07-28 |
| CN111460778B true CN111460778B (en) | 2023-11-14 |
Family
ID=71680134
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN202010241318.4A Active CN111460778B (en) | 2020-03-31 | 2020-03-31 | Method for processing data between reports |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN111460778B (en) |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101650709A (en) * | 2009-09-08 | 2010-02-17 | 北京九恒星科技股份有限公司 | Report generation method and report system |
| KR101829198B1 (en) * | 2016-08-29 | 2018-02-19 | (주)비아이매트릭스 | A metadata-based on-line analytical processing system for analyzing importance of reports |
| CN110781252A (en) * | 2019-11-05 | 2020-02-11 | 安徽数据堂科技有限公司 | Intelligent data analysis visualization method based on big data |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7895191B2 (en) * | 2003-04-09 | 2011-02-22 | International Business Machines Corporation | Improving performance of database queries |
-
2020
- 2020-03-31 CN CN202010241318.4A patent/CN111460778B/en active Active
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101650709A (en) * | 2009-09-08 | 2010-02-17 | 北京九恒星科技股份有限公司 | Report generation method and report system |
| KR101829198B1 (en) * | 2016-08-29 | 2018-02-19 | (주)비아이매트릭스 | A metadata-based on-line analytical processing system for analyzing importance of reports |
| CN110781252A (en) * | 2019-11-05 | 2020-02-11 | 安徽数据堂科技有限公司 | Intelligent data analysis visualization method based on big data |
Non-Patent Citations (3)
| Title |
|---|
| 吴忠玉 ; .EXCEL函数在用友ERP报表批量公式编辑中的应用.科技与企业.2015,(24),全文. * |
| 周健 ; 孟昭峰 ; .利用Excel进行自动分析计算的方法.中国管理信息化(会计版).2007,(04),全文. * |
| 孙永峰 ; .EXCEL软件在综自站监控机报表数据优化管理中的应用.内蒙古电力技术.2008,(05),全文. * |
Also Published As
| Publication number | Publication date |
|---|---|
| CN111460778A (en) | 2020-07-28 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20210109923A1 (en) | Contextual data visualization | |
| Alexander et al. | Excel dashboards and reports | |
| Fox et al. | Package ‘effects’ | |
| US7991672B2 (en) | System and method of visual illustration of stock market performance | |
| US7080328B1 (en) | Graphical user interface for filtering a population of items | |
| KR20190046957A (en) | Generating charts from data in a data table | |
| CN107729445B (en) | HTML 5-based large text reading positioning and displaying method | |
| US8645151B2 (en) | CO2 estimator module | |
| EP1220158A2 (en) | Automated generation of graphs from report data | |
| US20130293553A1 (en) | Visualizing data model sensitivity to variations in parameter values | |
| US20060080594A1 (en) | Methods, systems and computer program products for facilitating visualization of interrelationships in a spreadsheet | |
| US8654125B2 (en) | System and method of chart data layout | |
| DE102007011150A1 (en) | Method and system for managing data in a workflow process | |
| US20100131889A1 (en) | User interface to explore data objects and their related supplementary data objects | |
| US20190042632A1 (en) | Uniform chart formatting based on semantics in data models | |
| CN113822037B (en) | Method, device, equipment and medium for inserting placeholder and generating data mapping table | |
| CN109558441A (en) | Financial index automatic monitoring method, device, computer equipment and storage medium | |
| CN111460778B (en) | Method for processing data between reports | |
| US8838585B2 (en) | Project resource qualification and keyword scoring | |
| CN112883698B (en) | Chart generation method, apparatus, computer device and storage medium | |
| CN109814923B (en) | Data processing method, device, computer equipment and storage medium | |
| US8127227B1 (en) | Computerized method for dynamic content placement in a document | |
| US9430856B2 (en) | System comprising providing means for providing data to a user | |
| US9697271B2 (en) | Business intelligence reports with navigable reference indicators | |
| US20090172526A1 (en) | Methods and systems involving object attribute recognition |
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: 20231012 Address after: No. 1036, Shandong high tech Zone wave road, Ji'nan, 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 |