CN102819564A - Method for generating report forms by limited table element combination - Google Patents
Method for generating report forms by limited table element combination Download PDFInfo
- Publication number
- CN102819564A CN102819564A CN2012102308094A CN201210230809A CN102819564A CN 102819564 A CN102819564 A CN 102819564A CN 2012102308094 A CN2012102308094 A CN 2012102308094A CN 201210230809 A CN201210230809 A CN 201210230809A CN 102819564 A CN102819564 A CN 102819564A
- Authority
- CN
- China
- Prior art keywords
- list cell
- report
- list
- matrix
- type
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention provides a method for generating report forms by a limited table element combination. A limited table element combination method is adopted to solve the problem of generating complicated production report forms. The method comprises the following steps of: 1) performing a characteristic analysis and logic region division on a report form to be generated; 2) constructing a table element matrix E in accordance with characteristics of table element positions; 3) utilizing Excel to design a style template of the report form and providing a table element position matrix P corresponding to the table element matrix E; 4) forming a table element type matrix T corresponding to the table element matrix E; 5) combining the style template, computing an offset of each table element, and forming an offset matrix O; 6) adopting a framework structure to define report form objects to form a report form definition based on information; and 7) processing the report form definition by a report form engine and generating the report form. The method has the advantages that: a complicated report form is divided into a number of limited types of table elements, thus reducing complexity and being simple and convenient to be used easily; and an Excel visualization definition report form style template is adopted to reduce learning cost of a system.
Description
Technical field
The present invention relates to the report form generation method of the first combination of a kind of finite table, belong to areas of information technology.
Background technology
The report generation technology has critical role in the development of management information system; Can add up, gather each item production data of producing in the operation period through form; The form that produces can be multi-level with the operating state of enterprise, the representing to the supvr of multi-angle, is the necessary means of producing operating state analysis, programmed decision-making.
On report form processing; Art methods generally is the definition template; In the definition template, be tied to data source; Submit to Report Engine then and handle, the ease for use and the practicality of report form generation method depend on report form template, and the define method that is to say report form template is the key of report form processing technology.
The report tool of existing main flow is all monopolized by external a few report tool developers of family, not only costs an arm and a leg, and medium-sized and small enterprises are difficult to bear and are more loaded down with trivial details aspect template definition, on function, also is difficult to support complicated Chinese style form demands of developing; Domestic form product is simple, the poor-performing of function often again, can't satisfy the needs of practical application.
Summary of the invention
The generation of form relates to report definition, report style template and Report Engine; Can adopt Excel to carry out visual establishment for the report style template; Report Engine is dynamically obtained the data in the database according to report definition; And by report style padding data that weaves in advance and demonstration, in the report definition process, how complex report forms being described is the key of report generation; The present invention proposes the report form generation method of the first combination of a kind of finite table, adopt finite table unit combination method to solve complicated production report generation problem.
According to technical scheme provided by the invention, the report form generation method of the first combination of a kind of finite table may further comprise the steps:
(1) to the form that will generate according to be divided into several list cell of list cell characteristic with form zone logic;
(2) being positioned at the regional position characteristic of form by list cell, is the corresponding entry among the list cell matrix E with the element map in the list cell set, makes up list cell matrix E;
(3) utilize the pattern template of Excel design form, provide with the corresponding list cell location matrix of list cell matrix E P by the cell location of list cell viewing area in the pattern template;
(4) each item among the list cell matrix E is replaced with this pairing list cell type, form and the corresponding list cell type of list cell matrix E matrix T;
(5) combine the pattern template, and calculate the side-play amount of each list cell, form side-play amount matrix O;
(6) information that obtains based on step 2～5 adopts framed structure definition form object; Comprising slot name, groove attribute and method groove; Slot name is expressed as the statistical report form title, characteristic attribute, type and the associated framework of groove attribute representation form, and the method groove is represented the method behavior that report data obtains; Each item information mapping in slot name, groove attribute and method groove, is formed report definition;
(7) report definition, the report style template that generate are deployed in the Report Engine working directory; Transfer to Report Engine and carry out Data Acquisition; And be filled in the report style instance document by the report definition extracted data and with data; Then to browser return generate form URL so that browse form, report generation process so far finishes.
In the said method, the zone logical partitioning is a plurality of list cells to form according to the indicating characteristic of form, has and have only a kind of specific list cell type corresponding with it for each specific list cell, and list cell is the Minimum Area unit that constitutes the report display zone; The list cell type is the type specification to the report display characteristic; Be with the form zone by the foundation that is logically divided into list cell, the list cell type has three types of patterns: fixed type list cell α, single hurdle type of growth list cell β, multicolumn type of growth list cell γ, matrix-type list cell η; Fixed type list cell characteristics are that the list area form is fixed, and a plurality of list items can foreseen and have to the expressed data message item of list area in advance; It is single-row that single hurdle type of growth list cell characteristics are that list area is divided into, and is listed as expressed data message with the basic data dynamic growth; Multicolumn type of growth list cell characteristics are that list area is divided into multiple row, and each is listed as expressed data message all with the basic data dynamic growth; The record line number of matrix-type list cell, columns are all with the basic data dynamic growth.
For any list cell set { e
1, e
2... e
nIn arbitrary element e
iE is all arranged
i∈ { α, beta, gamma, η } decomposes by given finite table unit's type { α, beta, gamma, η } the viewing area R of complex report forms to the report display region R, form list cell set { e
1, e
2... e
n.
The reference position side-play amount of said each list cell of calculating of step 5, the side-play amount computing formula of forming side-play amount matrix O is:
Wherein i is the positive integer greater than 1, and On is expressed as the side-play amount of n table section, L
nBe expressed as the record line number of n table section.
Advantage of the present invention is:
1, complex report forms is decomposed into the list cell of some limited kinds, reduces complexity, easy to be easy-to-use.
2, adopt the visual definition report style of Excel template, the systematic learning cost is low.
Description of drawings
Fig. 1 is a process flow diagram of the present invention.
Fig. 2 is all types of list cell indicating characteristic exemplary plot.Wherein Fig. 2 (a) is fixed type list cell examples of features figure, and Fig. 2 (b) is single hurdle type of growth list cell examples of features figure, and Fig. 2 (c) is multicolumn type of growth list cell examples of features figure, and Fig. 2 (d) is matrix-type list cell examples of features figure.
Fig. 3 is that list area is divided exemplary plot.
Fig. 4 is a list cell side-play amount definition exemplary plot.
Embodiment
Below in conjunction with accompanying drawing and embodiment the present invention is described further.
As shown in Figure 1, the present invention includes following steps: 1. the form that will generate is carried out signature analysis and carry out the logic region division; 2. press the list cell position characteristic, make up list cell matrix E; 3. utilize the pattern template of Excel design form and provide with the corresponding list cell location matrix of list cell matrix E P; 4. form and the corresponding list cell type of list cell matrix E matrix T; 5. combine the pattern template also, calculate the side-play amount of each list cell, form side-play amount matrix O; 6. adopt framed structure definition form object to form report definition based on above-mentioned information; 7. transfer to Report Engine and handle and generate form.
List cell is according to the logical partitioning to the form zone of the indicating characteristic of form, has and have only a kind of specific list cell type corresponding with it for each specific list cell, is the Minimum Area unit that constitutes the report display zone.The list cell type is the type specification to the report display characteristic; Be by the foundation that is logically divided into list cell with this table section; The list cell type has three types of patterns; Be fixed type list cell α, single hurdle type of growth list cell β, multicolumn type of growth list cell γ and matrix-type list cell η, all types of indicating characteristic examples such as accompanying drawing 2.Like Fig. 2 (a), fixed type list cell characteristics are that the list area form is fixed, the expressed data message item of list area can foresee in advance and list item more; Like Fig. 2 (b), it is single-row that single hurdle type list cell characteristics are that list area is divided into, and is listed as expressed data message with the basic data dynamic growth, is mainly used in the situation that the expressed quantity of information of list area is unpredictable and list item is more; Like Fig. 2 (c); Multicolumn type list cell characteristics are that list area is divided into multiple row; Each is listed as expressed data message all with the basic data dynamic growth; Be mainly used in the expressed data message of list area all with the basic data dynamic growth, be mainly used under the situation that the expressed quantity of information of list area is unpredictable and list item is less, can effectively utilize the limited display space of the page; Like Fig. 2 (d), matrix-type list cell characteristics be list area row, row all with the basic data dynamic growth.
Promptly for any list cell set { e
1, e
2... e
nIn arbitrary element e
iE is all arranged
i∈ { α, beta, gamma, η }.
Finite table unit combinational algorithm is described below:
A) the viewing area R with complex report forms decomposes the report display region R by above-mentioned given finite table unit's type { α, beta, gamma, η }, forms list cell set { e
1, e
2... e
n.
B) with list cell set { e
1, e
2... e
nBe positioned at the regional position characteristic of report display by list cell, and be the corresponding entry among the list cell matrix E with the element map in the list cell set, be divided into example with the list area in the accompanying drawing 3, the expression formula of list cell matrix E is following:
Among Fig. 3, we distinguish three list cell: e from top to bottom with the report display zone
1, e
2, e
3
C) be cell with the report display area dividing, provide with the corresponding list cell location matrix of list cell matrix E P by the cell location of list cell in the viewing area.With accompanying drawing 3 is example, e
1The list cell position with (x
1, y
1) expression, e
2The list cell position with (x
2, y
2) expression, e
3The list cell position with (x
3, y
3) expression.The expression formula of list cell location matrix P following:
D) each item among the list cell matrix E is replaced with this pairing list cell type, form and the corresponding list cell type of list cell matrix E matrix T.With accompanying drawing 3 is example, and the expression formula of list cell type matrix T is following:
Be list cell e
1Be the fixed type list cell, list cell e
2Be multicolumn type of growth list cell, e
3Be the fixed type list cell.
E) calculate the side-play amount of each list cell, form side-play amount matrix O, so-called list cell side-play amount definition is shown in accompanying drawing 4, and the side-play amount computing formula is:
Wherein i is the positive integer greater than 1, O
nBe expressed as the side-play amount of n table section, L
nBe expressed as the record line number of n table section, wherein the side-play amount of the 1st table section can be set to constant when the design report style.To be example among Fig. 3, by formula can get the side-play amount matrix
F) as stated above form is analyzed after; Adopt framed structure definition form object; Wherein: comprise slot name, groove attribute and method groove, so just obtain report description (RD) and report data and combine that wherein slot name is expressed as the statistical report form title; Characteristic attribute, type and the associated framework of groove attribute representation form, method groove are represented the method behavior that report data obtains.With correct being mapped in slot name, groove attribute and the method groove of each item information, form report definition.Define as follows:
Report frame
Frame name: < report name >
Report form template file attribute: < report form template filename >
Show Styles template file attribute: < indicating template filename >
List area information frame name: < list area information frame name >
Data getattr: < storing process name >
Control of authority attribute: < control of authority framework >
List area information framework
Frame name: < list area name >
List area name attribute: < 1 of list area >, < 2 of list areas>...
List area attribute: < the 1 yuan of type in list area >, < the 2 yuan of types in list area>...
The list area attribute of a configuration: <table 1 format region><table 2 format region>...
The sheet format gimbal region
Frame name: < sheet format name >
Reference position attribute: < reference position among the pattern Excle >
End position attribute: < end position among the pattern Excle >
Row headers position attribution: < position of row headers in pattern Excle >
Column heading position attribution: < position of column heading in pattern Excle >
Side-play amount attribute: <being arranged in the reference position of Excel pattern >
The authority information framework
Frame name: < authority name >
User role attribute: < can use the role of form >
G) report definition, the report style template that generate are deployed in the Report Engine working directory; Transfer to Report Engine and carry out Data Acquisition; And be filled in the report style instance document by the report definition extracted data and with data; Then to browser return generate form URL so that browse form, report generation process so far finishes.
Claims (4)
1. the report form generation method of finite table unit combination is characterized in that, may further comprise the steps:
(1) to the form that will generate according to be divided into several list cell of list cell characteristic with form zone logic;
(2) being positioned at the regional position characteristic of form by list cell, is the corresponding entry among the list cell matrix E with the element map in the list cell set, makes up list cell matrix E;
(3) utilize the pattern template of Excel design form, provide with the corresponding list cell location matrix of list cell matrix E P by the cell location of list cell viewing area in the pattern template;
(4) each item among the list cell matrix E is replaced with this pairing list cell type, form and the corresponding list cell type of list cell matrix E matrix T;
(5) combine the pattern template, and calculate the side-play amount of each list cell, form side-play amount matrix O;
(6) information that obtains based on step 2～5 adopts framed structure definition form object; Comprising slot name, groove attribute and method groove; Slot name is expressed as the statistical report form title, characteristic attribute, type and the associated framework of groove attribute representation form, and the method groove is represented the method behavior that report data obtains; Each item information mapping in slot name, groove attribute and method groove, is formed report definition;
(7) report definition, the report style template that generate are deployed in the Report Engine working directory; Transfer to Report Engine and carry out Data Acquisition; And be filled in the report style instance document by the report definition extracted data and with data; Then to browser return generate form URL so that browse form, report generation process so far finishes.
2. the report form generation method of the first combination of finite table as claimed in claim 1; It is characterized in that; The zone logical partitioning is a plurality of list cells to form according to the indicating characteristic of form; Have and have only a kind of specific list cell type corresponding with it for each specific list cell, list cell is the Minimum Area unit that constitutes the report display zone; The list cell type is the type specification to the report display characteristic; Be with the form zone by the foundation that is logically divided into list cell, the list cell type has three types of patterns: fixed type list cell α, single hurdle type of growth list cell β, multicolumn type of growth list cell γ, matrix-type list cell η; Fixed type list cell characteristics are that the list area form is fixed, and a plurality of list items can foreseen and have to the expressed data message item of list area in advance; It is single-row that single hurdle type of growth list cell characteristics are that list area is divided into, and is listed as expressed data message with the basic data dynamic growth; Multicolumn type of growth list cell characteristics are that list area is divided into multiple row, and each is listed as expressed data message all with the basic data dynamic growth; The record line number of matrix-type list cell, columns are all with the basic data dynamic growth.
3. the report form generation method of the first combination of finite table as claimed in claim 2 is characterized in that, for any list cell set { e
1, e
2... e
nIn arbitrary element e
iE is all arranged
i∈ { α, beta, gamma, η } decomposes by given finite table unit's type { α, beta, gamma, η } the viewing area R of complex report forms to the report display region R, form list cell set { e
1, e
2... e
n.
4. the report form generation method of the first combination of finite table as claimed in claim 1 is characterized in that, the reference position side-play amount of said each list cell of calculating of step 5, and the side-play amount computing formula of forming side-play amount matrix O is:
Wherein i is the positive integer greater than 1, O
nBe expressed as the side-play amount of n table section, L
nBe expressed as the record line number of n table section.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2012102308094A CN102819564A (en) | 2012-07-05 | 2012-07-05 | Method for generating report forms by limited table element combination |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2012102308094A CN102819564A (en) | 2012-07-05 | 2012-07-05 | Method for generating report forms by limited table element combination |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN102819564A true CN102819564A (en) | 2012-12-12 |
Family
ID=47303675
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2012102308094A Pending CN102819564A (en) | 2012-07-05 | 2012-07-05 | Method for generating report forms by limited table element combination |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102819564A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103823793A (en) * | 2014-03-05 | 2014-05-28 | 成都交大光芒科技股份有限公司 | Realizing method for dynamic report based on Excel template |
| CN105930323A (en) * | 2015-09-06 | 2016-09-07 | 中国银联股份有限公司 | File generating method and apparatus |
| CN107329944A (en) * | 2017-07-04 | 2017-11-07 | 武汉斗鱼网络科技有限公司 | Report form generation method, device and electronic equipment |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101281462A (en) * | 2007-04-05 | 2008-10-08 | 中茂电子(深圳)有限公司 | Report forms generating system and method |
| CN101833583A (en) * | 2010-05-18 | 2010-09-15 | 中兴通讯股份有限公司 | Method, device and system for generating report form based on database |
| EP2343670A2 (en) * | 2010-01-06 | 2011-07-13 | Canon Kabushiki Kaisha | Apparatus and method for digitizing documents |
-
2012
- 2012-07-05 CN CN2012102308094A patent/CN102819564A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101281462A (en) * | 2007-04-05 | 2008-10-08 | 中茂电子(深圳)有限公司 | Report forms generating system and method |
| EP2343670A2 (en) * | 2010-01-06 | 2011-07-13 | Canon Kabushiki Kaisha | Apparatus and method for digitizing documents |
| CN101833583A (en) * | 2010-05-18 | 2010-09-15 | 中兴通讯股份有限公司 | Method, device and system for generating report form based on database |
Non-Patent Citations (1)
| Title |
|---|
| 潘福成等: "基于XML的智能报表生成工具的研究", 《小型微型计算机系统》, vol. 26, no. 1, 31 January 2005 (2005-01-31), pages 134 - 138 * |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103823793A (en) * | 2014-03-05 | 2014-05-28 | 成都交大光芒科技股份有限公司 | Realizing method for dynamic report based on Excel template |
| CN103823793B (en) * | 2014-03-05 | 2016-09-14 | 成都交大光芒科技股份有限公司 | Dynamic statement implementation method based on Excel template |
| CN105930323A (en) * | 2015-09-06 | 2016-09-07 | 中国银联股份有限公司 | File generating method and apparatus |
| CN105930323B (en) * | 2015-09-06 | 2019-05-24 | 中国银联股份有限公司 | A kind of document generating method and device |
| CN107329944A (en) * | 2017-07-04 | 2017-11-07 | 武汉斗鱼网络科技有限公司 | Report form generation method, device and electronic equipment |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US10354002B2 (en) | Interaction relationship building and explorer for dashboard | |
| CN103019728B (en) | Effective complex report parsing engine and parsing method thereof | |
| CN103064689B (en) | The implementation method of a kind of Dynamic Generating Report page and system | |
| CN101908039B (en) | Report template customizing system | |
| CN106202447B (en) | A kind of digital cartography system having production and management integration | |
| EP2048620B1 (en) | Apparatus and method for visualizing data within a decomposition graph | |
| US20120303645A1 (en) | System and method for extraction of structured data from arbitrarily structured composite data | |
| CN103729337B (en) | report conversion method and device | |
| CN102609227B (en) | Information processing apparatus, layout generating method | |
| CN102917009B (en) | A kind of stock certificate data collection based on cloud computing technology and storage means and system | |
| CN104102636B (en) | A kind of statistics of page data, rendering method and device | |
| CN103955558A (en) | Method for collecting and processing engineering investigation data of different industries | |
| CN103617496A (en) | Informatization report automatic generating method and system | |
| CN103646100A (en) | Report data organization model | |
| Li et al. | Method for managing and querying geo-spatial data using a grid-code-array spatial index | |
| CN103136791A (en) | Data association method and data association device used for airplane digitalization maintenance and application | |
| CN102184099A (en) | Method, device and system used for configuring and generating application software report forms | |
| CN102819564A (en) | Method for generating report forms by limited table element combination | |
| CN102799750B (en) | Method for quickly generating common side and non-common sides of geometry surface triangle | |
| CN103942266A (en) | Data analysis method capable of achieving self-defining of complex service computational logic on basis of OLAP | |
| CN105760370A (en) | Plug-in type report framework technology | |
| CN101038583B (en) | Gold report generating and generating method thereof | |
| CN107480235A (en) | A kind of database framework of data platform | |
| CN105930354B (en) | Storage model conversion method and device | |
| CN101833583A (en) | Method, device and system for generating report form based on database |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20121212 |