CN104142952B - Method and device for showing reports - Google Patents
Method and device for showing reports Download PDFInfo
- Publication number
- CN104142952B CN104142952B CN201310170416.3A CN201310170416A CN104142952B CN 104142952 B CN104142952 B CN 104142952B CN 201310170416 A CN201310170416 A CN 201310170416A CN 104142952 B CN104142952 B CN 104142952B
- Authority
- CN
- China
- Prior art keywords
- gauge outfit
- node
- 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.)
- Active
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, more particularly to a kind of form methods of exhibiting and device.
Background technology
Now with the extensive use of smart mobile phone, substantial amounts of computer program is transplanted on mobile phone terminal, with convenient
People more easily obtain useful information.
Current form is widely used among the routine work of all departments among enterprise, particularly marketing activity
Among monitoring and analysis.For the business that the content for adapting to large enterprise is various, this form one for being usually used in monitoring and analyzing
As it is all complex, gauge outfit design more flexibly, many times occurs with a kind of complex table head of multilayer.In order to adapt to the epoch
Development situation, convenient leader and related personnel get the critical data of enterprise, it is necessary to these are used to analyze management and control in time
Form is transplanted on mobile phone terminal.
However, being limited to the memory size and CPU of current smart mobile phone(Central Processing Unit, centre
Reason unit)Speed, at this stage, it is impossible to which report generation mode general on current computer is grafted directly on mobile phone terminal
(Especially for the complex report forms of multilayer gauge outfit).Simultaneously for individual report data amount easily more than 500 complexity of data
Form, these data are simultaneously displayed on mobile phone, are also not easy to user and are accurately and conveniently obtained oneself desired data.
Meanwhile, reporting system focuses mostly in production on computer platform and shows, and unopposed machine platform is supported.Thing
In reality, on current mobile phone terminal, form displaying control and form the displaying software not being molded also.
The content 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 to having generated
After-treatment is carried out, form content can easily be extracted and shown on the subscriber terminal, so as to meet transplanting form
Real need.
According to an aspect of the present invention, there is provided a kind of form methods of exhibiting, including:
Determine gauge outfit region, mechanism's dimension region, the data area time corresponding with form of form;
For each data cells in data area, the corresponding gauge outfit title of the data cells and machine are read
Structure dimension name;
By the pass of the data in the data cells and the gauge outfit title, mechanism's dimension name and form corresponding time
Connection relation is stored in database;
The agency node in gauge outfit father node and mechanism's dimension region in the ground floor of displaying gauge outfit region;
Selected according to user, the gauge outfit leaf node that displaying is associated with gauge outfit father node;
When user selects gauge outfit leaf node, inquire about corresponding with gauge outfit leaf node and current facility node in database
Associated data, wherein gauge outfit leaf node correspond to the gauge outfit title of cell residing for the associated data, current facility node pair
Mechanism's dimension name of cell residing for associated data described in Ying Yu;
Show the associated data.
Preferably, it is above-mentioned according to user select, displaying be associated with gauge outfit father node gauge outfit leaf node the step of include:
When user selects gauge outfit father node, using gauge outfit father node as present node;
Depth according to tree judges 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, the child node that will be selected repeats the depth according to tree as present node
Degree judges the step of whether present node has child node.
Preferably, the above-mentioned depth according to tree judges that the step of whether present node has child node includes:
Whether the number of plies where judging present node is less than the depth set;
If depth of the number of plies less than tree where present node, judges that present node has child node;
If the number of plies where present node is equal to the depth of tree, judge that present node does not have child node.
Preferably, the depth of tree is the number of plies in gauge outfit region.
Preferably, the gauge outfit region of above-mentioned determination form, mechanism's dimension region, the step of data area time corresponding with form
After rapid, also including carrying out structural configuration to gauge outfit region, then perform for each data cell in data area
The step of lattice, corresponding gauge outfit title of the reading data cells and mechanism's dimension name, wherein being tied to gauge outfit region
The step of structure is configured includes:
In gauge outfit region, the gauge outfit cell for all merging is split, the content of gauge outfit cell is constant after fractionation;
For each gauge outfit cell A in gauge outfit region, in arranged residing for gauge outfit cell A, according to from the top down
Sequentially, whole cell contents of the gauge outfit cell in the ground floor of gauge outfit region to gauge outfit cell A are merged, as with table
The title of the corresponding nodes of head unit lattice A;
In each layer in gauge outfit region, using title identical node as same node.
According to another aspect of the present invention, there is provided a kind of form exhibiting device, including area determination unit, title read it is single
Unit, storage control unit, the first display unit, the second display unit, query unit and the 3rd display unit, wherein:
Area determination unit, during for determining gauge outfit region, mechanism's dimension region, data area and the form of form to correspondence
Between;
Title reading unit, for for each data cells in data area, reading the data cells
Corresponding gauge outfit title and mechanism's dimension name;
Storage control unit, for by the data in the data cells and the gauge outfit title, mechanism's dimension name
The incidence relation of time corresponding with form is stored in database;
First display unit, for showing the machine in gauge outfit father node and mechanism's dimension region in the ground floor of gauge outfit region
Structure node;
Second display unit, for being selected according to user, the gauge outfit leaf node that displaying is associated with gauge outfit father node;
Query unit, for when user select gauge outfit leaf node when, in database inquiry with gauge outfit leaf node and currently
The corresponding associated data of agency node, wherein gauge outfit leaf node correspond to the gauge outfit title of cell residing for the associated data,
Current facility node corresponds to mechanism's dimension name of cell residing for the associated data;
3rd display unit, for showing the associated data.
Preferably, the second display unit is specifically included:
First mark module, for when user selects gauge outfit father node, using gauge outfit father node as present node;
Judge module, for judging whether present node has child node according to the depth of tree;If present node does not have
Child node, indicates the second mark module using present node as gauge outfit leaf node;If present node has child node, second is indicated
Display module shows the child node of present node;
Second mark module, for the instruction according to judge module, using present node as gauge outfit leaf node, indicates first
Display module shows gauge outfit leaf node;
First display module, for the instruction according to the second mark module, shows gauge outfit leaf node;
Second display module, for the instruction according to judge module, shows the child node of present node;
3rd mark module, for when user selects a child node, the child node that will be selected to refer to as present node
Show that judge module is performed and judge whether present node has the operation of child node according to the depth of tree.
Preferably, whether the number of plies where judge module specifically judges present node is less than the depth of tree, if present node
The number of plies at place then judges that present node has child node less than the depth of tree;If the number of plies where present node is equal to tree
Depth, then judge that present node does not have child node.
Preferably, the depth of tree is the number of plies in gauge outfit region.
Preferably, described device also includes gauge outfit dispensing unit, gauge outfit region, machine for determining form in territory element
Structure dimension region, after the time corresponding with form of data area, structural configuration is carried out to gauge outfit region, then indicate name read
Unit is taken to perform for each data cells in data area, read the corresponding gauge outfit title of the data cells and
The operation of mechanism's dimension name, wherein gauge outfit dispensing unit includes:
Cell splits module, for territory element determine the gauge outfit region of form, mechanism's dimension region, data area and
After the form correspondence time, in gauge outfit region, the gauge outfit cell for all merging, the content of gauge outfit cell after fractionation are split
It is constant;
Title determining module, for for each gauge outfit cell A in gauge outfit region, being arranged residing for gauge outfit cell A
In, according to order from the top down, by whole cells of the gauge outfit cell in the ground floor of gauge outfit region to gauge outfit cell A
Content merges, used as the title of node corresponding with gauge outfit cell A;
Node merging module, in each layer in gauge outfit region, using title identical node as same node, so
Indicate title reading unit to perform for each data cells in data area afterwards, read the data cells correspondence
Gauge outfit title and mechanism's dimension name operation.
The present invention claims by by the data in data cells with respective table first place, mechanism's dimension name and form to it is corresponding when
Between incidence relation storage in database, in the gauge outfit father node and mechanism's dimension region in the ground floor of displaying gauge outfit region
Agency node after, according to user's selection gauge outfit leaf node for being associated with gauge outfit father node of displaying.When user selects gauge outfit leaf
During node, associated data corresponding with gauge outfit leaf node and current facility node is inquired about in database, show the incidence number
According to.After-treatment is carried out by the form for having generated, form content can easily be extracted and be illustrated in user terminal
On, so as to meet the real need of transplanting form.
Brief description of the drawings
In order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
The accompanying drawing to be used needed for having technology description is briefly described, it should be apparent that, drawings in the following description are only this
Some embodiments of invention, for those of ordinary skill in the art, without having to pay creative labor, may be used also
Other accompanying drawings are obtained with according to these accompanying drawings.
Fig. 1 is the schematic diagram of form methods of exhibiting one embodiment of the present invention.
Fig. 2 is the schematic diagram of present invention displaying leaf node one embodiment.
Fig. 3 is the schematic diagram that gauge outfit region of the present invention configures one embodiment.
Fig. 4 is that the present invention configures the tree construction schematic diagram for obtaining by gauge outfit region.
Fig. 5 is the schematic diagram of form exhibiting device one embodiment of the present invention.
Fig. 6 is the schematic diagram of the second display unit one embodiment of the invention.
Fig. 7 is the schematic diagram of another embodiment of form exhibiting device of the present invention.
Fig. 8 is the schematic diagram of gauge outfit dispensing unit one embodiment of the present invention.
Specific 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 carried out clear, complete
Site preparation is described, it is clear that described embodiment is only a part of embodiment of the invention, rather than whole embodiments.Below
Description only actually at least one exemplary embodiment is illustrative, and never conduct is to the present invention and its application or makes
Any limitation.Based on the embodiment in the present invention, those of ordinary skill in the art are not making creative work premise
Lower obtained every other embodiment, belongs to the scope of protection of the invention.
Unless specifically stated otherwise, the part and positioned opposite, the digital table of step for otherwise illustrating in these embodiments
Do not limited the scope of the invention up to formula and numerical value.
Simultaneously, it should be appreciated that for the ease of description, the size of the various pieces shown in accompanying drawing is not according to reality
Proportionate relationship draw.
May be not discussed in detail for technology, method and apparatus known to person of ordinary skill in the relevant, but suitable
In the case of, the technology, method and apparatus should be considered as authorizing a part for specification.
In all examples shown here and discussion, any occurrence should be construed as merely exemplary, without
It is as limitation.Therefore, the other examples of exemplary embodiment can have different values.
It should be noted that:Similar label and letter represents similar terms in following accompanying drawing, therefore, once a certain Xiang Yi
It is defined in individual accompanying drawing, then it need not be further discussed in subsequent accompanying drawing.
Fig. 1 is the schematic diagram of form methods of exhibiting one embodiment of the present invention.Preferably, the method and step of the present embodiment can
Performed by form exhibiting device.
Step 101, determines gauge outfit region, mechanism's dimension region, the data area time corresponding with form of form.
Step 102, for each data cells in data area, reads the corresponding gauge outfit of the data cells
Title and mechanism's dimension name.
Step 103, the data in the data cells are corresponding with the gauge outfit title, mechanism's dimension name and form
The incidence relation of time is stored in database.
Step 104, the agency node in gauge outfit father node and mechanism's dimension region in the ground floor of displaying gauge outfit region.
Step 105, selects according to user, the gauge outfit leaf node that displaying is associated with gauge outfit father node.
Step 106, when user selects gauge outfit leaf node, inquiry and gauge outfit leaf node and current facility section in database
The corresponding associated data of point, wherein gauge outfit leaf node correspond to the gauge outfit title of cell residing for the associated data, current machine
Structure node corresponds to mechanism's dimension name of cell residing for the associated data.
Step 107, shows the associated data.
Based on the above embodiment of the present invention provide form methods of exhibiting, by by the data in data cells with it is corresponding
The incidence relation storage of gauge outfit title, mechanism's dimension name time corresponding with form in database, in displaying gauge outfit region the
After the agency node in gauge outfit father node and mechanism's dimension region in one layer, according to user's selection displaying and gauge outfit father node phase
The gauge outfit leaf node of association.When user selects gauge outfit leaf node, inquiry and gauge outfit leaf node and current facility in database
The corresponding associated data of node, shows the associated data.After-treatment is carried out by the form for having generated, can be by form
Appearance is easily extracted and shown on the subscriber terminal, so as to meet the real need of transplanting form.
Fig. 2 is the schematic diagram of present invention displaying leaf node one embodiment.As shown in Fig. 2 above-mentioned select according to user, exhibition
The step of showing the gauge outfit leaf node being associated with gauge outfit father node includes:
Step 201, when user selects gauge outfit father node, using gauge outfit father node as present node.
Step 202, the depth according to tree judges whether present node has child node.If present node is saved without son
Point, performs step 203;If present node has child node, step 204 is performed.
Wherein, the 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, the present embodiment is no longer performed
Other steps.
Step 204, shows the child node of present node.
Step 205, when user selects a child node, the child node that will be selected repeats step as present node
Rapid 202.
By aforesaid operations, the gauge outfit leaf node being associated with gauge outfit father node can be shown.
Preferably, the above-mentioned depth according to tree judges that the step of whether present node has child node includes:
Whether the number of plies where judging present node is less than the depth set.
If depth of the number of plies less than tree where present node, judges that present node has child node.
If the number of plies where present node is equal to the depth of tree, judge that present node does not have child node.
Preferably, the gauge outfit region of above-mentioned determination form, mechanism's dimension region, the step of data area time corresponding with form
After rapid, also including carrying out structural configuration to gauge outfit region, then perform for each data cell in data area
The step of lattice, corresponding gauge outfit title of the reading data cells and mechanism's dimension name.Tied by gauge outfit region
Structureization is configured, can the tree construction that goes out in gauge outfit region of combing.
Fig. 3 is the schematic diagram that gauge outfit region of the present invention configures one embodiment.Wherein:
Step 301, in gauge outfit region, splits the gauge outfit cell for all merging, the content of gauge outfit cell after fractionation
It is constant.
Step 302, for each gauge outfit cell A in gauge outfit region, in being arranged residing for gauge outfit cell A, according to from
Upper downward order, whole cell contents of the gauge outfit cell in the ground floor of gauge outfit region to gauge outfit cell A are merged,
As the title of node corresponding with gauge outfit cell A.
Step 303, in each layer in gauge outfit region, using title identical node as same node.
Below by a specific example, the present invention will be described.Table 1 is the form for needing to show.
Table 1
In above-mentioned form, A is classified as mechanism's dimension region, and B1-E3 regions are gauge outfit region, and B4-E4 regions are data field
Domain.
It is determined that behind each region of form, structural configuration is carried out to gauge outfit region.Specially:
1)The gauge outfit cell for all merging is split, the content of gauge outfit cell is constant after fractionation.Now form
As shown in table 2.
Table 2
2)In each column, carry out gauge outfit cell content merging by order from the top down, as to related gauge outfit list
The title of first corresponding node of lattice.According to above-mentioned merging mode, as shown in table 3, wherein symbol " $ " is separation to the title of each unit
Symbol.
Cell | Title |
B1 | Userbase |
B2 | Userbase $ reaches number |
B3 | Userbase $ reaches number $ and reaches number |
C1 | Userbase |
C2 | Userbase $ 3G subscription permeabilities |
C3 | Userbase $ 3G subscription permeabilities $ adds up to |
D1 | Userbase |
D2 | Userbase $ 3G subscription permeabilities |
D3 | Userbase 3G subscription permeability month is paid |
E1 | Userbase |
E2 | Userbase $ 3G subscription permeabilities |
E3 | Userbase $ 3G subscription permeability $ pre-payments |
Table 3
3)It can be seen in figure 3 that on the same layer in gauge outfit region, there is title identical node.For the ease of behaviour
Make, title identical node on same layer is considered as same node.Thus, the tree construction for obtaining is configured such as by said structureization
Shown in Fig. 4.
From fig. 4 it can be seen that the maximum level of each bifurcated is identical in tree construction.So treatment can help to reduce
System complexity, the operational efficiency of total system is not influenceed.
Simultaneously it can further be seen that each child node knows its father node from table 3, in this case it is not apparent that whether it there is son to save
Point.For example, content by last separator in child node title and afterwards is deleted, so that it may obtain the name of its father node
Claim.Because for a form, the depth of institute's spanning tree is a constant.Therefore the depth by setting can determine whether the node
Whether child node is had.Such as cell B2 is in the second layer, and the depth set is 3, then can determine that also there is cell B2 to save
Point.
After structural configuration is carried out to gauge outfit region, each data cells can be directed to, read the data cells phase
Corresponding gauge outfit title and mechanism's dimension name.For example, for cell B4, its gauge outfit is entitled, and " userbase $ is reached
Number $ reaches number ", its mechanism's dimension name is " Guangzhou ".According to [gauge outfit title, mechanism's dimension name, cell data, form
Time] form storage in database.
Preferably, for the ease of data transmission and treatment is, it is necessary to the Chinese information that will be read in form is passed according to system
The coding of numeral or character string is converted to the need for defeated.The conversion of this Chinese to coding is also by way of forming allocation list
Go to realize.
Coding and mechanism's dimension is indicated to compile for example, gauge outfit title and mechanism's dimension name can be converted into corresponding gauge outfit
Code, then storage format can be [gauge outfit indicates coding, mechanism's dimension coding, cell data, report time].
When displaying report data is needed, the gauge outfit father node in the ground floor of gauge outfit region and dimension area of mechanism are shown first
Agency node in domain.As shown in table 4.
Userbase | |
Guangzhou |
Table 4
When user clicks on " userbase ", show the child node " arrival number " of " userbase " and " 3G subscription permeates
Rate ", as shown in table 5.
Reach number | 3G subscription permeability | |
Guangzhou |
Table 5
When " arrival number " or " 3G subscription permeability " is further clicked on, can further show its corresponding child node.Example
Such as when " 3G subscription permeability " is clicked on, the child node of " 3G subscription permeability " is shown, as shown in table 6.
It is total | The moon pays | Pre-payment | |
Guangzhou |
Table 6
When the node clicked on is leaf node, that is, the node is not when having child node, inquiry and the leaf in database
The node associated data corresponding with current facility node, and the associated data is shown on terminal display device.
Fig. 5 is the schematic diagram of form exhibiting device one embodiment of the present invention.As shown in figure 5, form exhibiting device includes
Area determination unit 501, title reading unit 502, storage control unit 503, the first display unit 504, the second display unit
505th, the display unit 507 of query unit 506 and the 3rd.Wherein:
Area determination unit 501, gauge outfit region, mechanism's dimension region, data area and form pair for determining form
Between seasonable.
Title reading unit 502, for for each data cells in data area, reading the data cell
The corresponding gauge outfit title of lattice and mechanism's dimension name.
Storage control unit 503, for by the data in the data cells and the gauge outfit title, mechanism's dimension name
The incidence relation of time corresponding with form is claimed to store in database.
First display unit 504, for showing gauge outfit father node and mechanism's dimension region in the ground floor of gauge outfit region in
Agency node.
Second display unit 505, for being selected according to user, the gauge outfit leaf node that displaying is associated with gauge outfit father node.
Query unit 506, for when user select gauge outfit leaf node when, in database inquiry with gauge outfit leaf node and work as
The corresponding associated data of preceding agency node, wherein gauge outfit leaf node correspond to the gauge outfit name of cell residing for the associated data
Claim, current facility node corresponds to mechanism's dimension name of cell residing for the associated data.
3rd display unit 507, for showing the associated data.
Based on the above embodiment of the present invention provide form exhibiting device, by by the data in data cells with it is corresponding
The incidence relation storage of gauge outfit title, mechanism's dimension name time corresponding with form in database, in displaying gauge outfit region the
After the agency node in gauge outfit father node and mechanism's dimension region in one layer, according to user's selection displaying and gauge outfit father node phase
The gauge outfit leaf node of association.When user selects gauge outfit leaf node, inquiry and gauge outfit leaf node and current facility in database
The corresponding associated data of node, shows the associated data.After-treatment is carried out by the form for having generated, can be by form
Appearance is easily extracted and shown on the subscriber terminal, so as to meet the real need of transplanting form.
Fig. 6 is the schematic diagram of the second display unit one embodiment of the invention.As shown in fig. 6, the second display unit is specific
Including:
First mark module 601, for when user selects gauge outfit father node, using gauge outfit father node as present node.
Judge module 602, for judging whether present node has child node according to the depth of tree;If present node does not have
There is child node, indicate the second mark module 603 using present node as gauge outfit leaf node;If present node has child node, refer to
Show that the second display module 605 shows the child node of present node.
Second mark module 603, for the instruction according to judge module 602, present node as gauge outfit leaf node refers to
Show that the first display module 604 shows gauge outfit leaf node.
First display module 604, for the instruction according to the second mark module 603, shows gauge outfit leaf node.
Second display module 605, for the instruction according to judge module 602, shows the child node of present node.
3rd mark module 606, for when user selects a child node, the child node that will be selected to be used as working as prosthomere
Point, indicates judge module 602 to perform and judges whether present node has the operation of child node according to the depth of tree.
Preferably, whether the number of plies where judge module specifically judges present node is less than the depth of tree, if present node
The number of plies at place then judges that present node has child node less than the depth of tree;If the number of plies where present node is equal to tree
Depth, then 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.Compared with embodiment illustrated in fig. 5, in Fig. 7 institutes
In showing embodiment, also including gauge outfit dispensing unit 701, gauge outfit region, dimension area of mechanism for determining form in territory element
Domain, after the time corresponding with form of data area, structural configuration is carried out to gauge outfit region, then indicate title reading unit to hold
The hand-manipulating of needle reads the corresponding gauge outfit title of the data cells and mechanism's dimension to each data cells in data area
The operation of title.
Fig. 8 is the schematic diagram of gauge outfit dispensing unit one embodiment of the present invention.As shown in figure 8, gauge outfit dispensing unit includes:
Cell splits module 801, and gauge outfit region, mechanism's dimension region, the data field of form are determined for territory element
After the time corresponding with form of domain, in gauge outfit region, the gauge outfit cell for all merging, gauge outfit cell after fractionation are split
Content is constant.
Title determining module 802, for for each gauge outfit cell A in gauge outfit region, residing for gauge outfit cell A
In row, according to order from the top down, by whole units of the gauge outfit cell in the ground floor of gauge outfit region to gauge outfit cell A
Lattice content merges, used as the title of node corresponding with gauge outfit cell A.
Node merging module 803, in each layer in gauge outfit region, using title identical node as same section
Point, then indicates title reading unit to perform for each data cells in data area, reads the data cell
The operation of the corresponding gauge outfit title of lattice and mechanism's dimension name.
Preferably, form exhibiting device can be the mobile terminal of such as mobile phone.
By implementing the present invention, can effectively solve the data storage of form, convert and mobile phone terminal displaying problem, and by
The characteristics of Yu Qike easily obtains same metric history data, in that context it may be convenient to show chart.Simultaneously because structure
The extraction of each Index Content of form is relatively simple after change, quickly can reintegrate different forms and open up as needed
Show.So as to from practicality, reliability, the angle of low cost, cater to and the real need for meeting transplanting form.
One of ordinary skill in the art will appreciate that realizing that all or part of step of above-described embodiment can be by hardware
To complete, it is also possible to instruct the hardware of correlation to complete by program, described program can be stored in a kind of computer-readable
In storage medium, storage medium mentioned above can be read-only storage, disk or CD etc..
Description of the invention is given for the sake of example and description, and is not exhaustively or by the present invention
It is limited to disclosed form.Many modifications and variations are for the ordinary skill in the art obvious.Select and retouch
State embodiment and be to more preferably illustrate principle of the invention and practical application, and one of ordinary skill in the art is managed
The solution present invention is suitable to the various embodiments with various modifications of special-purpose so as to design.
Claims (8)
1. a kind of form methods of exhibiting, it is characterised in that including:
Determine gauge outfit region, mechanism's dimension region, the data area time corresponding with form of form;
Structural configuration is carried out to gauge outfit region;
For each data cells in data area, the corresponding gauge outfit title of the data cells and mechanism's dimension are read
Degree title;
The association of the data in the data cells and the gauge outfit title, mechanism's dimension name and form corresponding time is closed
System is stored in database;
The agency node in gauge outfit father node and mechanism's dimension region in the ground floor of displaying gauge outfit region;
Selected according to user, the gauge outfit leaf node that displaying is associated with gauge outfit father node;
When user selects gauge outfit leaf node, association corresponding with gauge outfit leaf node and current facility node is inquired about in database
Data, wherein gauge outfit leaf node correspond to the gauge outfit title of cell residing for the associated data, and current facility node corresponds to
Mechanism's dimension name of cell residing for the associated data;
Show the associated data;
Wherein, the step of carrying out structural configuration to gauge outfit region includes:
In gauge outfit region, the gauge outfit cell for all merging is split, the content of gauge outfit cell is constant after fractionation;
For each gauge outfit cell A in gauge outfit region, in being arranged residing for gauge outfit cell A, according to order from the top down,
Whole cell contents of the gauge outfit cell in the ground floor of gauge outfit region to gauge outfit cell A are merged, as with gauge outfit list
The title of first corresponding nodes of lattice A;
In each layer in gauge outfit region, using title identical node as same node.
2. method according to claim 1, it is characterised in that
According to user select, displaying be associated with gauge outfit father node gauge outfit leaf node the step of include:
When user selects gauge outfit father node, using gauge outfit father node as present node;
Depth according to tree judges 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, the child node that will be selected is repeated and sentenced according to the depth of tree as present node
The step of whether disconnected present node has child node.
3. method according to claim 2, it is characterised in that
Depth according to tree judges that the step of whether present node has child node includes:
Whether the number of plies where judging present node is less than the depth set;
If depth of the number of plies less than tree where present node, judges that present node has child node;
If the number of plies where present node is equal to the depth of tree, judge that present node does not have child node.
4. method according to claim 3, it is characterised in that
The depth of tree is the number of plies in gauge outfit region.
5. a kind of form exhibiting device, it is characterised in that including area determination unit, title reading unit, storage control unit,
First display unit, the second display unit, query unit, the 3rd display unit and gauge outfit dispensing unit, wherein:
Area determination unit, gauge outfit region, mechanism's dimension region, data area time corresponding with form for determining form;
Gauge outfit dispensing unit, for carrying out structural configuration to gauge outfit region;
Title reading unit, for for each data cells in data area, reading the data cells correspondence
Gauge outfit title and mechanism's dimension name;
Storage control unit, for by the data in the data cells and the gauge outfit title, mechanism's dimension name and report
The incidence relation of table correspondence time is stored in database;
First display unit, for showing that the mechanism in gauge outfit father node and mechanism's dimension region in the ground floor of gauge outfit region saves
Point;
Second display unit, for being selected according to user, the gauge outfit leaf node that displaying is associated with gauge outfit father node;
Query unit, for when user selects gauge outfit leaf node, being inquired about and gauge outfit leaf node and current facility in database
The corresponding associated data of node, wherein gauge outfit leaf node correspond to the gauge outfit title of cell residing for the associated data, currently
Agency node corresponds to mechanism's dimension name of cell residing for the associated data;
3rd display unit, for showing the associated data;
Wherein, gauge outfit dispensing unit includes:
Cell splits module, in gauge outfit region, splitting the gauge outfit cell for all merging, gauge outfit cell after fractionation
Content it is constant;
Title determining module, for for each gauge outfit cell A in gauge outfit region, in being arranged residing for gauge outfit cell A, pressing
According to order from the top down, by whole cell contents of the gauge outfit cell in the ground floor of gauge outfit region to gauge outfit cell A
Merge, as the title of node corresponding with gauge outfit cell A;
Node merging module, in each layer in gauge outfit region, using title identical node as same node.
6. device according to claim 5, it is characterised in that
Second display unit is specifically included:
First mark module, for when user selects gauge outfit father node, using gauge outfit father node as present node;
Judge module, for judging whether present node has child node according to the depth of tree;If present node is saved without son
Point, indicates the second mark module using present node as gauge outfit leaf node;If present node has child node, second is indicated to show
The child node of modules exhibit present node;
Second mark module, for the instruction according to judge module, using present node as gauge outfit leaf node, indicates first to show
Modules exhibit gauge outfit leaf node;
First display module, for the instruction according to the second mark module, shows gauge outfit leaf node;
Second display module, for the instruction according to judge module, shows the child node of present node;
3rd mark module, for when user selects a child node, the child node that will be selected to indicate to sentence as present node
Disconnected module is performed and judges whether present node has the operation of child node according to the depth of tree.
7. device according to claim 6, it is characterised in that
Whether the number of plies where judge module specifically judges present node is less than the depth set, if the number of plies where present node is small
In the depth of tree, then judge that present node has child node;If the number of plies where present node is equal to the depth of tree, judge to work as
Front nodal point does not have child node.
8. device according to claim 7, it is characterised in that
The depth of tree is the number of plies in gauge outfit region.
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 CN104142952A (en) | 2014-11-12 |
CN104142952B true 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) |
Families Citing this family (5)
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 |
CN108804401B (en) * | 2018-06-14 | 2022-06-21 | 南京云帐房网络科技有限公司 | Report template merging method and device |
CN109308284B (en) * | 2018-09-28 | 2023-09-19 | 中国平安财产保险股份有限公司 | Report menu generation method and device, computer equipment and storage medium |
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 |
Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
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 |
Family Cites Families (1)
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 |
-
2013
- 2013-05-10 CN CN201310170416.3A patent/CN104142952B/en active Active
Patent Citations (6)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
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报表处理与数据管理运行方案;***等;《油气田地面工程》;20130220;第32卷(第2期);第95页 * |
报表管理在IT运维***中的应用;贺艳琴第;《价值工程》;20120918(第26期);第215-216页 * |
Also Published As
Publication number | Publication date |
---|---|
CN104142952A (en) | 2014-11-12 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN104731954B (en) | Music is had an X-rayed based on group and recommends method and system | |
CN104142952B (en) | Method and device for showing reports | |
CN101299217B (en) | Method, apparatus and system for processing map information | |
CN104424266B (en) | Homepage Publishing method and system | |
CN102880687A (en) | Personal interactive data retrieval method and system based on tag technology | |
CN106897361B (en) | Label page grouping management system and method based on tree structure | |
CN103390044B (en) | Method and device for identifying linkage type POI (Point Of Interest) data | |
CN102314443B (en) | The modification method of search engine and system | |
CN106326413A (en) | Personalized video recommending system and method | |
CN103049440A (en) | Recommendation processing method and processing system for related articles | |
CN106445894B (en) | New media intelligent online edit methods, device and Web information issuance platform | |
CN102708453A (en) | Method and device for providing terminal fault solution | |
CN106156114A (en) | Patent retrieval method and device | |
CN106202294A (en) | The related news computational methods merged based on key word and topic model and device | |
CN112579852A (en) | Interactive webpage data accurate acquisition method | |
CN110188165A (en) | Contract template acquisition methods, device, storage medium and computer equipment | |
CN106156111A (en) | Patent document search method, device and system | |
CN108491326A (en) | Behavioral test recombination method, device and storage medium | |
CN103914488A (en) | Document collection, identification, association, search and display system | |
CN108090228A (en) | It is a kind of that interactive method and device is carried out by cultural cloud platform | |
CN107391650A (en) | A kind of structuring method for splitting of document, apparatus and system | |
CN103294670A (en) | Searching method and system based on word list | |
CN107451216A (en) | The granularity attribute recognition methods of label and device | |
CN106156352A (en) | Visual content management method and system | |
CN110222032A (en) | A kind of generalised event model based on software data analysis |
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 |