CN101281462B - Report forms generating system and method - Google Patents
Report forms generating system and method Download PDFInfo
- Publication number
- CN101281462B CN101281462B CN2007100958364A CN200710095836A CN101281462B CN 101281462 B CN101281462 B CN 101281462B CN 2007100958364 A CN2007100958364 A CN 2007100958364A CN 200710095836 A CN200710095836 A CN 200710095836A CN 101281462 B CN101281462 B CN 101281462B
- Authority
- CN
- China
- Prior art keywords
- file
- data
- order
- report
- cover
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Active
Links
Images
Landscapes
- General Factory Administration (AREA)
Abstract
The invention provides a generating system and a generating method for a report which comprises tables and data filled into the table. The report generating method comprises: receiving variable data to generate a relevant file, receiving variable data and tables provided by a report format template file to generate a nested table file as a visual interface for an operator to correct variable data and then the relevant file, and generating a report file using data in the relevant file, the nested table file and an external database, which is used for presenting the report. According to the invention, an operator can flexibly modify the table format of a report and quickly adapt to the report, and the report is convenient to operate.
Description
Technical field
The invention relates to that a kind of form produces system and form production method, particularly can handle cover table and associated with respectively relevant for a kind of, so that data are inserted in the form, the form that produces form produces system and form production method by cover table and associated with.
Background technology
The fundamental purpose of form is with not intelligible data, utilizes systematized arrangement, according to different demands, understands the mode that goes up the best for the people and presents.General commercially available common form software, function is all comparatively simple and easy and lack the elasticity of revising, and as statistical report form, financial statement, product report from a liner table, even form all has been fixed, and may not be certain to be applicable to each user.If modification form, even to spend many times and energy to do the back braking and do, user for general fixed-purpose perhaps influences not quite, but when the multiple Protean product of a large amount of productions of manufacturing industry, sample, this post-production work but becomes white elephant.
Common on the market form has following characteristic and shortcoming at present:
Set form: just by software vendor output format is write in the program, the user can only do selection in existing form, does not have the chance of revising.
The form external member: at present common have a Crystal Report, its telotism, but cost an arm and a leg, and the user of new contact need spend long time study.
Can edit statement form: can be according to customer demand, edit the form that desire produces, can bring into play the function of aforementioned post-production, can repair programming to produce form according to the required form of client, but along with customer demand continuously, relatively also cause program research staff's burden.
Export the application program Word of Microsoft (Microsoft) to: Microsoft is very big in the market share in market, and the characteristic that it is easy to learn allows the easy left-hand seat of general user.It has a lot of parameters to adjust, and also allows the power user can enjoy more function.Therefore export Word to, the relative proper motion developer is easier to reach customer demand, also more convenient to user's post-production, but it is too powerful really that shortcoming is the Word function, if parameter all will realize, the engineering of its post-production also is no small burden, has also increased operator's study and the difficulty of using simultaneously.
Summary of the invention
Fundamental purpose of the present invention is to provide a kind of and produces system and form production method in order to the form that produces form, handle cover table, associated with respectively and insert data in the cover table, can make things convenient for the user to operate, make operator's fast adaptation, the form of again can elasticity revising form is to address the above problem.
The invention relates to a kind ofly to produce system and form production method that in order to producing a form, described form comprises a form and inserts data in the described form in order to the form that produces form.
Described form generation system comprises: a template file module, have a statement form template file, and this statement form template file is in order to provide described form; One associated with generator, this associated with generator receive a variable data to produce an associated with, and described associated with is in order to represent the relativeness of described data in described form; One cover list file generator, this cover list file generator receive described variable data and described form overlaps list file to produce one, and this cover list file is in order to present described cover table, and this cover table presents the relativeness of described data in described form; And a report program generator (RPG), this report program generator (RPG) is in conjunction with the data in the database, described cover list file and described associated with, and to produce a report file, this report file is in order to present described form.
Described form production method comprises: a default statement form template file, and this statement form template file is in order to provide described form; Receive a variable data to produce an associated with, this associated with is in order to represent the relativeness of described data in described form; Receive described variable data and described form to produce a cover list file, this cover list file is in order to present described cover table, and this cover table presents the relativeness of described data in described form; And in conjunction with the data in the database, described cover list file and described associated with, to produce a report file, this report file is in order to present described form.
Form of the present invention produces system and the form production method operates by a computer installation.At first receive a variable data to produce an associated with, wherein said associated with is in order to the expression relativeness of data in form, described relativeness comprise Data Position, data length, data font color, with related settings such as database corresponding relation, form extension mode.In addition, receive variable data and form to produce a cover list file, this cover list file is in order to present the cover table, and this cover table is to present the relativeness of data in above table.At last, in conjunction with the data in the database, associated with and cover list file, to produce a report file, this report file is in order to present final required form.
Computer installation further comprises a display device, and described cover list file is in order to presenting the cover table, and described report file is in order to presenting form, all by above-mentioned display device to present.
Wherein, statement form template file, cover list file and report file are the editing files that meets for the application program Word of Microsoft (Microsoft).
Therefore, produce system and form production method by the present invention in order to the form that produces form, form at the required form of operator, produce the cover list file earlier to present the cover table that is applicable to the operator, again the data in the database are combined and produce report file with cover table, associated with, to present the final needed form of operator.So, can allow the operator more can elasticity revise the table format of form, and can reach the advantage that operator's fast adaptation and handled easily person are manipulated again by handling the data in cover table, associated with and the external data base respectively.
Description of drawings
Fig. 1 produces the related synoptic diagram of system and computer installation for form of the present invention;
Fig. 2 produces system in conjunction with the related synoptic diagram that produces report file for form of the present invention;
Fig. 3 is the synoptic diagram of cover table of the present invention;
Fig. 4 is the synoptic diagram of form of the present invention;
Fig. 5 is the process flow diagram of the form production method of a preferred embodiment of the present invention.
The main element symbol description:
Form produces system's 40 template file modules 42
Associated with generator 4402 cover list file generators 4404
Report program generator (RPG) 46 forms 5002
Statement form template file 50 variable data 52
Associated with 54 cover list files 60
Cover table 62 database 70
Embodiment
See also Fig. 1 and Fig. 2, Fig. 1 produces the related synoptic diagram of system 40 and computer installation 30 for form of the present invention.Fig. 2 produces system 40 in conjunction with the related synoptic diagram that produces report file 80 for form of the present invention.The invention relates to a kind of in order to produce the form generation system 40 of a form 82, as shown in Figure 1, form generation system 40 further comprises a template file module 42, an associated with generator 4402, a cover list file generator 4404 and a report program generator (RPG) 46.Form produces system 40 by a computer installation 30, to order about template file module 42, associated with generator 4402, cover list file generator 4404 and report program generator (RPG) 46 runnings in the form generation system 40.Computer installation 30 also comprises a display device 32, in order to show cover table and form.
Described form 82 comprises a form 5002 and inserts data 72 in the form 5002.And template file module 42 has a statement form template file 50, and 50 of statement form template files are in order to providing form 5002, even can provide the template of many forms 5002 to select for the operator.
Cooperate Fig. 2 further to consult Fig. 3, Fig. 3 overlaps the synoptic diagram of table 62 for the present invention.Wherein, associated with generator 4402 receives a variable data 52 to produce an associated with 54, and associated with 54 is in order to the relativeness of expression data in form 5002, and described relativeness comprises Data Position, i.e. the position of data in form; Data length, the i.e. length of data in form; The data font color, but promptly data by properties in form dynamically determines font color; With the database corresponding relation, the position that promptly in database, stores; Form extends mode, promptly when representing more than one of data, and bearing of trend and form etc.
Then, cover list file generator 4404 also receives variable data 52, and the form 5002 that is provided according to statement form template file 50 is to produce a cover list file 60, cover list file 60 demonstrates cover table 62 in order to present in display device 32, purpose is to provide the visual interface of controlling as the operator, so that revise variable data 52 and then revise associated with 54.Cover table 62 item as shown in Figure 3, the left side is a variable data 52, the grid on the right is form 5002, so whole cover table 62 is that relativeness presents data (be " ### " symbol place of filling up in the form 5002 future) in form 5002.
Supplementary notes be, the form 5002 on Fig. 3 the right is not only the grid of solid line, the top comprises the scope of " ### " image, all belongs to form 5002.In addition, the relativeness of the cover shown data of table 62 in form 5002 is for the visual purpose that is operating as of operator, and, for avoiding the meaningless burden of computer installation 30, so that this relativeness presented was comparatively limited, not as associated with 54 so complete.
Cooperate Fig. 2 further to consult Fig. 4 again, Fig. 4 is the synoptic diagram of form 82 of the present invention.To produce a report file 80, report file 80 also demonstrates the final required form 82 of user in order to present to report program generator (RPG) 46 in display device 32 in conjunction with the data 72 in the database 70, associated with 54 and cover list file 60.As shown in Figure 4, promptly show form 5002 (contain top no grid place) and insert data 72 in the form 5002.
Wherein, statement form template file 50, cover list file 60 and report file 80 all meet the editing files for the application program Word of Microsoft (Microsoft), so, the convenient Microsoft's resource that Windows provides of using, can more convenient operator be accustomed to using and quick left-hand seat, reach quick the destination of study.
Supplementary notes is again, because the present invention cooperates the edit file of the Word of Microsoft, powerful complexity, so complete " relativeness " is to be controlled by associated with 54, the purpose of cover list file 60 and cover table 62 only is to provide that the operator is visual controls, contained " relativeness " is comparatively limited, so report program generator (RPG) 46 need be quoted associated with 54 again, could produce complete report file 80.
Further specify, form of the present invention produces system 40 and reaches optimized purpose in conjunction with Microsoft Word bookmark and function variable, use bookmark, program can be very fast the arrival anchor point, do follow-up output and handle, and the function variable is the index of program associated with, also tentatively possible result is exported in preview, and uses the rouleau mark to understand the concise and to the point data of variable.
Embodiment as shown in Figure 3, the left side is the form 5002 of Word file for all variable data that can be inserted into 52, the right, is anchor point with the bookmark, with the shared length of character string of function variable simulation final data, so that it is wide etc. to adjust the hurdle of form 5002.
What remark additionally is that computer installation 30 cooperates internal processors, internal memory, interlock circuit and related software etc., works in coordination with and carries out the function that described form produces system 40.
See also Fig. 5, Fig. 5 is the process flow diagram of a preferred embodiment of the present invention form 82 production methods.The present invention also is that aforementioned form produces form 82 production methods that system 40 is carried out, and also is to operate by computer installation 30, in order to produce a form 82.Form 82 comprises a form 5002 and inserts data 72 in the form 5002, and the production method of form 82 comprises the following step:
Step S02: receive a variable data 52 to produce an associated with 54, associated with 54 is in order to the relativeness of expression data 72 in form 5002;
Step S04: to produce a cover list file 60, cover list file 60 is in order to present cover table 62 according to variable data 52 and the form 5002 that stores up statement form template file 50 in advance;
Step S06: in conjunction with the data in the external data base 70 72, associated with 54 and cover list file 60, to produce a report file 80, report file 80 is in order to present form 82.
Wherein, described cover list file 60 is in order to presenting cover table 62, and described report file 80 is in order to presenting form 82, all is that display device 32 by computer installation 30 is to present.And statement form template file 50, cover list file 60 and report file 80 are the editing files that meet for the application program Word of Microsoft (Microsoft).
Therefore, produce system 40 and form 82 production methods by the present invention in order to the form that produces form 82, form at the required form of operator, produce cover list file 60 earlier to present the cover table 62 that is applicable to the operator, by associated with 54 data in the database 70 72 are combined with cover table 62 again and produce report file 80, to present the final needed form 82 of operator.So by handling cover table 62, associated with 54 respectively and inserting data 72 in the cover table 62, can allow the operator more can elasticity revise or select form 5002 forms of form 82, and can reach the advantage that operator's fast adaptation and handled easily person are manipulated again, can effectively help the user to save the time of a lot of making forms 82.
By the above detailed description of preferred embodiments, hope can be known description feature of the present invention and spirit more, and is not to come category of the present invention is limited with the above-mentioned preferred embodiment that is disclosed.On the contrary, its objective is that hope can contain various changes and have in the category of claim of being arranged in of equality institute of the present invention desire application.
Claims (9)
1. a form produces system, and in order to producing a form, described form comprises a form and inserts data in the described form, it is characterized in that this form produces system and further comprises:
One template file module has a statement form template file, and this statement form template file is in order to provide described form;
One associated with generator, this associated with generator receive a variable data to produce an associated with, and described associated with is in order to represent the relativeness of described data in described form;
One cover list file generator, this cover list file generator receive described variable data and described form overlaps list file to produce one, and this cover list file is in order to present the cover table, and this cover table presents the relativeness of described data in described form; And
One report program generator (RPG), this report program generator (RPG) are in conjunction with the data in the database, described cover list file and described associated with, and to produce a report file, this report file is in order to present described form.
2. form according to claim 1 produces system, it is characterized in that, described form produces system further by a computer installation, to order about described template file module, described associated with generator, described cover list file generator and the running of described report program generator (RPG).
3. form according to claim 2 produces system, it is characterized in that described computer installation also comprises a display device, described cover list file is in order to present described cover table, described report file is in order to present described form, all by described display device to present.
4. form according to claim 1 produces system, it is characterized in that described statement form template file, described cover list file and described report file are the editing files that meets the application program Word of Microsoft.
5. form according to claim 1 produces system, it is characterized in that, the relativeness of described data in described form is selected from by a Data Position, a data length, a data font color, one and formed relativeness in the group with database corresponding relation, the form mode of extending.
6. form production method, in order to producing a form, described form comprises a form and inserts data in the described form, it is characterized in that this form production method comprises the following step:
A default statement form template file, this statement form template file is in order to provide described form;
Receive a variable data to produce an associated with, this associated with is in order to represent the relativeness of described data in described form;
Receive described variable data and described form to produce a cover list file, this cover list file is in order to present the cover table, and this cover table presents the relativeness of described data in described form; And
In conjunction with the data in the database, described cover list file and described associated with, to produce a report file, this report file is in order to present described form.
7. form production method according to claim 6, it is characterized in that, described form production method operates by a computer installation, described computer installation also comprises a display device, described cover list file is in order to present described cover table, described report file is in order to present described form, all by described display device to present.
8. form production method according to claim 6 is characterized in that, described statement form template file, described cover list file and described report file are the editing files that meets the application program Word of Microsoft.
9. form production method according to claim 6, it is characterized in that, the relativeness of described data in described form is selected from by a Data Position, a data length, a data font color, one and formed relativeness in the group with database corresponding relation, the form mode of extending.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2007100958364A CN101281462B (en) | 2007-04-05 | 2007-04-05 | Report forms generating system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2007100958364A CN101281462B (en) | 2007-04-05 | 2007-04-05 | Report forms generating system and method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN101281462A CN101281462A (en) | 2008-10-08 |
| CN101281462B true CN101281462B (en) | 2011-09-21 |
Family
ID=40013949
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2007100958364A Active CN101281462B (en) | 2007-04-05 | 2007-04-05 | Report forms generating system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101281462B (en) |
Families Citing this family (5)
| 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 |
| CN102331983A (en) * | 2010-07-15 | 2012-01-25 | 鸿富锦精密工业（深圳）有限公司 | Test report generation system and method |
| CN102509250A (en) * | 2011-11-03 | 2012-06-20 | 上海大学 | Automatic generation method for medical report |
| CN102819564A (en) * | 2012-07-05 | 2012-12-12 | 无锡中科泛在信息技术研发中心有限公司 | Method for generating report forms by limited table element combination |
| CN106156075B (en) * | 2015-03-31 | 2019-08-02 | 中国科学院声学研究所 | A kind of method and device of report generation and displaying |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1438591A (en) * | 2002-02-10 | 2003-08-27 | 华为技术有限公司 | Method for realizing intelligent report forms |
| CN1841362A (en) * | 2005-03-31 | 2006-10-04 | 国际商业机器公司 | Method and system for processing an electronic form |
-
2007
- 2007-04-05 CN CN2007100958364A patent/CN101281462B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1438591A (en) * | 2002-02-10 | 2003-08-27 | 华为技术有限公司 | Method for realizing intelligent report forms |
| CN1841362A (en) * | 2005-03-31 | 2006-10-04 | 国际商业机器公司 | Method and system for processing an electronic form |
Also Published As
| Publication number | Publication date |
|---|---|
| CN101281462A (en) | 2008-10-08 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106371825B (en) | A kind of mobile terminal application interface list dynamic creation method and device | |
| CN104932889B (en) | Page visualized generation method and device | |
| CN101281462B (en) | Report forms generating system and method | |
| CN105786526A (en) | Web-based efficient flow chart drawing system and method | |
| CN113721901B (en) | Low-code financial data analysis visualization engine | |
| WO2009003389A1 (en) | Generation method and apparatus for report form condition input interface | |
| CN104239305A (en) | Electronic document generating and displaying method and apparatus | |
| CN101944027A (en) | User interface generation method | |
| CN107392998A (en) | A kind of process design method and system based on threedimensional model | |
| CN102609252A (en) | Intelligent configuration method for logic menu resources on basis of measurement instruments | |
| WO2019098107A1 (en) | Translation support device, translation support program, and method to support translation with information processing device | |
| CN105242931A (en) | Method and system for editing and generating codes for game interface | |
| JP5506176B2 (en) | Information processing apparatus and information processing method | |
| CN111158670A (en) | Visual auxiliary software development method and system | |
| CN111368516A (en) | Visualized large-screen intelligent editing system | |
| CN109213528A (en) | Web front end interface integrating method and web front end interface integrating device | |
| KR20180135654A (en) | Intuitive method of making a program | |
| CN117077650B (en) | Document generation system, method, equipment and medium based on dynamic template configuration | |
| CN107153563A (en) | A kind of software version generation method and device | |
| CN104156209B (en) | Cross-platform interface modeling method and device | |
| CN102346920A (en) | Two-dimensional animation database management system and two-dimensional animation database management method | |
| KR102417862B1 (en) | the method for making the program simple | |
| CN109582304A (en) | A kind of UI control generation method and device based on man-machine interactive system | |
| JP2019197084A (en) | Sign language cg interpretation and edit system, and program | |
| JP2008052356A (en) | Source code automatic generation device |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant |