CN102479072A - Multi-header report generating method, device and terminal - Google Patents
Multi-header report generating method, device and terminal Download PDFInfo
- Publication number
- CN102479072A CN102479072A CN2010105551322A CN201010555132A CN102479072A CN 102479072 A CN102479072 A CN 102479072A CN 2010105551322 A CN2010105551322 A CN 2010105551322A CN 201010555132 A CN201010555132 A CN 201010555132A CN 102479072 A CN102479072 A CN 102479072A
- Authority
- CN
- China
- Prior art keywords
- column heading
- rule
- classification
- report
- definition
- 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
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention is suitable for the field of data processing, and provides a multi-header report generating method, device and terminal. The multi-header report generating method comprises the following steps of: receiving a grouping rule defined aiming at a report column header; storing the report column header generated according to the grouping rule; analyzing the stored report column header; and generating a corresponding multi-header report according to the report column header obtained through analysis. In the invention, the grouping rule is defined through the report column header, a storage structure and an analysis mechanism are designed for storing and analyzing the report column header generated according to the grouping rule, the analyzed report can generate a corresponding multi-head report, thus the problem of disorder column header is effectively solved, and demands of a user for rapidly recognizing report data are met; in addition, according to demands of different users, the stored grouping rule is only called to generate the corresponding multi-header report, thus development and maintenance costs of report software can be effectively reduced, and user satisfaction degree is improved.
Description
Technical field
The invention belongs to data processing field, relate in particular to a kind of generation method, device and terminal of multilist head form.
Background technology
Form is that a kind of the grade through form, chart come dynamic format of display data.It is the two-dimensional matrix that is made up of cell, and the intersection of row and column is confirmed cell, and cell content can be numeral or literal.In the column heading of form is expert at, is decomposed into multirow to delegation and comes the title formed gauge outfit of dividing into groups is called the multilist head.
Form is a part indispensable in the enterprise application software system, and along with the increase of user's request, form is listed as also in continuous increase; When the form row are increased to certain quantity, can cause the confusion of column heading, increase the difficulty that the user checks form; Can not satisfy the demand of user's quick identification report data; And to the report display requirement of different user, all need realize through the backstage code of frequent modification form software, increased form Development of Software and maintenance cost.
Summary of the invention
The purpose of the embodiment of the invention is to provide a kind of generation method of multilist head form, is intended to address the problem:
1, the form row too much cause the confusion of column heading, increase the difficulty that the user checks form;
2, to the report display requirement of different user, need realize, increase form Development of Software and maintenance cost through the backstage code of frequent modification form software.
The embodiment of the invention is achieved in that a kind of generation method of multilist head form, and said method comprises the steps:
Receive rule of classification to the definition of form column heading;
The form column heading that storage generates according to said rule of classification;
Resolve the form column heading of said storage;
The form column heading that obtains based on parsing generates corresponding multilist head form.
Another purpose of the embodiment of the invention is to provide a kind of generating apparatus of multilist head form, and said device comprises:
The rule of classification receiving element is used to receive the rule of classification to the definition of form column heading;
The column heading storage unit is used to store the form column heading that generates according to said rule of classification;
The column heading resolution unit is used to resolve the form column heading of said storage;
Multilist head report generation unit, the form column heading that is used for obtaining according to parsing generates corresponding multilist head form.
Another purpose of the embodiment of the invention is to provide a kind of terminal that comprises the generating apparatus of above-mentioned multilist head form.
In embodiments of the present invention, through the column heading definition rule of classification to form, design stores structure and mechanism for resolving are stored and are resolved the form column heading that generates according to said rule of classification; Form after the parsing can generate corresponding multilist head form, effectively solves the column heading confusion phenomena, satisfies the demand of user's quick identification report data; In addition; According to requirements of different users, only need call the stored packet rule and generate corresponding multilist head form, do not need frequently to revise the backstage code of form software; Can effectively reduce the development and maintenance cost of form, and improve user satisfaction.
Description of drawings
Fig. 1 is the realization flow figure of the generation method of the multilist head form that provides of the embodiment of the invention;
Fig. 2 is the particular flow sheet that the embodiment of the invention provides the form column heading of resolving storage;
Fig. 3 is the structural drawing of the generating apparatus of the multilist head form that provides of the embodiment of the invention.
Embodiment
In order to make the object of the invention, technical scheme and advantage clearer,, the present invention is further elaborated below in conjunction with accompanying drawing and embodiment.Should be appreciated that specific embodiment described herein only in order to explanation the present invention, and be not used in qualification the present invention.
The embodiment of the invention is through the column heading definition rule of classification to form, and design stores structure and mechanism for resolving are stored and resolved the form column heading that generates based on said rule of classification, and the form after the parsing can generate corresponding multilist head form; Effectively solve the column heading confusion phenomena; Satisfy the demand of user's quick identification report data, in addition, based on requirements of different users; Only need call the stored packet rule and generate corresponding multilist head form; Do not need frequently to revise the backstage code of form software, can effectively reduce the development and maintenance cost of form, and improve user satisfaction.
For technical scheme of the present invention is described, describe through specific embodiment below.
Embodiment one:
Fig. 1 shows the realization flow of the generation method of the multilist head form that the embodiment of the invention provides; The rule of classification that this method defines according to the column heading to form, design stores structure and mechanism for resolving are stored and are resolved the form column heading that generates according to said rule of classification, and the form after the parsing can effectively solve the column heading confusion phenomena; Satisfy the demand of user's quick identification report data; In addition, according to requirements of different users, only need call the stored packet rule and generate corresponding multilist head form; Can effectively reduce the cost that form is safeguarded, and improve user satisfaction.Its detailed step is described below:
In step S101, receive rule of classification to the definition of form column heading.
In embodiments of the present invention; The display format of form column heading can be carried out the definition of different grouping rule according to user's different demands; As: " X+Y ", " X+Y+Z " etc. divide into groups regular, and expression is cut apart first title and second title or first title, second title and the 3rd title etc. to the form column heading through "+" number (being not limited to this symbol).The rule of classification that area definition is good is selected for the user.Wherein a kind of definition form of rule of classification is described below by way of example, is not limited to this example, as shown in the table:
Table one
The form field | The form column heading | Whether visible | Field type | |
1 | A | Title | Be | Text |
2 | B | Basically+base unit quantity | Be | Quantity |
3 | C | Basically+base unit | Be | Numeral |
4 | D | Commonly used+conventional unit quantity | Be | Quantity |
5 | E | Commonly used+conventional unit | Be | Numeral |
Form column heading in the table one is in the description down of simple environment, and what the form column heading was defined is " X+Y " rule of classification, promptly the form column heading is cut apart first title and second title through "+" number (being not limited to this symbol).
To the Data Source of form, through following SQL statement: through following SQL statement:
" SELECT t_icitem.A, B, C, D, E FROM t_BOS200000001Entry2 INNER JOIN t_icitem ON t_BOS200000001Entry2.fbase=t_icitem.fitemid " realizes.Wherein, t_BOS200000001Entry2 representes the Data Source table of form, and t_icitem representes the associated data table of tables of data t_BOS200000001Entry2, carries out related with field fbase with fitemid.
In step S102, the form column heading that storage generates according to said rule of classification.
As embodiments of the invention, the form column heading that the rule of classification based on definition generates to be stored, file layout can be based on the different free hand modification of definition rule, to satisfy the personalized demand of different user fast.For example: the storage organization of the rule of classification of the column heading of definition is shown in table two in the table one.
Table two
The report mark symbol | The form column heading | The form field | |
1 | ID1 | Title | A |
2 | ID2 | Basically+base unit quantity | B |
3 | ID3 | Basically+base unit | C |
4 | ID4 | Commonly used+conventional unit quantity | D |
5 | ID5 | Commonly used+conventional unit | E |
Shown in table two, comprise the corresponding form field of unique identifier, form column heading and form column heading of form column heading in the table two, wherein, the form field is used to identify which field that the form column heading derives from data source.Form column heading in the table two is the description under simple environment, and title is cut apart first title and second title through "+", forms two gauge outfits.
In step S103, resolve the form column heading of said storage.
As a preferred embodiment of the present invention, the detailed process of form column heading of resolving said storage is as shown in Figure 2:
In step S201, obtain the form column heading of said storage.
In step S202, judge whether the said form column heading that obtains exists the rule of classification of definition.Otherwise execution in step S203 is execution in step S204 then.
In embodiments of the present invention; Form column heading to obtaining is judged; Deterministic process can adopt matching algorithm; This matching algorithm splits there being the form column heading of the rule of classification of definition in judging including, but not limited to string matching algorithm, in judging, does not exist the form column heading of the rule of classification of definition to generate single gauge outfit.
In step S203, the form column heading of the rule of classification that do not have said definition is generated single gauge outfit.
In step S204, the form column heading of the rule of classification that has said definition is split.
In step S205, after splitting, exist the column heading of identical characters string to be merged into the multilist head.
Through instantiation above resolving is described below, is exemplified below:
The form column heading of storage shown in table two at first, obtains the form column heading of storage in the table two; Then; Judge first value " title " in the form column heading through string matching algorithm, find not exist in first value " X+Y " rule of classification of definition, promptly do not exist "+" number; " title " extracted as independent delegation, promptly generate single gauge outfit.Continue to judge second value " basic+base unit quantity " in the form column heading; Find to exist in second value " X+Y " rule of classification of definition through string matching algorithm; Promptly exist "+" number; Will " basically+and base unit quantity " be split as " fundamental sum base unit quantity ", continue again to judge that the 3rd value " basic+base unit " in the form column heading finds also to exist in the 3rd value " X+Y " rule of classification that defines through string matching algorithm, " basic+base unit " is split as " fundamental sum base unit "; Because second value and the 3rd value after splitting comprise identical characters string " basically "; Adopt merge algorithm to merge, and the like, the multilist head that generates after the form column heading in the table two is resolved at last is shown in table three.
Table three
In step S104, the form column heading that obtains based on parsing generates corresponding multilist head form.
In embodiments of the present invention, resolve the corresponding form that generates behind the form column heading and have the multilist head, can effectively solve the column heading confusion phenomena, satisfy the demand of user's quick identification report data.Multilist head report generation process is exemplified below: the multilist head to generate is row; For example table three comprises A (title A1, base unit A2, base unit quantity A3, conventional unit A3, conventional unit quantity A5) five row; With the corresponding data that exists is row B; Through SQL Server SQL script: Select B, A Into R From B Cross Join A generates the multilist head form shown in table four:
Table four
Embodiment two:
Fig. 3 shows the structure of the generating apparatus of the multilist head form that the embodiment of the invention provides, and for the ease of explanation, only shows the part relevant with the embodiment of the invention among the figure.
The generating apparatus of this multilist head form can be used for the various terminals that possess data processing; For example notebook computer, pocket computing machine (Pocket Personal Computer; PPC), personal digital assistant (Personal Digital Assistant; PDA) etc. in, can be software unit, hardware cell or the software and hardware combining unit that is built in these application terminals.The generating apparatus of this multilist head form comprises rule of classification receiving element 31, column heading storage unit 32, column heading resolution unit 33 and multilist head report generation unit 34, wherein:
Rule of classification receiving element 31 is used to receive the rule of classification to the definition of form column heading.
In embodiments of the present invention; The display format of form column heading can be carried out the definition of different grouping rule according to user's different demands; As: " X+Y ", " X+Y+Z " etc. divide into groups regular, and expression is cut apart first title and second title or first title, second title and the 3rd title etc. to the form column heading through "+" number (being not limited to this symbol).The rule of classification that area definition is good is selected for the user.
Column heading storage unit 32 is used to store the form column heading that generates according to said rule of classification.
As embodiments of the invention, the form column heading that the rule based on definition generates to be stored, file layout can be based on the different free hand modification of definition rule, to satisfy the personalized demand of different user fast.Wherein, last table two shows a kind of file layout wherein.
Column heading resolution unit 33 is used to resolve the form column heading of said storage.Wherein, column heading resolution unit 33 comprises column heading acquisition module 331, is used to obtain the form column heading of said storage; Rule of classification judge module 332 is used to judge whether the said form column heading that obtains exists the rule of classification of definition; Processing module 333 is used for the form column heading of the rule of classification that has definition is split, and the form column heading of the rule of classification that do not have said definition is generated single gauge outfit; The first-born one-tenth module 334 of multilist is used for after splitting, existing the column heading of identical characters string to be merged into the multilist head.In embodiments of the present invention, resolving repeats no more at this specifically as stated.
Multilist head report generation unit 34, the form column heading that is used for obtaining according to parsing generates corresponding multilist head form.
In embodiments of the present invention, resolve the corresponding form that generates behind the form column heading and have the multilist head, can effectively solve the column heading confusion phenomena, satisfy the demand of user's quick identification report data.Corresponding multilist head form can be realized through the SQL script, as stated, repeat no more at this.
In embodiments of the present invention, through the column heading definition rule of classification to form, design stores structure and mechanism for resolving are stored and are resolved the form column heading that generates according to said rule of classification; Form after the parsing can generate corresponding multilist head form, effectively solves the column heading confusion phenomena, satisfies the demand of user's quick identification report data; In addition; According to requirements of different users, only need call the stored packet rule and generate corresponding multilist head form, do not need frequently to revise the backstage code of form software; Can effectively reduce the development and maintenance cost of form, and improve user satisfaction.
The above is merely preferred embodiment of the present invention, not in order to restriction the present invention, all any modifications of within spirit of the present invention and principle, being done, is equal to and replaces and improvement etc., all should be included within protection scope of the present invention.
Claims (6)
1. the generation method of a multilist head form is characterized in that, said method comprises the steps:
Receive rule of classification to the definition of form column heading;
The form column heading that storage generates according to said rule of classification;
Resolve the form column heading of said storage;
The form column heading that obtains based on parsing generates corresponding multilist head form.
2. the method for claim 1 is characterized in that, the step of the form column heading of the said storage of said parsing is specially:
Obtain the form column heading of said storage;
Judge whether the said form column heading that obtains exists the rule of classification of definition;
Form column heading to the rule of classification that has said definition splits;
After splitting, exist the column heading of identical characters string to be merged into the multilist head.
3. method as claimed in claim 2 is characterized in that, the form column heading of the rule of classification that do not have said definition is generated single gauge outfit.
4. the generating apparatus of a multilist head form is characterized in that, said device comprises:
The rule of classification receiving element is used to receive the rule of classification to the definition of form column heading;
The column heading storage unit is used to store the form column heading that generates according to said rule of classification;
The column heading resolution unit is used to resolve the form column heading of said storage;
Multilist head report generation unit, the form column heading that is used for obtaining according to parsing generates corresponding multilist head form.
5. device as claimed in claim 3 is characterized in that, said column heading resolution unit also comprises:.
The column heading acquisition module is used to obtain the form column heading of said storage;
The rule of classification judge module is used to judge whether the said form column heading that obtains exists the rule of classification of definition;
Processing module is used for the form column heading of the rule of classification that has definition is split, and the form column heading of the rule of classification that do not have said definition is generated single gauge outfit; And
The first-born one-tenth module of multilist is used for after splitting, existing the column heading of identical characters string to be merged into the multilist head.
6. terminal that comprises the generating apparatus of the said multilist head of claim 4 form.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201010555132.2A CN102479072B (en) | 2010-11-23 | 2010-11-23 | Multi-header report generating method, device and terminal |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201010555132.2A CN102479072B (en) | 2010-11-23 | 2010-11-23 | Multi-header report generating method, device and terminal |
Publications (2)
Publication Number | Publication Date |
---|---|
CN102479072A true CN102479072A (en) | 2012-05-30 |
CN102479072B CN102479072B (en) | 2014-07-09 |
Family
ID=46091727
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201010555132.2A Active CN102479072B (en) | 2010-11-23 | 2010-11-23 | Multi-header report generating method, device and terminal |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN102479072B (en) |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103809976A (en) * | 2014-02-19 | 2014-05-21 | 浪潮软件股份有限公司 | Method for associating workflow with multi-terminal-type forms |
CN108268480A (en) * | 2016-12-30 | 2018-07-10 | 亿阳信通股份有限公司 | A kind of big data shows method and apparatus |
CN109543169A (en) * | 2018-11-26 | 2019-03-29 | 成都四方伟业软件股份有限公司 | Report processing method and device |
CN114611478A (en) * | 2022-03-22 | 2022-06-10 | 孙向军 | Information processing method and system based on artificial intelligence and cloud platform |
Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101266598A (en) * | 2008-04-23 | 2008-09-17 | 北京润乾信息系统技术有限公司 | Cell grid quotation method based on non-linear report generation method |
CN101308490A (en) * | 2008-04-28 | 2008-11-19 | 北京航空航天大学 | Dynamic report generation method and platform |
CN101833583A (en) * | 2010-05-18 | 2010-09-15 | 中兴通讯股份有限公司 | Method, device and system for generating report form based on database |
-
2010
- 2010-11-23 CN CN201010555132.2A patent/CN102479072B/en active Active
Patent Citations (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN101266598A (en) * | 2008-04-23 | 2008-09-17 | 北京润乾信息系统技术有限公司 | Cell grid quotation method based on non-linear report generation method |
CN101308490A (en) * | 2008-04-28 | 2008-11-19 | 北京航空航天大学 | Dynamic report generation method and platform |
CN101833583A (en) * | 2010-05-18 | 2010-09-15 | 中兴通讯股份有限公司 | Method, device and system for generating report form based on database |
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN103809976A (en) * | 2014-02-19 | 2014-05-21 | 浪潮软件股份有限公司 | Method for associating workflow with multi-terminal-type forms |
CN108268480A (en) * | 2016-12-30 | 2018-07-10 | 亿阳信通股份有限公司 | A kind of big data shows method and apparatus |
CN109543169A (en) * | 2018-11-26 | 2019-03-29 | 成都四方伟业软件股份有限公司 | Report processing method and device |
CN114611478A (en) * | 2022-03-22 | 2022-06-10 | 孙向军 | Information processing method and system based on artificial intelligence and cloud platform |
Also Published As
Publication number | Publication date |
---|---|
CN102479072B (en) | 2014-07-09 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN101276361B (en) | Method and system for displaying related key words | |
CN101375278B (en) | Strategies for processing annotations | |
CN104461484B (en) | The implementation method and device of front-end template | |
CN100483417C (en) | Method for catching limit word information, optimizing output and input method system | |
US20130066818A1 (en) | Automatic Crowd Sourcing for Machine Learning in Information Extraction | |
CN103748579A (en) | Processing data in a mapreduce framework | |
US20130086035A1 (en) | Method and apparatus for generating extended page snippet of search result | |
US20120102391A1 (en) | Identifiers for web font templates | |
CN102314497B (en) | Method and equipment for identifying body contents of markup language files | |
CN101178720B (en) | Distributed clustering method facing to internet micro-content | |
CN101308488A (en) | Document stream type information processing method based on format document and device therefor | |
CN111428451B (en) | Text online editing method and device, electronic equipment and storage medium | |
CN110781183A (en) | Method and device for processing incremental data in Hive database and computer equipment | |
CN103345493A (en) | Method, device and system for text content displaying on mobile terminal | |
CN101963954A (en) | Method and device for displaying words | |
CN102479072B (en) | Multi-header report generating method, device and terminal | |
US20060271567A1 (en) | System and method for user edit merging with preservation of unrepresented data | |
CN106227575B (en) | Method for generating and analyzing text file | |
CN103500332A (en) | Character display method and device in image | |
CN101354723B (en) | Method and apparatus for implementing combined field | |
CN106649286A (en) | Method for conducting term matching on basis of double-array lexicographic tree | |
CN101714160A (en) | Picture searching method and system | |
CN103440197B (en) | A kind of method automatically generating difference test report based on contrast test | |
US9898523B2 (en) | Tabular data parsing in document(s) | |
CN106156262A (en) | A kind of search information processing method and system |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
C14 | Grant of patent or utility model | ||
GR01 | Patent grant |