CN101246471A - Irregular complex report forms creating method - Google Patents
Irregular complex report forms creating method Download PDFInfo
- Publication number
- CN101246471A CN101246471A CNA2008100141822A CN200810014182A CN101246471A CN 101246471 A CN101246471 A CN 101246471A CN A2008100141822 A CNA2008100141822 A CN A2008100141822A CN 200810014182 A CN200810014182 A CN 200810014182A CN 101246471 A CN101246471 A CN 101246471A
- Authority
- CN
- China
- Prior art keywords
- data
- report
- subreport
- cell
- alignment
- 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
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention belongs to the information technology processing field, specifically a creating method of irregular complicated report particularly in electronic report creating field. The plan is accomplished through following technical measurements: (1) selecting module that the report belongs to, establishing report data set; (2) establishing a plurality of sub-reports according to report local regularity, binding corresponding data set to the sub-reports; (3) configuring associating, layout aligning property of the sub-report data; (4) compiling data calculating expression to the cell; (5) operating report module to actual report. Advantages of the invention are: sub-report association reduces data preparation difficulty; sub-report alignment, the report layout is not destroyed by expansion; the data is easy to cit and the report operation is simple to accomplish.
Description
Technical field
The invention belongs to the Information Technology Agreement field, particularly generate the field, relate to a kind of generation method of irregular complex report forms at electronic report forms.
Background technology
In traditional electronic report forms generation method, can be divided into two kinds generally.A kind of Excel with Microsoft is representative.This class form does not generally need dynamically to organize data from data sources such as database, after utilizing the instrument design to finish, the result who obtains is exactly final form.Another kind is representative with crystal report, middle wound InforReport then, this class form needs to organize data from data sources such as databases dynamically, after utilizing the instrument design to finish, can only obtain intermediate result (field term is called report form template), need with just obtaining final form after the further processing.
In second kind of report form generation method, the report tool of at first quoting that is based on the bar band model.This class form model is derived from Western-style form, runs into more problem when (field term is called the Chinese style form) at the distinct Chinese characteristics form of handling some data complexity, form complexity, calculation of complex.The domestic technique personnel explored and improved it afterwards, produced report tool based on grid model, this class instrument combines some characteristics of Chinese style form, is listed as to aspects such as expansions at multiple data origin, based on layout, the form of grid and has all proposed good solution.But because the complicacy of Chinese style form, still there is more problem in above-mentioned solution.Outstanding behaviours exists:
1. the Chinese style form is regular from a part, can reduce a certain form model and handle, and be exactly irregular still on the whole, it can not be divided into any model.(abbreviate as: local rule, whole irregular).For handling this class problem, classic method has two kinds: the one, and in the form zone, introduce subreport, but, cause form to lose the former data association that pre-exists, and cause original layout to be destroyed because subreport and master meter height are independent.Second method is to smash the form model concept, and the attribute of form is transferred on the cell, finishes the design of regional area by the setting of cell.Though this method is brought some dirigibilities, still can destroy original Report layouts, and make loaded down with trivial detailsization of Report Form Design, reduced the abstract granularity of form.
2. the data operation of Chinese style form is simple relatively, is generally the univeral mathematics computing; But data referencing is very complicated, and the data of participating in computing have very big arbitrariness.(abbreviate as: data operation is simple, data referencing is complicated.) and classic method when handling this class computing, single certain cell data or two kinds of forms of unified reference data collective data quoted generally only are provided.Cause under a lot of situations data operation to anticipate, strengthened the workload and the difficulty of report generation greatly by background program.
Summary of the invention
Defective at the traditional Chinese report generation, this invention has solved the destruction problem of subreport expansion to the form integral layout, layout alignment and data association between subreport have been realized, method of data reference flexibly is provided, solve the pretreated problem of data operation dependence background program in the Chinese style form, realized data operation flexibly.
This programme is realized by following technical measures:
(1) selects the affiliated model of form, set up the report data collection;
(2) according to the form local rule, set up a plurality of subreports, the corresponding data collection is tied in the subreport;
(3) subreport data association, layout alignment properties are set;
(4) write the data computation expression formula to cell;
(5) the operation report form template obtains actual form.
In the step 1, the form model is abstract in advance good, and the user can directly select, and also can change in the Report Form Design stage.Data set can be a plurality of, and can comprise database, Java object, text (other file that comprises csv file and self-defined decollator), XML file (the XML structure is unrestricted) from different data sources.
The field of data set is except that from data source directly obtains, and can calculate by other fields and obtain (being called calculated field), and generate automatically and obtain (be called and append field, generate such as sequence number, and the field splicing etc.).
In the step 2, set up at least one subreport according to local rule in a form, each subreport belongs to a certain form model.The data set that step 1 is set up is tied in the subreport then.So-called binding is exactly that field with data set is set in the extended area under the subreport, and extended area is made up of the sequential cells lattice in the subreport, and the extended attribute of extended area is set simultaneously.Comprise propagation direction, expansion number of times.Can be provided with downwards or expansion to the right, and minimum expansion number of times, largest extension number of times.
In the step 3, the business association relation according to data between subreport is provided with two data external key associations between subreport.This association is divided into outside interior connection (only showing the associated match data), the left side and connects (complete demonstration left-handed watch data, the right non-matched data of showing replace with sky or designated symbols), the right side is outer connects (complete demonstration right side table data, left-handed watch non-matched data are with sky or designated symbols replacement), 4 kinds of modes of complete outer connection (complete demonstration left-handed watch, the right data of showing, non-matched data replaces with sky or designated symbols).Set up related between subreport by link field.Subreport can to set up external key related with a plurality of subreports, and link field needn't force to be tied to extended area.
The inside and outside connection of the similar SQL of coupling of subreport data association.After the data association attribute was set, the matched record in the extended area of these two subreports starting point of extended area relatively separately produced identical offset.
Behind the subreport data association, field ordering, the grouping that can be provided with based on whole connection result set are provided with.Ordering in each subreport, grouping are provided with not revival.
For guaranteeing the integrality of form integral layout, the subreport alignment properties can be set.This attribute can guarantee the subreport data set after padding data forms actual form, still can keep the alignment relation of setting each other, avoids occurring form " vacuum " zone that causes because of expansion.
The subreport alignment comprises: highly alignment, 2 kinds of modes of width alignment.The subreport that the sublist reference position is positioned on the different lines can be provided with the height alignment properties, and the subreport on the different rows can be provided with the width alignment properties.Same subreport can be provided with highly alignment, width alignment properties respectively with two different subreports simultaneously.
After subreport was provided with highly alignment, the lower boundary that actual padding data is finished latter two subreport of expansion was positioned at in the delegation, and for the width alignment similarly, after actual padding data was finished expansion, the right margin of expansion back subreport was positioned at same listing.
Sublist alignment subreport can be provided with the filling mode in expansion " vacuum " zone, comprising: the extended area cell is filled, footline/row merge, the merging of initial lattice, etc. 4 kinds of modes of branch/row merging.It is exactly to fill new expansion " vacuum " zone of expanding with the cell form of subreport extended area that the extended area cell is filled, until aliging with another subreport.It then is that the row/row of expansion at last develop into that Merge Cells and then downward/right side merges processing that footline/row merges.Initial lattice merge merges into a big Merge Cells with all expansions " vacuum " zone exactly.Deng the merging of branch/row is that new region is divided into several sections, merges respectively then.
In the step 4, mainly carry out filling in of form expression formula.The compute mode that exists in the form, operational method are generally fairly simple, common mathematical operation, logical operation and statistical method can satisfy most of demand, but the data of participation computing are more complicated often, and therefore providing flexibly, the data referencing mode is the key that solves a report data computing difficult problem.In this invention, the form expression formula is removed outside conventional operation mode, the operational methods such as arithmetic, logical expression, built-in function, and emphasis is to have increased quoting cell data, number of data sets certificate.
Specifically, the coordinate of cell data referencing is described 2 kinds of methods: absolute coordinates is quoted, relative coordinate.
Absolute coordinates precedents data are meant by the designating unit lattice quotes certain cell data of form expansion back at the coordinate of design point.Though the actual coordinate of certain cell of expansion back may become, and quotes still by absolute coordinates and can have access to it.The form that absolute coordinates is quoted is “ $C{#＜row coordinate 〉, #＜row-coordinate〉"
Relative coordinate precedents data are meant the data of quoting certain cell of expansion back by the relative ranks off-set value of designating unit.Though a cell expansion still can be quoted respectively it by relative coordinate for a row/row cell like this.The form that absolute coordinates is quoted is “ $C{＜line skew 〉,＜line displacement〉"
No matter be absolute coordinates or relative coordinate, can by specify reference position, end position and jump step-length realize to one continuously or the set of zone of dispersion cell quote.Such as the statistics of the cell data of a zone of dispersion can being sued for peace.The form that quote in the zone is quoted for “ $C{＜start element lattice 〉:＜end unit lattice are quoted〉＜the step-length setting 〉;＜start element lattice are quoted 〉:＜end unit lattice are quoted〉＜the step-length setting 〉; ".
Quoting of data set mainly provides filtercondition setting and skew setting.Filtercondition can be any logical expression, is equivalent to the where clause of SQL statement, and can quote the data of other cell and data set, skew be provided with the cell coordinate describe similar, also exceptionally absolute drift and relativity shift.Absolute drift is meant the skew of relative data set article one record, and relativity shift is meant the skew of relative current data set record.The form that data set is quoted for "＜data set name 〉.＜field name 〉.＜skew is provided with 〉,＜filtercondition ".Skew setting is defaulted as sky under the default situations, and filtercondition is defaulted as sky, represents all records of this field.Such as in the grouping form, to the expression formula of grouping summation statistics be " sum (and＜data set name 〉.＜field name, the quoting of＜grouping field=current group value cell lattice〉}) ".At last issue than in calculating, to the REFER expression of last data be "＜data set name 〉.＜field name 〉.＜relativity shift coordinate is-1 〉,＜filtercondition ".
In the step 5, during the subreport expansion, each data set is quoted and is all formed an extended field in the extended area, and the filtercondition of all extended fields will be carried out the logical and operation, and then form last result set.Carry out next step extension process then according to the concrete extended model of subreport.In one extension, at first extended area is replicated, and fills static cell lattice, extended field cell then successively.The extended field cell will recomputate according to the current data set data and the formula that embodies.
The expansion that is provided with a plurality of subreports of same data association must unify to handle.When handling the subreport that is provided with data association, obtain to set up all related subreports with this subreport, data set with each subreport carries out association process then, obtain unified result set, adjust according to grouping, the ordering setting of related subreport then, one by one result set is filled into the corresponding region of different subreports at last respectively.The sign of after finishing corresponding subreport being finished expansion is changed to very, no longer it is carried out extension process in expansion backward.
The subreport that is provided with alignment properties will write down the most following/right margin of correlator form, after relevant sublist is all finished expansion, will carry out high wide alignment adjustment according to the boundary value of maximum.Filling is finished with the filling mode of appointment in " vacuum " zone that expands.
The advantage of this invention is:
1. sublist association reduces data and prepares difficulty
In traditional report tool, run into the different pieces of information collection and need carry out related situation about calculating, need write data preparation routine or storing process on the backstage, so that two data are gathered also.If very under the complicated situation, this merging will take time and effort very much, and be difficult to later on safeguard for the SQL of original individual data collection or storing process.In case two data sets are different data sources, so this merging will be carried out the unloading of a number formulary certificate, thereby bring a series of stationary problem.After using this method, the developer need not carry out data preliminary work again, can directly finish by the data association setting.Obtain by SQL statement such as the A data set, comprise the financial data of company, the B data set obtains by storing process, comprises the occurrences in human life data of company.After the application data set association, can be major key with the company, easily finish the comparative analysis of Corporate Finance, occurrences in human life data.
2. sublist alignment, Report layouts does not destroy because of expansion
In traditional report tool, be to guarantee Report layouts's neat appearance, technician's energy that may need to cost a lot of money is adjusted form.But because the uncertainty of form growth data causes the expansion white space often occurring, though can simply handle, effect all is unsatisfied with.After using sublist layout alignment schemes, the subreport of local expansion can be consistent with the form integral layout, and can select the filling mode of white space, and the layout of having avoided causing because of expansion is destroyed.
3. data referencing is easy, and the form computing realizes simple
Because the arbitrariness of form operational data, and the shortage of reference data ability, cause the very simple account form of a lot of service logics in actual form exploitation, to be difficult to realize, finally these clearing tasks can only be thrown background program, reduce the value of report tool, increased technician's workload.After using this method, the reference data ability strengthens, and no matter is cell reference, and still data set is quoted, and the dynamic data extracting that expansion can both be formed be come, and carries out the filtration treatment of custom condition, and it is simple that the form computing becomes.Such as common segmentation statistics, grouping subtotal, the same period than, last than, add up etc. and can both realize one by one by data referencing.
Description of drawings
Fig. 1 is the process flow diagram of the generation method of a kind of irregular complex report forms of the present invention;
Fig. 2 is the synoptic diagram of embodiment of the invention neutron report data association;
Fig. 3 causes the synoptic diagram of vacuum area for expansion in the embodiment of the invention;
Fig. 4 is the synoptic diagram of subreport alignment in the embodiment of the invention.
Embodiment
To be elaborated to embodiments of the present invention below.
Fig. 1 is the process flow diagram of the generation method of a kind of irregular complex report forms of the embodiment of the invention.This flow process starts from step 101 and selects the affiliated model of form, sets up the report data collection.In this step, the form model is abstract in advance good, and the user can directly select, and also can change in the Report Form Design stage.Data set can be a plurality of, and can comprise database, Java object, text (other file that comprises csv file and self-defined decollator), XML file (the XML structure is unrestricted) from different data sources.
The field of data set is except that from data source directly obtains, and can calculate by other fields and obtain (being called calculated field), and generate automatically and obtain (be called and append field, generate such as sequence number, and the field splicing etc.).
Enter step 102 then, in the step 102, set up at least one subreport according to local rule in a form, each subreport belongs to a certain form model.The data set that step 101 is set up is tied in the subreport then.So-called binding is exactly that field with data set is set in the extended area under the subreport, and extended area is made up of the sequential cells lattice in the subreport, and the extended attribute of extended area is set simultaneously.Comprise propagation direction, expansion number of times.Can be provided with downwards or expansion to the right, and minimum expansion number of times, largest extension number of times.
In the step 103, the business association relation according to data between subreport is provided with two data external key associations between subreport.This association is divided into outside interior connection (only showing the associated match data), the left side and connects (complete demonstration left-handed watch data, the right non-matched data of showing replace with sky or designated symbols), the right side is outer connects (complete demonstration right side table data, left-handed watch non-matched data are with sky or designated symbols replacement), 4 kinds of modes of complete outer connection (complete demonstration left-handed watch, the right data of showing, non-matched data replaces with sky or designated symbols).Set up related between subreport by link field.Subreport can to set up external key related with a plurality of subreports, and link field needn't force to be tied to extended area.
The inside and outside connection of the similar SQL of coupling of subreport data association.After the data association attribute was set, the matched record in the extended area of these two subreports starting point of extended area relatively separately produced identical offset.As shown in Figure 2, set up association from the data of 2 result sets by associate field after, can form on delegation and show.
Behind the subreport data association, field ordering, the grouping that can be provided with based on whole connection result set are provided with.Ordering in each subreport, grouping are provided with not revival.
For guaranteeing the integrality of form integral layout, the subreport alignment properties can be set.This attribute can guarantee the subreport data set after padding data forms actual form, still can keep the alignment relation of setting each other, avoids occurring form " vacuum " zone that causes because of expansion.Be positioned at two subreports such as reference position, expanded 6 row for one, expanded 12 row for one with delegation.If there is not the sublist alignment properties, expansion " vacuum " zone of 6 row will appear below the subreport of having expanded 6 row, and the integral layout of form will be destroyed without any setting in this part zone, and its effect is as shown in Figure 3.
The subreport alignment comprises: highly alignment, 2 kinds of modes of width alignment.The subreport that the sublist reference position is positioned on the different lines can be provided with the height alignment properties, and the subreport on the different rows can be provided with the width alignment properties.Same subreport can be provided with highly alignment, width alignment properties respectively with two different subreports simultaneously.
After subreport was provided with highly alignment, the lower boundary that actual padding data is finished latter two subreport of expansion was positioned at in the delegation, and for the width alignment similarly, after actual padding data was finished expansion, the right margin of expansion back subreport was positioned at same listing.
Sublist alignment subreport can be provided with the filling mode in expansion " vacuum " zone, comprising: the extended area cell is filled, footline/row merge, the merging of initial lattice, etc. 4 kinds of modes of branch/row merging.It is exactly to fill new expansion " vacuum " zone of expanding with the cell form of subreport extended area that the extended area cell is filled, until aliging with another subreport.It then is that the row/row of expansion at last develop into that Merge Cells and then downward/right side merges processing that footline/row merges.Initial lattice merge merges into a big Merge Cells with all expansions " vacuum " zone exactly.Deng the merging of branch/row is that new region is divided into several sections, merges respectively then.As shown in Figure 4, after the expansion downwards of on the left side subreport, for keeping whole Report layouts integrality, the right subreport needs and left side subreport keeps highly alignment, and adopts footline to merge filling mode.
In the step 104, mainly carry out filling in of form expression formula.The compute mode that exists in the form, operational method are generally fairly simple, common mathematical operation, logical operation and statistical method can satisfy most of demand, but the data of participation computing are more complicated often, and therefore providing flexibly, the data referencing mode is the key that solves a report data computing difficult problem.In this invention, the form expression formula is removed outside conventional operation mode, the operational methods such as arithmetic, logical expression, built-in function, and emphasis is to have increased quoting cell data, number of data sets certificate.
Specifically, the coordinate of cell data referencing is described 2 kinds of methods: absolute coordinates is quoted, relative coordinate.
Absolute coordinates precedents data are meant by the designating unit lattice quotes certain cell data of form expansion back at the coordinate of design point.Though the actual coordinate of certain cell of expansion back may become, and quotes still by absolute coordinates and can have access to it.The form that absolute coordinates is quoted is “ $C{#＜row coordinate 〉, #＜row-coordinate〉"
Relative coordinate precedents data are meant the data of quoting certain cell of expansion back by the relative ranks off-set value of designating unit.Though a cell expansion still can be quoted respectively it by relative coordinate for a row/row cell like this.The form that absolute coordinates is quoted is “ $C{＜line skew 〉,＜line displacement〉"
No matter be absolute coordinates or relative coordinate, can by specify reference position, end position and jump step-length realize to one continuously or the set of zone of dispersion cell quote.Such as the statistics of the cell data of a zone of dispersion can being sued for peace.The form that quote in the zone is quoted for “ $C{＜start element lattice 〉:＜end unit lattice are quoted〉＜the step-length setting 〉;＜start element lattice are quoted 〉:＜end unit lattice are quoted〉＜the step-length setting 〉; ".
Quoting of data set mainly provides filtercondition setting and skew setting.Filtercondition can be any logical expression, is equivalent to the where clause of SQL statement, and can quote the data of other cell and data set, skew be provided with the cell coordinate describe similar, also exceptionally absolute drift and relativity shift.Absolute drift is meant the skew of relative data set article one record, and relativity shift is meant the skew of relative current data set record.The form that data set is quoted for "＜data set name 〉.＜field name 〉.＜skew is provided with 〉,＜filtercondition ".Skew setting is defaulted as sky under the default situations, and filtercondition is defaulted as sky, represents all records of this field.Such as in the grouping form, to the expression formula of grouping summation statistics be " sum (and＜data set name 〉.＜field name, the quoting of＜grouping field=current group value cell lattice〉}) ".At last issue than in calculating, to the REFER expression of last data be "＜data set name 〉.＜field name 〉.＜relativity shift coordinate is-1 〉,＜filtercondition ".
In the step 105, during the subreport expansion, each data set is quoted and is all formed an extended field in the extended area, and the filtercondition of all extended fields will be carried out the logical and operation, and then form last result set.Carry out next step extension process then according to the concrete extended model of subreport.In one extension, at first extended area is replicated, and fills static cell lattice, extended field cell then successively.The extended field cell will recomputate according to the current data set data and the formula that embodies.
The expansion that is provided with a plurality of subreports of same data association must unify to handle.When handling the subreport that is provided with data association, obtain to set up all related subreports with this subreport, data set with each subreport carries out association process then, obtain unified result set, adjust according to grouping, the ordering setting of related subreport then, one by one result set is filled into the corresponding region of different subreports at last respectively.The sign of after finishing corresponding subreport being finished expansion is changed to very, no longer it is carried out extension process in expansion backward.
The subreport that is provided with alignment properties will write down the most following/right margin of correlator form, after relevant sublist is all finished expansion, will carry out high wide alignment adjustment according to the boundary value of maximum.Filling is finished with the filling mode of appointment in " vacuum " zone that expands.
Claims (8)
1. the generation method of an irregular complex report forms is characterized in that may further comprise the steps:
(1) selects the affiliated model of form, set up the report data collection;
(2) according to the form local rule, set up a plurality of subreports, the corresponding data collection is tied in the subreport;
(3) subreport data association, layout alignment properties are set;
(4) write the data computation expression formula to cell;
(5) the operation report form template obtains actual form.
2. the generation method of irregular complex report forms according to claim 1 is characterized in that: the acquisition mode of data obtains for directly obtaining from data source or calculating to obtain or generate automatically by field in the described step (1).
3. the generation method of irregular complex report forms according to claim 1, it is characterized in that: binding is exactly that field with data set is set in the extended area under the subreport in the described step (2), extended area is made up of the sequential cells lattice in the subreport, the extended attribute of extended area is set simultaneously, comprises propagation direction and expansion number of times.
4. the generation method of irregular complex report forms according to claim 1 is characterized in that: interrelational form comprises that interior connection, a left side connect, rightly connect, complete outer the connection outward outward in the step (3).
5. the generation method of irregular complex report forms according to claim 4, it is characterized in that: after the data association attribute was set, the matched record in the extended area of two subreports starting point of extended area relatively separately produced identical offset in the step (3).
6. the generation method of irregular complex report forms according to claim 1, it is characterized in that: described step (3) neutron Report layouts alignment thereof comprises: highly alignment and width alignment, wherein the sublist reference position is positioned at subreport on the different lines height alignment properties can be set, subreport on the different rows can be provided with the width alignment properties, and same subreport can be provided with highly alignment, width alignment properties respectively with two different subreports simultaneously.
7. according to the generation method of claim 1 or 4 described irregular complex report forms, it is characterized in that: be connected in described and only show the associated match data; Be connected to complete demonstration left side mark data, right table non-matched data outside the described left side with sky or designated symbols replacement; Be connected to the right table of complete demonstration data, left-handed watch non-matched data outside the described right side with sky or designated symbols replacement; Described complete outer complete demonstration left-handed watch, the right table data of being connected to, non-matched data replaces with sky or designated symbols.
8. the generation method of irregular complex report forms according to claim 1, it is characterized in that: write the data computation expression formula in the step (4) and need carry out the cell data referencing and data set is quoted to cell, the coordinate of described cell is described two kinds of methods: absolute coordinates is quoted with relative coordinate and is quoted; Wherein,
Absolute coordinates precedents data are meant by the designating unit lattice quotes certain cell data of form expansion back at the coordinate of design point, and its form is “ $C{#＜row coordinate 〉, #＜row-coordinate〉";
Relative coordinate precedents data are meant the data of quoting certain cell of expansion back by the relative ranks off-set value of designating unit, and its form is “ $C{＜line skew 〉,＜line displacement〉";
Data set is quoted and is provided the filtercondition setting and skew is provided with, its form be "＜data set name 〉.＜field name 〉.＜skew setting 〉,＜filtercondition ".
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2008100141822A CN101246471A (en) | 2008-02-26 | 2008-02-26 | Irregular complex report forms creating method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CNA2008100141822A CN101246471A (en) | 2008-02-26 | 2008-02-26 | Irregular complex report forms creating method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101246471A true CN101246471A (en) | 2008-08-20 |
Family
ID=39946931
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CNA2008100141822A Pending CN101246471A (en) | 2008-02-26 | 2008-02-26 | Irregular complex report forms creating method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101246471A (en) |
Cited By (11)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101833583A (en) * | 2010-05-18 | 2010-09-15 | 中兴通讯股份有限公司 | Method, device and system for generating report form based on database |
| CN101615188B (en) * | 2009-07-22 | 2011-04-06 | 山东中创软件工程股份有限公司 | Method and device for importing multi-source data into data template |
| CN102789486A (en) * | 2012-06-28 | 2012-11-21 | 用友软件股份有限公司 | Formula manipulation device and formula manipulation method for data analysis system |
| CN102870108A (en) * | 2010-03-26 | 2013-01-09 | Emd微孔公司 | Method of generating electronic report |
| CN102929853A (en) * | 2011-12-28 | 2013-02-13 | 上海西门子工业自动化有限公司 | DCS (Data Communication System) project data generating system and method based on Excel sheet association |
| CN104503715A (en) * | 2014-12-26 | 2015-04-08 | 北京首钢自动化信息技术有限公司 | Dynamic warranty book management system of iron and steel industry |
| CN106155674A (en) * | 2015-04-22 | 2016-11-23 | 阿里巴巴集团控股有限公司 | The method and device that report page represents |
| CN108415994A (en) * | 2018-02-13 | 2018-08-17 | 北京天元创新科技有限公司 | A kind of Network Management System report form generation method, device and equipment |
| CN109543169A (en) * | 2018-11-26 | 2019-03-29 | 成都四方伟业软件股份有限公司 | Report processing method and device |
| CN110347758A (en) * | 2019-07-17 | 2019-10-18 | 中铁二局集团勘测设计院有限责任公司 | A kind of generation method of Chinese style report |
| CN112036139A (en) * | 2020-09-01 | 2020-12-04 | 中国银行股份有限公司 | Report generation method and device |
-
2008
- 2008-02-26 CN CNA2008100141822A patent/CN101246471A/en active Pending
Cited By (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101615188B (en) * | 2009-07-22 | 2011-04-06 | 山东中创软件工程股份有限公司 | Method and device for importing multi-source data into data template |
| CN102870108A (en) * | 2010-03-26 | 2013-01-09 | Emd微孔公司 | Method of generating electronic report |
| CN101833583A (en) * | 2010-05-18 | 2010-09-15 | 中兴通讯股份有限公司 | Method, device and system for generating report form based on database |
| CN102929853B (en) * | 2011-12-28 | 2016-02-17 | 西门子工厂自动化工程有限公司 | Based on DCS project data generation system and the method for the association of Excel list |
| CN102929853A (en) * | 2011-12-28 | 2013-02-13 | 上海西门子工业自动化有限公司 | DCS (Data Communication System) project data generating system and method based on Excel sheet association |
| CN102789486A (en) * | 2012-06-28 | 2012-11-21 | 用友软件股份有限公司 | Formula manipulation device and formula manipulation method for data analysis system |
| CN104503715A (en) * | 2014-12-26 | 2015-04-08 | 北京首钢自动化信息技术有限公司 | Dynamic warranty book management system of iron and steel industry |
| CN106155674A (en) * | 2015-04-22 | 2016-11-23 | 阿里巴巴集团控股有限公司 | The method and device that report page represents |
| CN106155674B (en) * | 2015-04-22 | 2020-04-07 | 阿里巴巴集团控股有限公司 | Method and device for displaying report page |
| CN108415994A (en) * | 2018-02-13 | 2018-08-17 | 北京天元创新科技有限公司 | A kind of Network Management System report form generation method, device and equipment |
| CN108415994B (en) * | 2018-02-13 | 2021-03-02 | 北京天元创新科技有限公司 | Network management system report generation method, device and equipment |
| CN109543169A (en) * | 2018-11-26 | 2019-03-29 | 成都四方伟业软件股份有限公司 | Report processing method and device |
| CN109543169B (en) * | 2018-11-26 | 2023-06-13 | 成都四方伟业软件股份有限公司 | Report processing method and device |
| CN110347758A (en) * | 2019-07-17 | 2019-10-18 | 中铁二局集团勘测设计院有限责任公司 | A kind of generation method of Chinese style report |
| CN112036139A (en) * | 2020-09-01 | 2020-12-04 | 中国银行股份有限公司 | Report generation method and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101246471A (en) | Irregular complex report forms creating method | |
| Molli et al. | Tombstone transformation functions for ensuring consistency in collaborative editing systems | |
| Paim et al. | DWARF: An approach for requirements definition and management of data warehouse systems | |
| CN108037916B (en) | Web-based graphical service modeling method | |
| Bloom et al. | Transformational design and implementation of a new efficient solution to the ready simulation problem | |
| CN109669949A (en) | A kind of dynamic report generation method and system realization based on data model | |
| US20070106637A1 (en) | Method for Controlling a Relational Database System | |
| CN107273117A (en) | A kind of quick Code automatic build system for programming friendly | |
| CN105447253B (en) | Integration method of three-dimensional process data | |
| CN107291450A (en) | A kind of quick code automatic generation method for programming friendly | |
| CN101617292A (en) | Programming and execution towards producer graph | |
| CN102508850A (en) | Form data processing device and form data processing method | |
| JPWO2015025386A1 (en) | Data processing system, data processing method, and data processing apparatus | |
| CN111078094B (en) | Distributed machine learning visualization device | |
| US9805112B2 (en) | Method and structure for managing multiple electronic forms and their records using a static database | |
| CN103488537A (en) | Method and device for executing data ETL (Extraction, Transformation and Loading) | |
| Simitsis | Modeling and managing ETL processes. | |
| Bruni et al. | Orchestrating transactions in join calculus | |
| CN111984176A (en) | Software online development platform and development method | |
| CN110162297A (en) | A kind of source code fragment natural language description automatic generation method and system | |
| CN113168413A (en) | Correlated incremental loading of multiple data sets for interactive data preparation applications | |
| CN112652371A (en) | A nursing document designer and generate device for wisdom medical field | |
| CN102023859A (en) | Digital development environment-oriented software integration method with reliability, maintainability and supportability | |
| Marakkalage et al. | Optimizing adiabatic quantum-flux-parametron (AQFP) circuits using an exact database | |
| CN110347758A (en) | A kind of generation method of Chinese style report |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Open date: 20080820 |