CN110427599A - The statistical method and device of report subtotal, storage medium, electronic device - Google Patents
The statistical method and device of report subtotal, storage medium, electronic device Download PDFInfo
- Publication number
- CN110427599A CN110427599A CN201910488962.9A CN201910488962A CN110427599A CN 110427599 A CN110427599 A CN 110427599A CN 201910488962 A CN201910488962 A CN 201910488962A CN 110427599 A CN110427599 A CN 110427599A
- Authority
- CN
- China
- Prior art keywords
- row
- data key
- metadata
- line
- subtotal
- 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.)
- Pending
Links
- 238000003860 storage Methods 0.000 title claims abstract description 17
- 238000007619 statistical method Methods 0.000 title claims abstract description 11
- 238000011156 evaluation Methods 0.000 claims abstract description 27
- 238000000034 method Methods 0.000 claims abstract description 27
- 230000015654 memory Effects 0.000 claims abstract description 22
- 238000004590 computer program Methods 0.000 claims description 15
- 238000007596 consolidation process Methods 0.000 claims description 7
- 238000005516 engineering process Methods 0.000 abstract description 9
- 238000010586 diagram Methods 0.000 description 10
- 230000006870 function Effects 0.000 description 9
- 238000012545 processing Methods 0.000 description 7
- 230000006399 behavior Effects 0.000 description 5
- 238000004422 calculation algorithm Methods 0.000 description 5
- 230000005540 biological transmission Effects 0.000 description 3
- 238000004891 communication Methods 0.000 description 3
- 230000036316 preload Effects 0.000 description 3
- 238000004364 calculation method Methods 0.000 description 2
- 238000005429 filling process Methods 0.000 description 2
- 230000000694 effects Effects 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000004321 preservation Methods 0.000 description 1
- 239000007787 solid Substances 0.000 description 1
- 238000012546 transfer Methods 0.000 description 1
- 230000001960 triggered effect Effects 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention provides a kind of statistical method of report subtotal and device, storage medium, electronic devices, wherein this method comprises: successively filling the data item of multiple metadata in target report since turning left line by line from column last initial row；Whether the second row data key of the first row data key and line n that judge the (n+1)th row are identical, wherein n is positive integer；It is different from the second row data key in the first row data key, and when identical second row data key is greater than 1, the small evaluation of the first metadata corresponding with multiple second row data key is counted in target report.Through the invention, it solves and counts the small evaluation technical problem excessive using memory in report in the related technology, so that efficient low-load solves the problems, such as that export needs subtotal.
Description
Technical field
The present invention relates to data processing fields, in particular to the statistical method and device, storage of a kind of report subtotal
Medium, electronic device.
Background technique
In the related technology, the function that subtotal function is necessarily present in the reporting system of complete function, for intuitively mentioning
Summarize data for local data.And export function simultaneously be also report capability necessary function, for be supplied to finance into
The production of row financial statement.
The report guiding system of the relevant technologies is adapted to different when realizing using the self-defined report based on metadata
The customized demand of client, and need precomputation to need a large amount of consumption memories because merging table, it is not often supported in export small
Count function.It is all first preloading data that subtotal in the related technology, which merges most of, then determines table according to data cases
Merge.And often data volume is larger for export, preloading data needs to consume a large amount of memories, reduces SaaS (Software-as-a-
Service) reliability of service and availability, so in the related technology, when export report needs to carry out subtotal statistics, being all
Manually it is arranged and counts in derived table.
For the above problem present in the relevant technologies, at present it is not yet found that the solution of effect.
Summary of the invention
The embodiment of the invention provides a kind of statistical method of report subtotal and device, storage medium, electronic devices.
According to one embodiment of present invention, a kind of statistical method of report subtotal is provided, comprising: since initial row
It turns left line by line from column last and successively fills the data item of multiple metadata in target report；Judge the first of the (n+1)th row
Whether row data key and the second row data key of line n are identical, wherein n is positive integer；The first row data key with
The second row data key is different, and when identical second row data key is greater than 1, in target report statistics with it is multiple described
The small evaluation of corresponding first metadata of second row data key.
Optionally, whether the second row data key of the first row data key and line n that judge the (n+1)th row are identical to include:
Inquire the second metadata in the target report；Judge the first row data of the (n+1)th row of the second metadata column
Whether key and the second row data key of line n are identical.
Optionally, the second metadata inquired in the target report includes: to turn left successively to inquire institute from column last
State the second metadata in target report.
Optionally, multiple first numbers are successively being filled in target report since turning left line by line from column last initial row
According to data item before, the method also includes: determine the multirow initial data in source database；Use second metadata
It sorts left to right as keyword to the multirow initial data.
Optionally, the subtotal of the first metadata corresponding with multiple second row data key is counted in target report
Value includes: that empty subtotal row is inserted between the (n+1)th row and line n of the target report；It is laterally closed on the subtotal row
And other sequential cells lattice in addition to cell where first metadata, statistics and multiple second row data key
The small evaluation of corresponding first metadata, and it is filled in the cell of the subtotal row Yu the first metadata column.
Optionally, it is inserted between the (n+1)th row and line n of the target report after empty subtotal row, the method
Further include: by multiple cell vertical consolidations where multiple second row data key at a cell.
Optionally, the subtotal of the first metadata corresponding with multiple second row data key is counted in target report
Value includes: the (n+1)th row filling subtotal row in the target report；From the second row data key institute on the subtotal row
The horizontal meaders cell before first row to first the first metadata after column；The column count for participating in subtotal is added 1, and longitudinal
Merge the cell where the second row data key.
Optionally, the method also includes: when the target report is filled to last line, judge identical the third line
Whether value is greater than 1, wherein the third line value is the row value of last line；Identical the third line value be greater than 1 when, statistics with
The small evaluation of corresponding first metadata of multiple the third line values.
According to another embodiment of the invention, a kind of statistic device of report subtotal is provided, comprising: filling module,
For successively filling the data item of multiple metadata in target report since turning left line by line from column last initial row；The
One judgment module, for judge the (n+1)th row the first row data key and line n the second row data key it is whether identical, wherein
N is positive integer；First statistical module, for different and identical in the first row data key and the second row data key
The second row data key when being greater than 1, statistics first yuan of number corresponding with multiple second row data key in target report
According to small evaluation.
Optionally, the first judgment module includes: query unit, the binary number for inquiring in the target report
According to；Judging unit, for judge the (n+1)th row of the second metadata column the first row data key and line n second
Whether row data key is identical.
Optionally, the query unit includes: inquiry subelement, successively inquires the mesh for turning left from column last
Mark the second metadata in report.
Optionally, described device further include: determining module, for the filling module since initial row line by line from fall
Number first row is turned left before the data item for successively filling multiple metadata in target report, determines that the multirow in source database is former
Beginning data；Sorting module, for using second metadata arrange by row to the multirow initial data as keyword
Sequence.
Optionally, first statistical module includes: generation module, for the (n+1)th row and n-th in the target report
Empty subtotal row is inserted between row；Statistical module, on the subtotal row horizontal meaders except where first metadata
Other sequential cells lattice except cell count the subtotal of the first metadata corresponding with multiple second row data key
Value, and it is filled in the cell of the subtotal row Yu the first metadata column.
Optionally, first statistical module further include: processing module is used in the generation module in the target report
It is inserted between the (n+1)th row and line n of table after empty subtotal row, by multiple lists where multiple second row data key
First lattice vertical consolidation is at a cell.
Optionally, described device further include: the second judgment module, for filling in the target report to last line
When, judge whether identical the third line value is greater than 1, wherein the third line value is the row value of last line；Second statistics mould
Block, for counting the subtotal of the first metadata corresponding with multiple the third line values when identical the third line value is greater than 1
Value.
According to still another embodiment of the invention, a kind of storage medium is additionally provided, meter is stored in the storage medium
Calculation machine program, wherein the computer program is arranged to execute the step in any of the above-described embodiment of the method when operation.
According to still another embodiment of the invention, a kind of electronic device, including memory and processor are additionally provided, it is described
Computer program is stored in memory, the processor is arranged to run the computer program to execute any of the above-described
Step in embodiment of the method.
Through the invention, multiple members are successively filled in target report since turning left line by line from column last initial row
The data item of data, and judge the (n+1)th row the first row data key and line n the second row data key it is whether identical, finally
It is different from the second row data key in the first row data key, and identical second row data key be greater than 1 when, generate
Subtotal item simultaneously counts small evaluation, merges algorithm by the subtotal of data flow line by line, data can achieve to be handled one by one, is not needed whole
Volume data preloads precomputation, small using memory, high-efficient, solves and is counted in report in small evaluation use in the related technology
Excessive technical problem is deposited, so that efficient low-load solves the problems, such as that export needs subtotal.
Detailed description of the invention
The drawings described herein are used to provide a further understanding of the present invention, constitutes part of this application, this hair
Bright illustrative embodiments and their description are used to explain the present invention, and are not constituted improper limitations of the present invention.In the accompanying drawings:
Fig. 1 is a kind of hardware block diagram of the statistic computer terminal of report subtotal of the embodiment of the present invention；
Fig. 2 is a kind of flow chart of the statistical method of report subtotal according to an embodiment of the present invention；
Fig. 3 is the schematic diagram of target report filling process of the embodiment of the present invention；
Fig. 4 is the schematic diagram that the embodiment of the present invention counts small evaluation in target report；
Fig. 5 is schematic diagram of target report after the completion of statistics in the embodiment of the present invention；
Fig. 6 is the structural block diagram of the statistic device of report subtotal according to an embodiment of the present invention.
Specific embodiment
Hereinafter, the present invention will be described in detail with reference to the accompanying drawings and in combination with Examples.It should be noted that not conflicting
In the case of, the features in the embodiments and the embodiments of the present application can be combined with each other.
It should be noted that description and claims of this specification and term " first " in above-mentioned attached drawing, "
Two " etc. be to be used to distinguish similar objects, without being used to describe a particular order or precedence order.
Embodiment 1
Embodiment of the method provided by the embodiment of the present application one can server, database facility, terminal or
It is executed in the similar arithmetic unit of person.For running on computer terminals, Fig. 1 is that a kind of report of the embodiment of the present invention is small
The hardware block diagram of the statistic computer terminal of meter.As shown in Figure 1, terminal 10 may include one or more (Fig. 1
In only show one) (processor 102 can include but is not limited to Micro-processor MCV or programmable logic device to processor 102
The processing unit of FPGA etc.) and memory 104 for storing data, optionally, above-mentioned terminal can also include using
In the transmission device 106 and input-output equipment 108 of communication function.It will appreciated by the skilled person that shown in Fig. 1
Structure be only illustrate, the structure of above-mentioned terminal is not caused to limit.For example, terminal 10 may also include
The more perhaps less component or with the configuration different from shown in Fig. 1 than shown in Fig. 1.
Memory 104 can be used for storing computer program, for example, the software program and module of application software, such as this hair
The corresponding computer program of statistical method of one of bright embodiment report subtotal, processor 102 are stored in by operation
Computer program in reservoir 104 realizes above-mentioned method thereby executing various function application and data processing.Storage
Device 104 may include high speed random access memory, may also include nonvolatile memory, as one or more magnetic storage device,
Flash memory or other non-volatile solid state memories.In some instances, memory 104 can further comprise relative to processing
The remotely located memory of device 102, these remote memories can pass through network connection to terminal 10.Above-mentioned network
Example includes but is not limited to internet, intranet, local area network, mobile radio communication and combinations thereof.
Transmitting device 106 is used to that data to be received or sent via a network.Above-mentioned network specific example may include
The wireless network that the communication providers of terminal 10 provide.In an example, transmitting device 106 includes that a network is suitable
Orchestration (Network Interface Controller, referred to as NIC), can be connected by base station with other network equipments from
And it can be communicated with internet.In an example, transmitting device 106 can be radio frequency (Radio Frequency, abbreviation
For RF) module, it is used to wirelessly be communicated with internet.
A kind of statistical method of report subtotal is provided in the present embodiment, and Fig. 2 is one kind according to an embodiment of the present invention
The flow chart of the statistical method of report subtotal, as shown in Fig. 2, the process includes the following steps:
Since step S202 successively fill multiple first numbers turn left line by line from column last initial row in target report
According to data item；
In the present embodiment, the corresponding metadata of each column of report, metadata is the description title of the data item of report,
Under the same metadata, the data item of every data line is same or different, if metadata includes: unit price, the amount of money, and odd numbers etc.,
Unit price may be filled with 0.1,0.2,0.3 etc. again in every data line.
Whether the second row data key of step S204, the first row data key and line n that judge the (n+1)th row are identical,
In, n is positive integer；
The line n of the present embodiment is any row of storing data, and the (n+1)th row is then next line adjacent thereto, the first row
Data key and the second row data key, that is, data key of the metadata respectively in the data item of the (n+1)th row and line n, table are
What the value of all dimensions column of participation subtotal was formed with space-separated.The target report of the present embodiment preserves a plurality of data, often
Data carries out preservation filling with behavior unit, and every data is made of multiple data item corresponding with metadata, such as purchases clear
Dan Zhong, each data include purchaser, purchase odd numbers, and the date purchases item, the amount of money, unit price etc..
In the present embodiment, every row key point is n grade in the table of n column, key be exactly from left to right each unit lattice value add it is empty
Lattice connection, for example, the data of certain row are abc in the table of three column, key points are 3 grades, and being respectively as follows: 1 grade of key is a；2 grades of key are
ab；3 grades of key are abc.
Step S206, it is different from the second row data key in the first row data key, and identical second row data key is greater than
When 1, the small evaluation of the first metadata corresponding with multiple second row data key is counted in target report.
The target report of the present embodiment is the table where the data item filled, and multiple second row data key columns are
The column of subtotal statistics are participated in, e.g., quantity, the amount of money, number etc..
Through the above steps, since initial row line by line from it is last column turn left successively filled in target report it is multiple
The data item of metadata, and judge the (n+1)th row the first row data key and line n the second row data key it is whether identical, most
It is different from the second row data key in the first row data key afterwards, and when identical second row data key is greater than 1, it is raw
At subtotal item and small evaluation is counted, algorithm is merged by the subtotal of data flow line by line, data can achieve to be handled one by one, is not needed
Overall data preloads precomputation, small using memory, high-efficient, solves and counts small evaluation use in report in the related technology
The excessive technical problem of memory, so that efficient low-load solves the problems, such as that export needs subtotal.
Optionally, the executing subject of above-mentioned steps can be server, such as data processing server, management server, number
According to transfer platform, data export platform, data settlement platform etc., but not limited to this.
Fig. 3 is the schematic diagram of target report filling process of the embodiment of the present invention, and in one example, target table is " to ask
It buys foreign exchange summary table ".First behavior header line of entire table, the second behavior description row, the first row and the second behavior are pre-set
, the third line and fourth line of table are the row where metadata, and metadata includes: shelves mouth title, odd numbers, and article code is ordered
Goods please purchase quantity, arrival date etc., and the metadata of last column is arrival date, and the fifth line of entire table is initial row, often
A line is sequentially filled " shops's title " since " arrival date ".
In the present embodiment, whether the second row data key of the first row data key and line n that judge the (n+1)th row are identical
Include:
S11 inquires the second metadata in target report；
Second metadata of the present embodiment is pre-set subtotal item, is illustrated herein with Fig. 3, setting " shops's name
Claim ", " shelves mouth title ", " coding " is the second metadata, then needs to count the multiple identical shops's titles of output, identical shelves mouth respectively
Title, the data item of the first metadata of identical coding.
Optionally, the second metadata inquired in target report includes: to turn left successively to inquire target report from column last
The second metadata in table.Column last in the present embodiment are the column last of storing data item in target report,
Empty data column is not in the discussion range of the present embodiment.
S12 judges the first row data key of the (n+1)th row of the second metadata column and the second row data of line n
Whether key is identical.
It is herein that " coding " is illustrated with the second metadata in Fig. 3, the row value of the column fifth line is " zz3068 ", the
Six rows are identical as fifth line, the 7th behavior " x0012629 ", different from the 6th row.In Fig. 3, the first metadata includes " ordering goods
Please purchase quantity ", then the small evaluation that please purchase quantity of fifth line and the 6th row is 22.
In the present embodiment, since initial row line by line from it is last column turn left successively in target report fill it is more
Before the data item of a metadata, further includes: determine the multirow initial data in source database；Use the second metadata as pass
Key word sorts left to right to multirow initial data.
Basic data of the present embodiment in target table is extracted from source database, and data are stored with more in source database
Row data, each row data are unordered or sort according to the sequence such as time, but there is no the data after subtotal.
In an embodiment of the present embodiment, count corresponding with multiple second row data key in target report
The small evaluation of first metadata includes:
S21 is inserted into empty subtotal row between the (n+1)th row and line n of target report；
S22, other sequential cells lattice of horizontal meaders in addition to cell where the first metadata on subtotal row, statistics
The small evaluation of the first metadata corresponding with multiple second row data key, and it is filled in subtotal row and the first metadata column
Cell.Optionally, it is inserted between the (n+1)th row and line n of target report after empty subtotal row, further includes: will be more
Multiple cell vertical consolidations where a second row data key are at a cell.
In one example, the starting of the subtotal row is classified as the next column of the second row data key column, or starting column
For the second row data key column.
Fig. 4 is the schematic diagram that the embodiment of the present invention counts small evaluation in target report, wherein fifth line and the 6th row
Row value " zz3068 " is identical, and more than one " zz3068 ", then generates subtotal row, and having counted the first metadata, " order please purchase number
Amount ", " standard please purchase quantity ", the data item of " auxiliary please purchase quantity ", and it is filled in the subtotal row of the first metadata, it is respectively as follows:
22,6.6,8.
In the another embodiment of the present embodiment, count corresponding with multiple second row data key in target report
The small evaluation of the first metadata include:
S31 fills subtotal row in the (n+1)th row of target report；
S32, on subtotal row before first row to first the first metadata after the second row data key column laterally
Merge Cells；
The column count for participating in subtotal is added 1, and the cell where vertical consolidation the second row data key by S33.
Fig. 5 is schematic diagram of target report after the completion of statistics in the embodiment of the present invention, wherein the first metadata includes
" order please purchase quantity ", " standard please purchase quantity ", " auxiliary please purchase quantity ", the second metadata include " title ", " coding ", " shelves
Mouth title ".
In the present embodiment, method further include: when target report is filled to last line, judge identical the third line value
Whether 1 is greater than, wherein the third line value is the row value of last line；When identical the third line value is greater than 1, statistics and multiple the
The small evaluation of corresponding first metadata of three row values.
The scheme of the present embodiment is to be based on metadata self-defined report, and realize the subtotal based on data flow and merge list
First lattice algorithm, the subtotal based on data flow merge algorithm, and data can achieve to be handled one by one, do not need overall data and preload in advance
It calculates, so that efficient low-load solves the problems, such as that export needs subtotal.Subtotal merge algorithm main flow be from the right side to
Whether left transverse direction inverted order is inserted into data line by line, repeat to merge by comparing upper data each column content and newly-increased subtotal is arranged
Number.
The scheme combination specific example of the present embodiment is completely illustrated below, comprising:
Step 1: data are turned left from the right side according to metadata column and are filled line by line.Every column data has the map object of oneself
User saves the data that data last line is inserted into when column.It is compared first with the value that has in map when filling.If hair
Present worth is identical, and then to the line number of the column, count is incremented；If it find that current row value is different from lastrow and line number is greater than 1 and triggers conjunction
And.
Step 2: it executes and merges operation, be broadly divided into two steps:
The first step, it is necessary first to fill subtotal row, and the horizontal meaders on subtotal row, combined region is small from participating in
After the column of meter before first row to first digit index, this Merge Cells is the Chinese character unit lattice of " subtotal ".In lateral conjunction
And later, add 1 to the column count for participating in subtotal；Second step, the column for participating in subtotal longitudinally start to merge.Combined height is column meter
Number.
Step 3: the column count from current and later side by side all column is emptied after the completion of merging.And it is according to new data
New data are saved when forefront creates new map object.
Step 4: calculating small evaluation: based on the data of the column calculated by all parameter subtotals, and being to separate with space
Symbol, in the key that is classified as the numerical index that joint needs to count, (this key is exactly the key compared for subtotal, adjacent rows data
Comparison, that is, compare this key), creation key is string, and value is the map of number for counting.There is no data line to insert
Enter, is just that the numerical index counted is needed to add up according to rule above.In subtotal row horizontal meaders after merging triggering
A lattice after cell insert corresponding number.
Step 1- step 4 is recycled according to data line by line until data inputting finishes.
Step 5, last line data are handled.Because merging is the data-triggered to be newly inserted, last line data
Merging process can be omitted, thus need to simulate a data for trigger merging.Check participation one by one first since the rightmost side
The column count of subtotal column, needs to merge if arranging and being greater than 1.Merge process and above-mentioned steps 1- step 4 is identical, eventually arrives at table
Lattice leftmost column terminates.
Through the above description of the embodiments, those skilled in the art can be understood that according to above-mentioned implementation
The method of example can be realized by means of software and necessary general hardware platform, naturally it is also possible to by hardware, but it is very much
In the case of the former be more preferably embodiment.Based on this understanding, technical solution of the present invention is substantially in other words to existing
The part that technology contributes can be embodied in the form of software products, which is stored in a storage
In medium (such as ROM/RAM, magnetic disk, CD), including some instructions are used so that a terminal device (can be mobile phone, calculate
Machine, server or network equipment etc.) execute method described in each embodiment of the present invention.
Embodiment 2
A kind of statistic device of report subtotal is additionally provided in the present embodiment, it is for realizing above-described embodiment and preferably real
Mode is applied, the descriptions that have already been made will not be repeated.As used below, the soft of predetermined function may be implemented in term " module "
The combination of part and/or hardware.Although device described in following embodiment is preferably realized with software, hardware, or
The realization of the combination of software and hardware is also that may and be contemplated.
Fig. 6 is the structural block diagram of the statistic device of report subtotal according to an embodiment of the present invention, can apply server,
Terminal etc., as shown in fig. 6, the device includes:
Module 60 is filled, for filling to be more in target report since turning left successively from column last line by line initial row
The data item of a metadata；
First judgment module 62, for judging that the first row data key and the second row data key of line n of the (n+1)th row be
It is no identical, wherein n is positive integer；
First statistical module 64, for different and identical in the first row data key and the second row data key
The second row data key when being greater than 1, statistics first yuan of number corresponding with multiple second row data key in target report
According to small evaluation.
In an optional embodiment of the present embodiment, the first judgment module includes: query unit, for inquiring
The second metadata in the target report；Judging unit, of the (n+1)th row for judging the second metadata column
Whether data line key and the second row data key of line n are identical.
Optionally, the query unit includes: inquiry subelement, successively inquires the mesh for turning left from column last
Mark the second metadata in report.
Optionally, described device further include: determining module, for the filling module since initial row line by line from fall
Number first row is turned left before the data item for successively filling multiple metadata in target report, determines that the multirow in source database is former
Beginning data；Sorting module, for using second metadata arrange by row to the multirow initial data as keyword
Sequence.
Optionally, first statistical module includes: generation module, for the (n+1)th row and n-th in the target report
Empty subtotal row is inserted between row；Statistical module, on the subtotal row horizontal meaders except where first metadata
Other sequential cells lattice except cell count the subtotal of the first metadata corresponding with multiple second row data key
Value, and it is filled in the cell of the subtotal row Yu the first metadata column.
Optionally, first statistical module further include: processing module is used in the generation module in the target report
It is inserted between the (n+1)th row and line n of table after empty subtotal row, by multiple lists where multiple second row data key
First lattice vertical consolidation is at a cell.
Optionally, described device further include: the second judgment module, for filling in the target report to last line
When, judge whether identical the third line value is greater than 1, wherein the third line value is the row value of last line；Second statistics mould
Block, for counting the subtotal of the first metadata corresponding with multiple the third line values when identical the third line value is greater than 1
Value.
It should be noted that above-mentioned modules can be realized by software or hardware, for the latter, Ke Yitong
Following manner realization is crossed, but not limited to this: above-mentioned module is respectively positioned in same processor；Alternatively, above-mentioned modules are with any
Combined form is located in different processors.
Embodiment 3
The embodiments of the present invention also provide a kind of storage medium, computer program is stored in the storage medium, wherein
The computer program is arranged to execute the step in any of the above-described embodiment of the method when operation.
Optionally, in the present embodiment, above-mentioned storage medium can be set to store by executing based on following steps
Calculation machine program:
Since S1 successively fill the number of multiple metadata turn left line by line from column last initial row in target report
According to item；
Whether the second row data key of S2, the first row data key and line n that judge the (n+1)th row are identical, wherein n is
Positive integer；
S3, it is different from the second row data key in the first row data key, and identical second row data key is big
When 1, the small evaluation of the first metadata corresponding with multiple second row data key is counted in target report.
Optionally, in the present embodiment, above-mentioned storage medium can include but is not limited to: USB flash disk, read-only memory (Read-
Only Memory, referred to as ROM), it is random access memory (Random Access Memory, referred to as RAM), mobile hard
The various media that can store computer program such as disk, magnetic or disk.
The embodiments of the present invention also provide a kind of electronic device, including memory and processor, stored in the memory
There is computer program, which is arranged to run computer program to execute the step in any of the above-described embodiment of the method
Suddenly.
Optionally, above-mentioned electronic device can also include transmission device and input-output equipment, wherein the transmission device
It is connected with above-mentioned processor, which connects with above-mentioned processor.
Optionally, in the present embodiment, above-mentioned processor can be set to execute following steps by computer program:
Since S1 successively fill the number of multiple metadata turn left line by line from column last initial row in target report
According to item；
Whether the second row data key of S2, the first row data key and line n that judge the (n+1)th row are identical, wherein n is
Positive integer；
S3, it is different from the second row data key in the first row data key, and identical second row data key is big
When 1, the small evaluation of the first metadata corresponding with multiple second row data key is counted in target report.
Optionally, the specific example in the present embodiment can be with reference to described in above-described embodiment and optional embodiment
Example, details are not described herein for the present embodiment.
Obviously, those skilled in the art should be understood that each module of the above invention or each step can be with general
Computing device realize that they can be concentrated on a single computing device, or be distributed in multiple computing devices and formed
Network on, optionally, they can be realized with the program code that computing device can perform, it is thus possible to which they are stored
It is performed by computing device in the storage device, and in some cases, it can be to be different from shown in sequence execution herein
Out or description the step of, perhaps they are fabricated to each integrated circuit modules or by them multiple modules or
Step is fabricated to single integrated circuit module to realize.In this way, the present invention is not limited to any specific hardware and softwares to combine.
The foregoing is only a preferred embodiment of the present invention, is not intended to restrict the invention, for the skill of this field
For art personnel, the invention may be variously modified and varied.It is all within principle of the invention, it is made it is any modification, etc.
With replacement, improvement etc., should all be included in the protection scope of the present invention.
Claims (10)
1. a kind of statistical method of report subtotal characterized by comprising
The data item of multiple metadata is successively filled in target report since turning left line by line from column last initial row；
Whether the second row data key of the first row data key and line n that judge the (n+1)th row are identical, wherein n is positive integer；
It is different from the second row data key in the first row data key, and identical second row data key be greater than 1 when,
The small evaluation of the first metadata corresponding with multiple second row data key is counted in target report.
2. the method according to claim 1, wherein judging the first row data key and line n of the (n+1)th row
Whether the second row data key is identical to include:
Inquire the second metadata in the target report；
The second row data key of the first row data key and line n that judge the (n+1)th row of the second metadata column is
It is no identical.
3. according to the method described in claim 2, it is characterized in that, the second metadata inquired in the target report includes:
The second metadata successively inquired in the target report of turning left is arranged from last.
4. according to the method described in claim 2, it is characterized in that, since initial row line by line from it is last column turn left according to
Before the secondary data item for filling multiple metadata in target report, the method also includes:
Determine the multirow initial data in source database；
Second metadata is used to sort left to right as keyword to the multirow initial data.
5. the method according to claim 1, wherein statistics and multiple second row data in target report
The small evaluation of corresponding first metadata of key includes:
Empty subtotal row is inserted between the (n+1)th row and line n of the target report；
Other sequential cells lattice of horizontal meaders in addition to cell where first metadata on the subtotal row, statistics
The small evaluation of the first metadata corresponding with multiple second row data key, and it is filled in the subtotal row and described first
The cell of metadata column.
6. according to the method described in claim 5, it is characterized in that, in the (n+1)th row of the target report and interleaving for line n
After entering empty subtotal row, the method also includes:
By multiple cell vertical consolidations where multiple second row data key at a cell.
7. the method according to claim 1, wherein statistics and multiple second row data in target report
The small evaluation of corresponding first metadata of key includes:
Subtotal row is filled in the (n+1)th row of the target report；
On the subtotal row before first row to first the first metadata after the second row data key column laterally
Merge Cells；
The column count for participating in subtotal is added 1, and the cell where the second row data key described in vertical consolidation.
8. a kind of statistic device of report subtotal characterized by comprising
Module is filled, for successively filling multiple first numbers in target report since turning left line by line from column last initial row
According to data item；
First judgment module, for judge the first row data key of the (n+1)th row and line n the second row data key whether phase
Together, wherein n is positive integer；
First statistical module, for different from the second row data key in the first row data key, and identical second
When row data key is greater than 1, the small of the first metadata corresponding with multiple second row data key is counted in target report
Evaluation.
9. a kind of storage medium, which is characterized in that be stored with computer program in the storage medium, wherein the computer
Program is arranged to perform claim when operation and requires method described in 1 to 7 any one.
10. a kind of electronic device, including memory and processor, which is characterized in that be stored with computer journey in the memory
Sequence, the processor are arranged to run the computer program in method described in perform claim 1 to 7 any one of requirement.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910488962.9A CN110427599A (en) | 2019-06-06 | 2019-06-06 | The statistical method and device of report subtotal, storage medium, electronic device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201910488962.9A CN110427599A (en) | 2019-06-06 | 2019-06-06 | The statistical method and device of report subtotal, storage medium, electronic device |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN110427599A true CN110427599A (en) | 2019-11-08 |
Family
ID=68408515
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201910488962.9A Pending CN110427599A (en) | 2019-06-06 | 2019-06-06 | The statistical method and device of report subtotal, storage medium, electronic device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN110427599A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110908972A (en) * | 2019-11-19 | 2020-03-24 | 加和（北京）信息科技有限公司 | Log data preprocessing method and device, electronic equipment and storage medium |
| CN113536750A (en) * | 2021-06-07 | 2021-10-22 | 珠海金山办公软件有限公司 | Table marking method and device, electronic equipment and storage medium |
Citations (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP0769750A1 (en) * | 1995-06-30 | 1997-04-23 | Price Waterhouse World Firm Technology Centre | A method for electronically deriving and parsing the mathematic structure of a financial table |
| CN101183371A (en) * | 2007-12-12 | 2008-05-21 | 中兴通讯股份有限公司 | Method for quick finishing large data-handling and reporting system |
| CN101388028A (en) * | 2008-09-19 | 2009-03-18 | 金蝶软件（中国）有限公司 | Method and apparatus for combining cells |
| JP2012068997A (en) * | 2010-09-24 | 2012-04-05 | Hitachi Systems Ltd | Tabulation breakdown determination system and program |
| US20130290822A1 (en) * | 2011-12-29 | 2013-10-31 | Bibo Labs, Inc. | Spreadsheet-based programming language adapted for report generation |
| CN104036040A (en) * | 2014-06-30 | 2014-09-10 | 贝壳网际（北京）安全技术有限公司 | Method and device for generating report |
| CN104794113A (en) * | 2014-01-16 | 2015-07-22 | 中兴通讯股份有限公司 | Data processing method and device |
| CN105740328A (en) * | 2016-01-21 | 2016-07-06 | 中国建设银行股份有限公司 | Bancassurance report generation method |
| CN106469379A (en) * | 2015-08-14 | 2017-03-01 | 国网冀北电力有限公司 | A kind of electrical network sale of electricity electricity price calculating system and its measuring method |
| CN106919712A (en) * | 2017-03-10 | 2017-07-04 | 深圳市科脉技术股份有限公司 | The data statistical approach and system of form |
| CN107229718A (en) * | 2017-05-31 | 2017-10-03 | 北京京东尚科信息技术有限公司 | The method and apparatus for handling report data |
| JP2017187931A (en) * | 2016-04-06 | 2017-10-12 | コニカミノルタ株式会社 | Table data conversion method, program, and image reading device |
| CN108984506A (en) * | 2018-08-01 | 2018-12-11 | 北京中电普华信息技术有限公司 | A kind of generation method and device of configurable intelligent report forms |
| CN109543169A (en) * | 2018-11-26 | 2019-03-29 | 成都四方伟业软件股份有限公司 | Report processing method and device |
-
2019
- 2019-06-06 CN CN201910488962.9A patent/CN110427599A/en active Pending
Patent Citations (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP0769750A1 (en) * | 1995-06-30 | 1997-04-23 | Price Waterhouse World Firm Technology Centre | A method for electronically deriving and parsing the mathematic structure of a financial table |
| CN101183371A (en) * | 2007-12-12 | 2008-05-21 | 中兴通讯股份有限公司 | Method for quick finishing large data-handling and reporting system |
| CN101388028A (en) * | 2008-09-19 | 2009-03-18 | 金蝶软件（中国）有限公司 | Method and apparatus for combining cells |
| JP2012068997A (en) * | 2010-09-24 | 2012-04-05 | Hitachi Systems Ltd | Tabulation breakdown determination system and program |
| US20130290822A1 (en) * | 2011-12-29 | 2013-10-31 | Bibo Labs, Inc. | Spreadsheet-based programming language adapted for report generation |
| CN104794113A (en) * | 2014-01-16 | 2015-07-22 | 中兴通讯股份有限公司 | Data processing method and device |
| CN104036040A (en) * | 2014-06-30 | 2014-09-10 | 贝壳网际（北京）安全技术有限公司 | Method and device for generating report |
| CN106469379A (en) * | 2015-08-14 | 2017-03-01 | 国网冀北电力有限公司 | A kind of electrical network sale of electricity electricity price calculating system and its measuring method |
| CN105740328A (en) * | 2016-01-21 | 2016-07-06 | 中国建设银行股份有限公司 | Bancassurance report generation method |
| JP2017187931A (en) * | 2016-04-06 | 2017-10-12 | コニカミノルタ株式会社 | Table data conversion method, program, and image reading device |
| CN106919712A (en) * | 2017-03-10 | 2017-07-04 | 深圳市科脉技术股份有限公司 | The data statistical approach and system of form |
| CN107229718A (en) * | 2017-05-31 | 2017-10-03 | 北京京东尚科信息技术有限公司 | The method and apparatus for handling report data |
| CN108984506A (en) * | 2018-08-01 | 2018-12-11 | 北京中电普华信息技术有限公司 | A kind of generation method and device of configurable intelligent report forms |
| CN109543169A (en) * | 2018-11-26 | 2019-03-29 | 成都四方伟业软件股份有限公司 | Report processing method and device |
Non-Patent Citations (1)
| Title |
|---|
| SAT RICCIARDI: "电子表格", 个人电脑, no. 10, pages 173 - 175 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110908972A (en) * | 2019-11-19 | 2020-03-24 | 加和（北京）信息科技有限公司 | Log data preprocessing method and device, electronic equipment and storage medium |
| CN113536750A (en) * | 2021-06-07 | 2021-10-22 | 珠海金山办公软件有限公司 | Table marking method and device, electronic equipment and storage medium |
| CN113536750B (en) * | 2021-06-07 | 2023-12-26 | 珠海金山办公软件有限公司 | Form marking method and device, electronic equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106326248B (en) | The storage method and device of database data | |
| EP1695282B1 (en) | Data processing system and method | |
| CN109299997A (en) | Products Show method, apparatus and computer readable storage medium | |
| CN102682059B (en) | Method and system for distributing users to clusters | |
| CN103473230B (en) | Service area determines that method, logistics service provider recommend method and related device | |
| CN103106585B (en) | The real-time repetition removal method and apparatus of product information | |
| CN106909495B (en) | Data window statistical method, device and system | |
| CN108197873A (en) | Warehouse article goods sorting method, device, computer equipment and storage medium | |
| CN108205768A (en) | Database building method and data recommendation method and device, equipment and storage medium | |
| CN103368992A (en) | Message push method and device | |
| CN103632250A (en) | Quick sales order sorting, grouping and screening method | |
| CN110427599A (en) | The statistical method and device of report subtotal, storage medium, electronic device | |
| CN107193822A (en) | For the method for paging query, device and equipment | |
| CN104636349A (en) | Method and equipment for compression and searching of index data | |
| CN107483381A (en) | The monitoring method and device of interlock account | |
| CN105590245A (en) | Computer implementation method and data processing method for locating fault cause of electronic transaction | |
| CN107481058A (en) | A kind of Products Show method and Products Show device | |
| CN110262951A (en) | A kind of business second grade monitoring method and system, storage medium and client | |
| CN107133367A (en) | A kind of information processing method and system, server | |
| CN105426392A (en) | Collaborative filtering recommendation method and system | |
| CN103309885A (en) | Method and device for identifying feature user in electronic trading platform, search method and device | |
| CN106708869B (en) | Group data processing method and device | |
| CN116932321A (en) | Log data monitoring method and device, electronic equipment and storage medium | |
| CN109872126A (en) | Project implementation condition managing method and system based on power grid | |
| CN102254288A (en) | Data processing method and system for risk mitigation in bank |
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 | ||
| WD01 | Invention patent application deemed withdrawn after publication | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20191108 |