CN104142952A - Method and device for showing reports - Google Patents
Method and device for showing reports Download PDFInfo
- Publication number
- CN104142952A CN104142952A CN201310170416.3A CN201310170416A CN104142952A CN 104142952 A CN104142952 A CN 104142952A CN 201310170416 A CN201310170416 A CN 201310170416A CN 104142952 A CN104142952 A CN 104142952A
- Authority
- CN
- China
- Prior art keywords
- node
- gauge outfit
- region
- cell
- title
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Processing Or Creating Images (AREA)
Abstract
The invention discloses a method and a device for showing reports. The method for showing the reports includes storing association relationships among data in data cells, corresponding header names, mechanism dimension names and corresponding time of the reports in databases, showing header parent nodes in first layers of header areas and mechanism nodes in mechanism dimension areas and then showing header leaf nodes according to user selection; querying associated data in the databases when users select the header leaf nodes, and showing the associated data. The header leaf nodes are associated with the header parent nodes. The associated data correspond to the header leaf nodes and the current mechanism nodes. The method and the device have the advantages that the generated reports can be secondarily processed, contents of the reports can be conveniently extracted and can be shown on user terminals, and accordingly practical requirements on report transplantation can be met.
Description
Technical field
The present invention relates to computer realm, particularly a kind of form methods of exhibiting and device.
Background technology
Along with the widespread use of smart mobile phone, a large amount of computer programs is transplanted on mobile phone terminal, to be convenient for people to obtain more easily Useful Information at present.
Current among enterprise, form is widely used among the routine work of all departments, particularly among the monitoring of marketing activity and analysis.In order to adapt to the various business of content of large enterprise, this form that is usually used in monitoring and analyzes is generally all comparatively complicated, and gauge outfit design is comparatively flexible, and many times the complex table head with a kind of multilayer occurs.In order to adapt to the development situation in epoch, convenient leader and related personnel get the critical data of enterprise in time, these need to be transplanted to mobile phone terminal for analyzing the form of management and control.
Yet, be limited to memory size and the CPU(Central Processing Unit of current smart mobile phone, CPU (central processing unit)) speed, in present stage, report generation mode general on current computer cannot be grafted directly on mobile phone terminal the complex report forms of multilayer gauge outfit (particularly for).For individual report data amount, surpass easily the complex report forms of 500 data simultaneously, these data are simultaneously displayed on mobile phone, be also not easy to user and obtain accurately and conveniently the data of oneself wanting.
Meanwhile, reporting system focuses mostly on and on computer platform, produces and show, and unopposed machine platform supports.In fact, on current mobile phone terminal, also the form displaying control of moulding and form are not shown software.
Summary of the invention
The technical problem to be solved in the present invention is to provide a kind of form methods of exhibiting and device.By the form having generated is carried out to secondary treating, form content can be extracted easily and is illustrated on user terminal, thereby meet the practical needs of transplanting form.
According to an aspect of the present invention, provide a kind of form methods of exhibiting, comprising:
Determine the corresponding time of gauge outfit region, mechanism's dimension region, data area and form of form;
For each data cells in data area, read gauge outfit title corresponding to described data cells and mechanism's dimension name;
Data in described data cells are stored in database with described gauge outfit title, mechanism's dimension name and the incidence relation of corresponding time of form;
Gauge outfit father node in the ground floor of displaying gauge outfit region and the mechanism's node in mechanism's dimension region;
According to user, select, show the gauge outfit leaf node being associated with gauge outfit father node;
When user's option table head lobe node, the inquiry associated data corresponding with gauge outfit leaf node and current mechanism node in database, wherein gauge outfit leaf node is corresponding to the gauge outfit title of described associated data cell of living in, and current mechanism node is corresponding to mechanism's dimension name of described associated data cell of living in;
Show described associated data.
Preferably, above-mentioned according to user's selection, show that the step of the gauge outfit leaf node being associated with gauge outfit father node comprises:
When user selects gauge outfit father node, using gauge outfit father node as present node;
According to the degree of depth of tree, judge whether present node has child node;
If present node does not have child node, using present node as gauge outfit leaf node, show gauge outfit leaf node;
If present node has child node, show the child node of present node;
When user selects a child node, using the child node of selecting as present node, repeat according to the degree of depth of tree and judge whether present node has the step of child node.
Preferably, the above-mentioned degree of depth according to tree judges that the step whether present node has a child node comprises:
Judge whether the number of plies at present node place is less than the degree of depth of tree;
If the number of plies at present node place is less than the degree of depth of tree, judge that present node has child node;
If the number of plies at present node place equals the degree of depth of tree, judge that present node does not have child node.
Preferably, the degree of depth of tree is the number of plies in gauge outfit region.
Preferably, after the step of corresponding time of the gauge outfit region of above-mentioned definite form, mechanism's dimension region, data area and form, also comprise that his-and-hers watches head region carries out structural configuration, then carry out for each data cells in data area, read the step of gauge outfit title corresponding to described data cells and mechanism's dimension name, the step that wherein his-and-hers watches head region is carried out structural configuration comprises:
In gauge outfit region, split the gauge outfit cell all merging, after splitting, the content of gauge outfit cell is constant;
For each the gauge outfit cell A in gauge outfit region, in gauge outfit cell A row of living in, according to order from the top down, the whole cell content by the gauge outfit cell in the ground floor of gauge outfit region to gauge outfit cell A merge, as the title with the corresponding node of gauge outfit cell A;
In every one deck in gauge outfit region, using the identical node of title as same node.
According to a further aspect in the invention, provide a kind of form exhibiting device, comprise region determining unit, title reading unit, storage control unit, the first display unit, the second display unit, query unit and the 3rd display unit, wherein:
Region determining unit, for determining the corresponding time of gauge outfit region, mechanism's dimension region, data area and form of form;
Title reading unit, for each data cells for data area, reads gauge outfit title corresponding to described data cells and mechanism's dimension name;
Storage control unit, for storing the data of described data cells in database into described gauge outfit title, mechanism's dimension name and the incidence relation of corresponding time of form;
The first display unit, for showing the gauge outfit father node of gauge outfit region ground floor and the mechanism's node in mechanism's dimension region;
The second display unit, for selecting according to user, shows the gauge outfit leaf node being associated with gauge outfit father node;
Query unit, for when user's option table head lobe node, the inquiry associated data corresponding with gauge outfit leaf node and current mechanism node in database, wherein gauge outfit leaf node is corresponding to the gauge outfit title of described associated data cell of living in, and current mechanism node is corresponding to mechanism's dimension name of described associated data cell of living in;
The 3rd display unit, for showing described associated data.
Preferably, the second display unit specifically comprises:
The first identification module, when selecting gauge outfit father node as user, using gauge outfit father node as present node;
Judge module, for judging according to the degree of depth of tree whether present node has child node; If present node does not have child node, indication the second identification module is using present node as gauge outfit leaf node; If present node has child node, the child node that indication the second display module is shown present node;
The second identification module, for according to the indication of judge module, using present node as gauge outfit leaf node, indication the first display module is shown gauge outfit leaf node;
The first display module, for according to the indication of the second identification module, shows gauge outfit leaf node;
The second display module, for according to the indication of judge module, shows the child node of present node;
The 3rd identification module, when selecting a child node as user, using the child node of selecting as present node, indication judge module is carried out according to the degree of depth of tree and is judged whether present node has the operation of child node.
Preferably, judge module specifically judges whether the number of plies at present node place is less than the degree of depth of tree, if the number of plies at present node place is less than the degree of depth of tree, judges that present node has child node; If the number of plies at present node place equals the degree of depth of tree, judge that present node does not have child node.
Preferably, the degree of depth of tree is the number of plies in gauge outfit region.
Preferably, described device also comprises gauge outfit dispensing unit, the gauge outfit region, mechanism's dimension region, data area and the form that are used for determining form at territory element are after the corresponding time, his-and-hers watches head region is carried out structural configuration, then indicate title reading unit to carry out for each data cells in data area, the operation of reading gauge outfit title corresponding to described data cells and mechanism's dimension name, wherein gauge outfit dispensing unit comprises:
Cell splits module, and gauge outfit region, mechanism's dimension region, data area and the form of for territory element, determining form, after the corresponding time, in gauge outfit region, split the gauge outfit cell all merging, and after splitting, the content of gauge outfit cell is constant;
Title determination module, for each the gauge outfit cell A for gauge outfit region, in gauge outfit cell A row of living in, according to order from the top down, whole cell content by the gauge outfit cell in the ground floor of gauge outfit region to gauge outfit cell A merge, as the title with the corresponding node of gauge outfit cell A;
Node merges module, for the every one deck in gauge outfit region, using the identical node of title as same node, then indicate title reading unit to carry out for each data cells in data area, read the operation of gauge outfit title corresponding to described data cells and mechanism's dimension name.
The present invention by the data in data cells are claimed with respective table first place, mechanism's dimension name and the incidence relation of corresponding time of form store in database, after gauge outfit father node and the mechanism's node in mechanism's dimension region in showing gauge outfit region ground floor, according to user, select to show the gauge outfit leaf node being associated with gauge outfit father node.When user's option table head lobe node, in database, the inquiry associated data corresponding with gauge outfit leaf node and current mechanism node, shows described associated data.By the form having generated is carried out to secondary treating, form content can be extracted easily and is illustrated on user terminal, thereby meet the practical needs of transplanting form.
Description of the invention provides for example with for the purpose of describing, and is not exhaustively or limit the invention to disclosed form.Many modifications and variations are obvious for the ordinary skill in the art.Selecting and describing embodiment is for better explanation principle of the present invention and practical application, thereby and makes those of ordinary skill in the art can understand the various embodiment with various modifications that the present invention's design is suitable for special-purpose.
Accompanying drawing explanation
In order to be illustrated more clearly in the embodiment of the present invention or technical scheme of the prior art, to the accompanying drawing of required use in embodiment or description of the Prior Art be briefly described below, apparently, accompanying drawing in the following describes is only some embodiments of the present invention, for those of ordinary skills, do not paying under the prerequisite of creative work, can also obtain according to these accompanying drawings other accompanying drawing.
Fig. 1 is the schematic diagram of an embodiment of form methods of exhibiting of the present invention.
Fig. 2 is the schematic diagram that the present invention shows an embodiment of leaf node.
Fig. 3 is the schematic diagram of an embodiment of gauge outfit area configurations of the present invention.
Fig. 4 is the tree construction schematic diagram that the present invention obtains by gauge outfit area configurations.
Fig. 5 is the schematic diagram of an embodiment of form exhibiting device of the present invention.
Fig. 6 is the schematic diagram of an embodiment of the present invention's the second display unit.
Fig. 7 is the schematic diagram of another embodiment of form exhibiting device of the present invention.
Fig. 8 is the schematic diagram of an embodiment of gauge outfit dispensing unit of the present invention.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention, the technical scheme in the embodiment of the present invention is clearly and completely described, obviously, described embodiment is only the present invention's part embodiment, rather than whole embodiment.To the description only actually of at least one exemplary embodiment, be illustrative below, never as any restriction to the present invention and application or use.Embodiment based in the present invention, those of ordinary skills, not making the every other embodiment obtaining under creative work prerequisite, belong to the scope of protection of the invention.
Unless illustrate in addition, otherwise the parts of setting forth in these embodiments and positioned opposite, numeral expression formula and the numerical value of step not limited the scope of the invention.
, it should be understood that for convenience of description, the size of the various piece shown in accompanying drawing is not to draw according to actual proportionate relationship meanwhile.
For the known technology of person of ordinary skill in the relevant, method and apparatus, may not discuss in detail, but in suitable situation, described technology, method and apparatus should be regarded as authorizing a part for instructions.
In all examples with discussing shown here, it is exemplary that any occurrence should be construed as merely, rather than as restriction.Therefore, other example of exemplary embodiment can have different values.
It should be noted that: in similar label and letter accompanying drawing below, represent similar terms, therefore, once be defined in an a certain Xiang Yi accompanying drawing, in accompanying drawing subsequently, do not need it to be further discussed.
Fig. 1 is the schematic diagram of an embodiment of form methods of exhibiting of the present invention.Preferably, the method step of the present embodiment can be carried out by form exhibiting device.
Step 101, determines gauge outfit region, mechanism's dimension region, data area and the corresponding time of form of form.
Step 102, for each data cells in data area, reads gauge outfit title corresponding to described data cells and mechanism's dimension name.
Step 103, stores the data in described data cells in database into described gauge outfit title, mechanism's dimension name and the incidence relation of corresponding time of form.
Step 104, the gauge outfit father node in the ground floor of displaying gauge outfit region and the mechanism's node in mechanism's dimension region.
Step 105, selects according to user, shows the gauge outfit leaf node being associated with gauge outfit father node.
Step 106, when user's option table head lobe node, the inquiry associated data corresponding with gauge outfit leaf node and current mechanism node in database, wherein gauge outfit leaf node is corresponding to the gauge outfit title of described associated data cell of living in, and current mechanism node is corresponding to mechanism's dimension name of described associated data cell of living in.
Step 107, shows described associated data.
The form methods of exhibiting providing based on the above embodiment of the present invention, by the data in data cells are claimed with respective table first place, mechanism's dimension name and the incidence relation of corresponding time of form store in database, after gauge outfit father node and the mechanism's node in mechanism's dimension region in showing gauge outfit region ground floor, according to user, select to show the gauge outfit leaf node being associated with gauge outfit father node.When user's option table head lobe node, in database, the inquiry associated data corresponding with gauge outfit leaf node and current mechanism node, shows described associated data.By the form having generated is carried out to secondary treating, form content can be extracted easily and is illustrated on user terminal, thereby meet the practical needs of transplanting form.
Fig. 2 is the schematic diagram that the present invention shows an embodiment of leaf node.As shown in Figure 2, above-mentioned according to user's selection, show that the step of the gauge outfit leaf node being associated with gauge outfit father node comprises:
Step 201, when user selects gauge outfit father node, using gauge outfit father node as present node.
Step 202, judges according to the degree of depth of tree whether present node has child node.If present node does not have child node, execution step 203; If present node has child node, execution step 204.
Wherein, the degree of depth of tree is the number of plies in gauge outfit region.
Step 203, using present node as gauge outfit leaf node, shows gauge outfit leaf node.Afterwards, no longer carry out other step of the present embodiment.
Step 204, the child node of showing present node.
Step 205, when user selects a child node, using the child node of selecting as present node, repeated execution of steps 202.
By aforesaid operations, can show the gauge outfit leaf node being associated with gauge outfit father node.
Preferably, the above-mentioned degree of depth according to tree judges that the step whether present node has a child node comprises:
Judge whether the number of plies at present node place is less than the degree of depth of tree.
If the number of plies at present node place is less than the degree of depth of tree, judge that present node has child node.
If the number of plies at present node place equals the degree of depth of tree, judge that present node does not have child node.
Preferably, after the step of corresponding time of the gauge outfit region of above-mentioned definite form, mechanism's dimension region, data area and form, also comprise that his-and-hers watches head region carries out structural configuration, then carry out for each data cells in data area, read the step of gauge outfit title corresponding to described data cells and mechanism's dimension name.By his-and-hers watches head region, carry out structural configuration, can combing go out the tree construction in gauge outfit region.
Fig. 3 is the schematic diagram of an embodiment of gauge outfit area configurations of the present invention.Wherein:
Step 301, in gauge outfit region, splits the gauge outfit cell all merging, and after splitting, the content of gauge outfit cell is constant.
Step 302, for each the gauge outfit cell A in gauge outfit region, in gauge outfit cell A row of living in, according to order from the top down, whole cell content by the gauge outfit cell in the ground floor of gauge outfit region to gauge outfit cell A merge, as the title with the corresponding node of gauge outfit cell A.
Step 303, in every one deck in gauge outfit region, using the identical node of title as same node.
Below by a concrete example, the present invention will be described.The form of table 1 for needing to show.
Table 1
In above-mentioned form, A classifies mechanism's dimension region as, and B1-E3 region is gauge outfit region, and B4-E4 region is data area.
After determining each region of form, his-and-hers watches head region is carried out structural configuration.Be specially:
1) the gauge outfit cell all merging is split, after splitting, the content of gauge outfit cell is constant.Now form is as shown in table 2.
Table 2
2) in each row, by order from the top down, carry out the merging of gauge outfit cell content, as the title with the corresponding node of correlation table head unit lattice.According to above-mentioned merging mode, the title of each unit is as shown in table 3, and wherein symbol " $ " is separator.
| Cell | Title |
| B1 | Userbase |
| B2 | Userbase $ arrives number |
| B3 | Userbase $ arrives number $ and arrives number |
| C1 | Userbase |
| C2 | Userbase $ 3G subscription permeability |
| C3 | Userbase $ 3G subscription permeability $ adds up to |
| D1 | Userbase |
| D2 | Userbase $ 3G subscription permeability |
| D3 | The userbase 3G subscription permeability moon pays |
| E1 | Userbase |
| E2 | Userbase $ 3G subscription permeability |
| E3 | Userbase $ 3G subscription permeability $ pre-payment |
Table 3
3) as can see from Figure 3,, on the same layer in gauge outfit region, there is the node that title is identical.For the ease of operation, the identical node of title on same layer is considered as to same node.Thus, the tree construction obtaining by said structureization configuration as shown in Figure 4.
As seen from Figure 4, in tree construction, the maximum level of each bifurcated is identical.Processing can contribute to reduce system complexity like this, does not affect the operational efficiency of total system.
From table 3, can also see, each child node is known its father node, and does not know whether it has child node simultaneously.For example, last separator in child node title and content are afterwards deleted, just can be obtained the title of its father node.Due to for a form, the degree of depth of institute's spanning tree is a constant.Therefore the degree of depth by tree can judge whether this node has child node.For example cell B2 is in the second layer, and the degree of depth of tree is 3, can also have child node by determining unit lattice B2.
In his-and-hers watches head region, carry out after structural configuration, can, for each data cells, read the corresponding gauge outfit title of this data cells and mechanism's dimension name.For example, for cell B4, its gauge outfit name is called " userbase arrives number and arrives number ", and its mechanism's dimension name is " Guangzhou ".Form according to [gauge outfit title, mechanism's dimension name, cell data, form time] stores in database.
Preferably, for the ease of transmission and the processing of data, the Chinese information of reading need to be converted to the coding of numeral or character string in form according to the needs of system transmission.This Chinese is also to go to realize by forming the mode of allocation list to the conversion of coding.
For example, gauge outfit title and mechanism's dimension name can be converted to corresponding gauge outfit indication coding and mechanism's dimension coding, storage format can be [gauge outfit indication coding, mechanism's dimension coding, cell data, form time].
When needs are shown report data, first show gauge outfit father node in the ground floor of gauge outfit region and the mechanism's node in mechanism's dimension region.As shown in table 4.
| ? | Userbase |
| Guangzhou | ? |
Table 4
When user clicks " userbase ", show child node " arrival number " and " the 3G subscription permeability " of " userbase ", as shown in table 5.
| ? | Arrive number | 3G subscription permeability |
| Guangzhou | ? | ? |
Table 5
When further click " arrival number " or " 3G subscription permeability ", can further show its corresponding child node.For example, when clicking " 3G subscription permeability ", show the child node of " 3G subscription permeability ", as shown in table 6.
| ? | Add up to | The moon pays | Pre-payment |
| Guangzhou | ? | ? | ? |
Table 6
When the node of clicking is leaf node, when namely this node does not have child node, the inquiry associated data corresponding with this leaf node and current mechanism node in database, and on terminal display device, show this associated data.
Fig. 5 is the schematic diagram of an embodiment of form exhibiting device of the present invention.As shown in Figure 5, form exhibiting device comprises region determining unit 501, title reading unit 502, storage control unit 503, the first display unit 504, the second display unit 505, query unit 506 and the 3rd display unit 507.Wherein:
Region determining unit 501, for determining the corresponding time of gauge outfit region, mechanism's dimension region, data area and form of form.
Title reading unit 502, for each data cells for data area, reads gauge outfit title corresponding to described data cells and mechanism's dimension name.
Storage control unit 503, for storing the data of described data cells in database into described gauge outfit title, mechanism's dimension name and the incidence relation of corresponding time of form.
The first display unit 504, for showing the gauge outfit father node of gauge outfit region ground floor and the mechanism's node in mechanism's dimension region.
The second display unit 505, for selecting according to user, shows the gauge outfit leaf node being associated with gauge outfit father node.
Query unit 506, for when user's option table head lobe node, the inquiry associated data corresponding with gauge outfit leaf node and current mechanism node in database, wherein gauge outfit leaf node is corresponding to the gauge outfit title of described associated data cell of living in, and current mechanism node is corresponding to mechanism's dimension name of described associated data cell of living in.
The 3rd display unit 507, for showing described associated data.
The form exhibiting device providing based on the above embodiment of the present invention, by the data in data cells are claimed with respective table first place, mechanism's dimension name and the incidence relation of corresponding time of form store in database, after gauge outfit father node and the mechanism's node in mechanism's dimension region in showing gauge outfit region ground floor, according to user, select to show the gauge outfit leaf node being associated with gauge outfit father node.When user's option table head lobe node, in database, the inquiry associated data corresponding with gauge outfit leaf node and current mechanism node, shows described associated data.By the form having generated is carried out to secondary treating, form content can be extracted easily and is illustrated on user terminal, thereby meet the practical needs of transplanting form.
Fig. 6 is the schematic diagram of an embodiment of the present invention's the second display unit.As shown in Figure 6, the second display unit specifically comprises:
The first identification module 601, when selecting gauge outfit father node as user, using gauge outfit father node as present node.
Judge module 602, for judging according to the degree of depth of tree whether present node has child node; If present node does not have child node, indication the second identification module 603 is using present node as gauge outfit leaf node; If present node has child node, the child node that indication the second display module 605 is shown present node.
The second identification module 603, for according to the indication of judge module 602, using present node as gauge outfit leaf node, indication the first display module 604 is shown gauge outfit leaf node.
The first display module 604, for according to the indication of the second identification module 603, shows gauge outfit leaf node.
The second display module 605, for according to the indication of judge module 602, shows the child node of present node.
The 3rd identification module 606, when selecting a child node as user, using the child node of selecting as present node, indication judge module 602 is carried out according to the degree of depth of tree and is judged whether present node has the operation of child node.
Preferably, judge module specifically judges whether the number of plies at present node place is less than the degree of depth of tree, if the number of plies at present node place is less than the degree of depth of tree, judges that present node has child node; If the number of plies at present node place equals the degree of depth of tree, judge that present node does not have child node.
Fig. 7 is the schematic diagram of another embodiment of form exhibiting device of the present invention.Compare with embodiment illustrated in fig. 5, in the embodiment shown in fig. 7, also comprise gauge outfit dispensing unit 701, the gauge outfit region, mechanism's dimension region, data area and the form that are used for determining form at territory element are after the corresponding time, his-and-hers watches head region is carried out structural configuration, then indicate title reading unit to carry out for each data cells in data area, read the operation of gauge outfit title corresponding to described data cells and mechanism's dimension name.
Fig. 8 is the schematic diagram of an embodiment of gauge outfit dispensing unit of the present invention.As shown in Figure 8, gauge outfit dispensing unit comprises:
Cell splits module 801, and gauge outfit region, mechanism's dimension region, data area and the form of for territory element, determining form, after the corresponding time, in gauge outfit region, split the gauge outfit cell all merging, and after splitting, the content of gauge outfit cell is constant.
Title determination module 802, for each the gauge outfit cell A for gauge outfit region, in gauge outfit cell A row of living in, according to order from the top down, whole cell content by the gauge outfit cell in the ground floor of gauge outfit region to gauge outfit cell A merge, as the title with the corresponding node of gauge outfit cell A.
Node merges module 803, for the every one deck in gauge outfit region, using the identical node of title as same node, then indicate title reading unit to carry out for each data cells in data area, read the operation of gauge outfit title corresponding to described data cells and mechanism's dimension name.
Preferably, form exhibiting device can be the mobile terminal such as mobile phone.
By implementing the present invention, data storage, conversion and the mobile phone terminal that can effectively solve form are shown a difficult problem, and because it can obtain same index historical data easily, can show easily chart.Because the extraction of each Index Content of form after structuring is comparatively easy, can fast different forms be reintegrated and show as required simultaneously.Thereby from practicality, reliability, angle cheaply, cater to and meet the practical needs of transplanting form.
One of ordinary skill in the art will appreciate that all or part of step that realizes above-described embodiment can complete by hardware, also can come the hardware that instruction is relevant to complete by program, described program can be stored in a kind of computer-readable recording medium, the above-mentioned storage medium of mentioning can be ROM (read-only memory), disk or CD etc.
Claims (10)
1. a form methods of exhibiting, is characterized in that, comprising:
Determine the corresponding time of gauge outfit region, mechanism's dimension region, data area and form of form;
For each data cells in data area, read gauge outfit title corresponding to described data cells and mechanism's dimension name;
Data in described data cells are stored in database with described gauge outfit title, mechanism's dimension name and the incidence relation of corresponding time of form;
Gauge outfit father node in the ground floor of displaying gauge outfit region and the mechanism's node in mechanism's dimension region;
According to user, select, show the gauge outfit leaf node being associated with gauge outfit father node;
When user's option table head lobe node, the inquiry associated data corresponding with gauge outfit leaf node and current mechanism node in database, wherein gauge outfit leaf node is corresponding to the gauge outfit title of described associated data cell of living in, and current mechanism node is corresponding to mechanism's dimension name of described associated data cell of living in;
Show described associated data.
2. method according to claim 1, is characterized in that,
According to user, select, show that the step of the gauge outfit leaf node being associated with gauge outfit father node comprises:
When user selects gauge outfit father node, using gauge outfit father node as present node;
According to the degree of depth of tree, judge whether present node has child node;
If present node does not have child node, using present node as gauge outfit leaf node, show gauge outfit leaf node;
If present node has child node, show the child node of present node;
When user selects a child node, using the child node of selecting as present node, repeat according to the degree of depth of tree and judge whether present node has the step of child node.
3. method according to claim 2, is characterized in that,
According to the degree of depth of tree, judge that the step whether present node has a child node comprises:
Judge whether the number of plies at present node place is less than the degree of depth of tree;
If the number of plies at present node place is less than the degree of depth of tree, judge that present node has child node;
If the number of plies at present node place equals the degree of depth of tree, judge that present node does not have child node.
4. method according to claim 3, is characterized in that,
The degree of depth of tree is the number of plies in gauge outfit region.
5. according to the method described in any one in claim 1-4, it is characterized in that,
After determining gauge outfit region, mechanism's dimension region, data area and the step of form correspondence time of form, also comprise that his-and-hers watches head region carries out structural configuration, then carry out for each data cells in data area, read the step of gauge outfit title corresponding to described data cells and mechanism's dimension name, the step that wherein his-and-hers watches head region is carried out structural configuration comprises:
In gauge outfit region, split the gauge outfit cell all merging, after splitting, the content of gauge outfit cell is constant;
For each the gauge outfit cell A in gauge outfit region, in gauge outfit cell A row of living in, according to order from the top down, the whole cell content by the gauge outfit cell in the ground floor of gauge outfit region to gauge outfit cell A merge, as the title with the corresponding node of gauge outfit cell A;
In every one deck in gauge outfit region, using the identical node of title as same node.
6. a form exhibiting device, is characterized in that, comprises region determining unit, title reading unit, storage control unit, the first display unit, the second display unit, query unit and the 3rd display unit, wherein:
Region determining unit, for determining the corresponding time of gauge outfit region, mechanism's dimension region, data area and form of form;
Title reading unit, for each data cells for data area, reads gauge outfit title corresponding to described data cells and mechanism's dimension name;
Storage control unit, for storing the data of described data cells in database into described gauge outfit title, mechanism's dimension name and the incidence relation of corresponding time of form;
The first display unit, for showing the gauge outfit father node of gauge outfit region ground floor and the mechanism's node in mechanism's dimension region;
The second display unit, for selecting according to user, shows the gauge outfit leaf node being associated with gauge outfit father node;
Query unit, for when user's option table head lobe node, the inquiry associated data corresponding with gauge outfit leaf node and current mechanism node in database, wherein gauge outfit leaf node is corresponding to the gauge outfit title of described associated data cell of living in, and current mechanism node is corresponding to mechanism's dimension name of described associated data cell of living in;
The 3rd display unit, for showing described associated data.
7. device according to claim 6, is characterized in that,
The second display unit specifically comprises:
The first identification module, when selecting gauge outfit father node as user, using gauge outfit father node as present node;
Judge module, for judging according to the degree of depth of tree whether present node has child node; If present node does not have child node, indication the second identification module is using present node as gauge outfit leaf node; If present node has child node, the child node that indication the second display module is shown present node;
The second identification module, for according to the indication of judge module, using present node as gauge outfit leaf node, indication the first display module is shown gauge outfit leaf node;
The first display module, for according to the indication of the second identification module, shows gauge outfit leaf node;
The second display module, for according to the indication of judge module, shows the child node of present node;
The 3rd identification module, when selecting a child node as user, using the child node of selecting as present node, indication judge module is carried out according to the degree of depth of tree and is judged whether present node has the operation of child node.
8. device according to claim 7, is characterized in that,
Judge module specifically judges whether the number of plies at present node place is less than the degree of depth of tree, if the number of plies at present node place is less than the degree of depth of tree, judges that present node has child node; If the number of plies at present node place equals the degree of depth of tree, judge that present node does not have child node.
9. device according to claim 8, is characterized in that,
The degree of depth of tree is the number of plies in gauge outfit region.
10. according to the device described in any one in claim 6-9, it is characterized in that, described device also comprises gauge outfit dispensing unit, the gauge outfit region, mechanism's dimension region, data area and the form that are used for determining form at territory element are after the corresponding time, his-and-hers watches head region is carried out structural configuration, then indicate title reading unit to carry out for each data cells in data area, the operation of reading gauge outfit title corresponding to described data cells and mechanism's dimension name, wherein gauge outfit dispensing unit comprises:
Cell splits module, and gauge outfit region, mechanism's dimension region, data area and the form of for territory element, determining form, after the corresponding time, in gauge outfit region, split the gauge outfit cell all merging, and after splitting, the content of gauge outfit cell is constant;
Title determination module, for each the gauge outfit cell A for gauge outfit region, in gauge outfit cell A row of living in, according to order from the top down, whole cell content by the gauge outfit cell in the ground floor of gauge outfit region to gauge outfit cell A merge, as the title with the corresponding node of gauge outfit cell A;
Node merges module, for the every one deck in gauge outfit region, using the identical node of title as same node, then indicate title reading unit to carry out for each data cells in data area, read the operation of gauge outfit title corresponding to described data cells and mechanism's dimension name.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310170416.3A CN104142952B (en) | 2013-05-10 | 2013-05-10 | Method and device for showing reports |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310170416.3A CN104142952B (en) | 2013-05-10 | 2013-05-10 | Method and device for showing reports |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104142952A true CN104142952A (en) | 2014-11-12 |
| CN104142952B CN104142952B (en) | 2017-05-24 |
Family
ID=51852126
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310170416.3A Active CN104142952B (en) | 2013-05-10 | 2013-05-10 | Method and device for showing reports |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104142952B (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108804401A (en) * | 2018-06-14 | 2018-11-13 | 南京云帐房网络科技有限公司 | A kind of merging method and device of report form template |
| CN109308284A (en) * | 2018-09-28 | 2019-02-05 | 中国平安财产保险股份有限公司 | Report menu generating method, device, computer equipment and storage medium |
| CN109635011A (en) * | 2018-10-31 | 2019-04-16 | 北京辰森世纪科技股份有限公司 | Multistage gauge outfit report processing method, device and equipment based on data service metadata |
| CN110019224A (en) * | 2017-12-21 | 2019-07-16 | 天津数观科技有限公司 | A kind of crosstab head generation method based on tree search |
| CN115186640A (en) * | 2022-07-08 | 2022-10-14 | 中科星图智慧科技安徽有限公司 | Multilayer header statistical table generation algorithm and device |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030233343A1 (en) * | 2002-06-18 | 2003-12-18 | International Business Machines Corporation | System and method for generating custom business reports for a WEB application |
| CN101051372A (en) * | 2006-04-06 | 2007-10-10 | 北京易富金川科技有限公司 | Method for safety verifying financial business information in electronic business |
| CN101615205A (en) * | 2009-07-20 | 2009-12-30 | 中兴通讯股份有限公司 | Report server, instant report implementation method and system |
| CN101667171A (en) * | 2009-09-15 | 2010-03-10 | 金蝶软件（中国）有限公司 | Method for generating report and report generating device |
| CN101894099A (en) * | 2010-06-29 | 2010-11-24 | 北京科技大学 | Report template customization method |
| CN102541998A (en) * | 2010-11-08 | 2012-07-04 | 微软公司 | Business intelligence and report storyboarding |
| CN102819542A (en) * | 2011-11-30 | 2012-12-12 | 金蝶软件（中国）有限公司 | Method and device for presenting instance documents |
-
2013
- 2013-05-10 CN CN201310170416.3A patent/CN104142952B/en active Active
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20030233343A1 (en) * | 2002-06-18 | 2003-12-18 | International Business Machines Corporation | System and method for generating custom business reports for a WEB application |
| CN101051372A (en) * | 2006-04-06 | 2007-10-10 | 北京易富金川科技有限公司 | Method for safety verifying financial business information in electronic business |
| CN101615205A (en) * | 2009-07-20 | 2009-12-30 | 中兴通讯股份有限公司 | Report server, instant report implementation method and system |
| CN101667171A (en) * | 2009-09-15 | 2010-03-10 | 金蝶软件（中国）有限公司 | Method for generating report and report generating device |
| CN101894099A (en) * | 2010-06-29 | 2010-11-24 | 北京科技大学 | Report template customization method |
| CN102541998A (en) * | 2010-11-08 | 2012-07-04 | 微软公司 | Business intelligence and report storyboarding |
| CN102819542A (en) * | 2011-11-30 | 2012-12-12 | 金蝶软件（中国）有限公司 | Method and device for presenting instance documents |
Non-Patent Citations (2)
| Title |
|---|
| ***等: "A5报表处理与数据管理运行方案", 《油气田地面工程》 * |
| 贺艳琴第: "报表管理在IT运维***中的应用", 《价值工程》 * |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110019224A (en) * | 2017-12-21 | 2019-07-16 | 天津数观科技有限公司 | A kind of crosstab head generation method based on tree search |
| CN108804401A (en) * | 2018-06-14 | 2018-11-13 | 南京云帐房网络科技有限公司 | A kind of merging method and device of report form template |
| CN108804401B (en) * | 2018-06-14 | 2022-06-21 | 南京云帐房网络科技有限公司 | Report template merging method and device |
| CN109308284A (en) * | 2018-09-28 | 2019-02-05 | 中国平安财产保险股份有限公司 | Report menu generating method, device, computer equipment and storage medium |
| CN109308284B (en) * | 2018-09-28 | 2023-09-19 | 中国平安财产保险股份有限公司 | Report menu generation method and device, computer equipment and storage medium |
| CN109635011A (en) * | 2018-10-31 | 2019-04-16 | 北京辰森世纪科技股份有限公司 | Multistage gauge outfit report processing method, device and equipment based on data service metadata |
| CN109635011B (en) * | 2018-10-31 | 2022-05-03 | 北京辰森世纪科技股份有限公司 | Multi-level header report processing method, device and equipment based on service metadata |
| CN115186640A (en) * | 2022-07-08 | 2022-10-14 | 中科星图智慧科技安徽有限公司 | Multilayer header statistical table generation algorithm and device |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104142952B (en) | 2017-05-24 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN102662930B (en) | Corpus tagging method and corpus tagging device | |
| Liu et al. | Data envelopment analysis 1978–2010: A citation-based literature survey | |
| CN110292775B (en) | Method and device for acquiring difference data | |
| CN102880687B (en) | Based on individual interactive data retrieval method and the system thereof of label technique | |
| CN110019616B (en) | POI (Point of interest) situation acquisition method and equipment, storage medium and server thereof | |
| CN107657048A (en) | user identification method and device | |
| CN107111625A (en) | Realize the method and system of the efficient classification and exploration of data | |
| CN104142952A (en) | Method and device for showing reports | |
| CN106096644B (en) | Method for measuring similarity and device based on probability workflow | |
| CN113342976A (en) | Method, device, storage medium and equipment for automatically acquiring and processing data | |
| CN202339542U (en) | Software product test system | |
| CN108491326A (en) | Behavioral test recombination method, device and storage medium | |
| CN111369294B (en) | Software cost estimation method and device | |
| CN109033322A (en) | A kind of test method and device of multidimensional data | |
| CN104616134A (en) | Statement analysis report pushing method and device | |
| US20140280352A1 (en) | Processing semi-structured data | |
| KR20150059208A (en) | Device for analyzing the time-space correlation of the event in the social web media and method thereof | |
| CN103488525A (en) | Determination of user preference relevant to scene | |
| CN107578183B (en) | Resource management method and device based on capability evaluation | |
| CN113918806A (en) | Method for automatically recommending training courses and related equipment | |
| CN105183806A (en) | Method and system for identifying same user among different platforms | |
| CN107451216A (en) | The granularity attribute recognition methods of label and device | |
| Almomani et al. | Software process improvement initiatives in small and medium firms: a systematic review | |
| CN102567425B (en) | Method and device for processing data | |
| CN111882113A (en) | Enterprise mobile banking user prediction method and device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |