CN104715030A - Method for printing bills and reports on preprinted form - Google Patents
Method for printing bills and reports on preprinted form Download PDFInfo
- Publication number
- CN104715030A CN104715030A CN201510107187.XA CN201510107187A CN104715030A CN 104715030 A CN104715030 A CN 104715030A CN 201510107187 A CN201510107187 A CN 201510107187A CN 104715030 A CN104715030 A CN 104715030A
- Authority
- CN
- China
- Prior art keywords
- original document
- document page
- cell
- page
- actual
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Landscapes
- Processing Or Creating Images (AREA)
Abstract
The invention discloses a method for printing bills and reports on a preprinted form. The method comprises the steps that firstly, original bills are scanned into images; secondly, an original bill page is newly established; thirdly, the original bill images are imported to the original bill page; fourthly, the original bill page is designed; fifthly, an actual bill page is designed; sixthly, a report template is saved; seventhly, the reports are browsed; eighthly, the reports are printed. By means of the method, a user can select whether the reports are printed on the preprinted form or on blank paper when browsing the reports, so the printing flexibility of the bills is improved; if the bills and reports are printed on the blank paper, there is no need to use the scanning images of the original bills as background images, and therefore the printing quality of the bills and the reports is guaranteed.
Description
Technical field
The present invention relates to a kind of document form cover printing method.
Background technology
Report Form Design is the pith in IT application in enterprises, and according to statistics, 60% work of enterprise's application and development is all make all kinds of form, and wherein, document form and bill occupy consequence wherein.The printing type of document form is divided into cover to beat and non-cover is beaten, and cover is beaten and referred on the document printed, and print What is printed to like clockwork the position of specifying; But not cover is beaten finger print the full content that document form comprises form on the document printer paper of blank.Traditional report tool, needs to measure out data with a yardstick and is overlapping the position beaten in background, and then according to the position of sizing data place cell on screen, quite loaded down with trivial details, easily make mistakes.When the scheme that main flow beaten by current document form cover is Report Form Design using the scintigram of original document as document form background, the position of print What is needed to put corresponding Database field at it again, on the document printed, the data obtained from database are only printed during printing, if wish use non-cover molding formula, then by the scintigram of original document as a setting figure be printed on document.
The report form tool of current domestic main flow, the process of its design document form is as follows: 1) original document is scanned into picture, and is saved in specified folder; 2) newly-built document form in Report Designer, and using document scintigram as paper background, specify when document prints whether print document scanning background figure; 3) form is designed; 4) form is preserved to template file; 5) user browses form and execution set is beaten in a browser.There is following defect:
1) document form cover is beaten is also that non-cover plays needs by Report Form Design personnel appointment when designing, and reports user cannot select when browsing form;
2) the non-cover of document form got through by the scintigram of original document as a setting figure be printed on document and realize, easily there is the problem that font is fuzzy.
Summary of the invention
A kind of document form cover printing method is the invention provides for solving the problem.
Technical scheme provided by the invention is: a kind of document form cover printing method, comprises the steps:
Step one): original document is scanned for picture: scan original document for original document picture, described original document picture is identical with original document size;
Step 2) the newly-built original document page: create the original document page, the described original document page is the blank page;
Step 3) import original document picture to the original document page: original document picture is imported the original document page as a setting, and the size of the adjustment original document page is to overlapping completely with original document picture;
Step 4) design the original document page: on the original document page, the table border identical with background and static text are set, make the original document page and original document completely the same;
Step 5) design actual document page: create the inchoate instrument page, i.e. actual document page, then the content outside Background in the original document page is all copied to actual document page, Database field and form function are placed into the correspondence position of actual document page;
Step 6) preserve report form template: the different content node query statement of the difference of the original document page, actual document page, actual document page and the original document page, original document picture and retrieve data being saved in report form template, then preserve report form template;
Step 7) browse form: in report server, the data needed with the retrieval of report data query statement, fill it in actual document page;
Step 8) report printing: select cover molding formula or non-cover molding formula, if select non-cover molding formula, directly print actual document page; If select cover to beat, then the data retrieved by report data query statement and function expression result of evaluation are filled into the correspondence position in the difference page of actual document page and the original document page, then print this difference page.
Further improvement, the described original document page and actual document page all comprise several rows and some row, described step 4) comprise following steps:
1) col width adjusting the original document page is high with row, makes each cell in original document picture, just in time comprises the one or more cells on the original document page;
2) Merge Cells, merge the cell on the original document page, make each cell in background, correspondence comprises a cell on the original document page, even in original document Background, certain cell of document form comprises the multiple cells on the original document page, then by this multiple cell span, the cell after merging is overlapped completely with the cell in Background;
3) form and cell borders are set: according to the frame of the form on original document picture and cell, for cell corresponding on the original document page arranges identical frame;
4) static text is added: on the original document page, add the position corresponding with the word of original document picture add identical original document page word; Font and the alignment thereof of described original document page word are consistent with the word of original document picture.
Further improvement, the described original document page and actual document page all comprise several rows and some row, described step 5) comprise following steps:
A. the second worksheet is created, i.e. actual document page;
B. search the original document page actual use region: search the last location lattice in the original document page, obtain its line number and row number, determine that actual document page needs line number and the columns in the region used according to line number and the row number of this element lattice;
C. adjustment row is high with col width: be set to corresponding identical with the original document page by the height of the row in the region of using in actual document page and the width of row;
D. Merge Cells is processed: in the search original document page, effectively use each cell in district, if this cell is Merge Cells, then find out the cell set that this Merge Cells comprises, and in actual document page, merging treatment is done in the cell set of correspondence;
E. Copied Cells frame: the search original document page effectively uses each cell in district, if there is frame, then corresponding unit lattice arrange identical frame in actual document page;
F. copy text: the search original document page effectively uses each cell in district, if there is text, then corresponding unit lattice arrange identical text in actual document page;
G. setting data storehouse field and form function: obtain the position that Database field or form function are placed into the correspondence of actual document page from data source.
Further improvement, the described original document page and actual document page all comprise several rows and some row, described step 6) in, described report form template saves as XML file, the original document page, actual document page, the difference of actual document page and the original document page saves as an Area Node in described XML file, each Area Node comprises several row nodes, described row node corresponds to the row in report form template, each row node comprises some cell nodes, described cell node corresponds to the cell in report form template, the attribute kit of each cell is containing width, frame, font, fill color and text etc., the attribute of described cell arranges decision by respective cells in report form template, the region child node of the original document page and actual document page is obtained by each cell searching for report form template, the difference of actual document page and the original document page is based on the region child node of actual document page, by each cell of actual document page, deduct all properties appeared in original document corresponding unit lattice points, namely obtain the region child node of the difference of actual document worksheet and original document worksheet, under described original document picture exists assigned catalogue, preserve original document picture file name in report form template, described data query statement is also kept in report form template with the form of a node.
Further improvement, in described step 8) in, form browser interface arranges check box and beats to indicate whether to overlap, or cover is set respectively on form browser interface makes button and button made by non-cover, or arrange respectively to overlap and play menu and menu played by non-cover.
Tool of the present invention has the following advantages:
1) document form cover is beaten is also that non-cover is beaten and can be selected when browsing form by reports user, adds the dirigibility that document prints;
2) the non-cover of document form is beaten without the need to using the scintigram of original document to scheme as a setting, ensure that the print quality of document form.
Accompanying drawing explanation
When considered in conjunction with the accompanying drawings, by referring to detailed description below, more completely can understand the present invention better and easily learn wherein many adjoint advantages, but accompanying drawing described herein is used to provide a further understanding of the present invention, form a part of the present invention, schematic description and description of the present invention, for explaining the present invention, does not form inappropriate limitation of the present invention, wherein:
Fig. 1 document form cover beats/and non-cover sets meter schematic flow sheet;
Original Bill design process schematic in Fig. 2 EXCEL reporting system;
The actual Bill design schematic flow sheet of Fig. 3;
Actual document process schematic is designed in Fig. 4 EXCEL reporting system.
Embodiment
The present invention is described in detail as follows in conjunction with the embodiments:
The Report Designer of the embodiment of the present invention adopts VSTO technology to develop based on EXCEL, and Microsoft Excel interface is the Report Form Design interface of reporting system.
Step one) original document is scanned as picture: be adjusted to identical with original document with image software by scanning the original document picture size obtained.
Step 2) the newly-built original document page: create a blank workbook with Report Designer, i.e. the original document page.
Step 3) import original document picture to the original document page: import original document picture to the background of the original document page as the original document page, is alignd in the upper left corner of the upper left corner of original document picture with Microsoft Excel region.
Step 4) design the original document page: comprise following steps as shown in Figure 2:
1) col width adjusting the original document page is high with row, makes each cell of original document picture, just in time comprises the one or more cells on original document worksheet;
2) Merge Cells, merge the cell on the original document page, make each cell in background, correspondence comprises a cell on the original document page, even in original document Background, certain cell of document form comprises the multiple cells on original document worksheet, then by this multiple cell span, the cell after merging is overlapped completely with the cell in Background;
3) form and cell borders are set: according to the frame of the form on original document picture and cell, for cell corresponding on the original document page arranges identical frame;
4) static text is added: on the original document page, add the position corresponding with the word of original document picture add identical original document page word; Font and the alignment thereof of described original document page word are consistent with the word of original document picture.
Step 5) design actual document page: create the inchoate instrument page, i.e. actual document page, then the content outside Background in the original document page is all copied to actual document page, Database field and form function are placed into the correspondence position of actual document page, step as shown in Figure 3 and Figure 4:
1) the second worksheet is created, actual document page;
2) search actual document page actual use region: search the lastCell cell in actual document page, the line number of this element lattice and row number determine line number and the columns in the actual region used in worksheet, are designated as MaxRow and MaxColumn respectively;
3) the high and col width of adjustment row.For row COL each in actual document page, if its row c meets c<=MaxColumn, its width is set to arrange identical with c in the original document page, for row ROW each in actual document page, if its line number r meets r<=MaxRow, it is highly set to capable identical with r in the original document page;
4) Merge Cells is processed: in the search original document page, effectively use each cell in district, if this cell is Merge Cells, then find out the cell set that this Merge Cells comprises, and in actual document page, merging treatment is done in the cell set of correspondence;
5) Copied Cells frame: the search original document page effectively uses each cell in district, if there is frame, then corresponding unit lattice arrange identical frame in actual document page;
6) copy text: the search original document page effectively uses each cell in district, if there is text, then corresponding unit lattice arrange identical text in actual document page;
7) setting data storehouse field and form function: obtain the correct position that Database field or form function are placed into actual document page from data source.
Step 6) preserve report form template: when preserving document report form template, following content is saved in the different content node of report form template: difference, the original document picture of original document worksheet, actual document worksheet, actual document worksheet and original document worksheet, the query statement of retrieve data.In the present embodiment, report form template saves as XML file, the difference of the original document page, actual document page, actual document page and the original document page all saves as a table node in XML file, each table node comprises several row nodes, corresponding to the row in document worksheet, each row node comprises some cell nodes, corresponding to the cell in document worksheet, each cell has the attributes such as width, frame, font, fill color and text, arranges decision by respective cells in document worksheet.The table child node of original document worksheet and actual document worksheet is obtained by each cell searching for its effective workspace.The difference of actual document worksheet and original document worksheet is based on the table child node of actual document, for each cel l wherein, deduct each attribute appeared in original document table child node, namely obtain the table child node of the difference of actual document worksheet and original document worksheet.Under the picture of original document exists assigned catalogue, preserve its filename in report form template, data query statement is also kept in report form template with the form of a node.
Step 7) browse form.Under the support of report server, the data that will show are retrieved with report data query statement, and fill it in actual document, namely replace Database field in actual document table child node and form function by the real data retrieved, then generate WEB page according to this table child node and show user.
Step 8) report printing.Document report printing is divided into cover to beat and non-cover is beaten, and conveniently user selects printing type, and the form browsing web page arranges the button that cover is beaten and non-cover is beaten.When carrying out non-cover and beating, directly by the report printing of displaying in step 7 out, when carrying out cover and beating, its actual value obtained in Database field in the difference table child node of actual document and original document and form function step 7 is substituted, and generate WEB page according to this table child node and print this difference document on the document paper being printed with original document, realize cover and beat.
The explanation of above example just understands core concept of the present invention for helping; Meanwhile, for one of ordinary skill in the art, according to thought of the present invention, all will change in specific embodiments and applications, in sum, this description should not be construed as limitation of the present invention.
Claims (5)
1. a document form cover printing method, is characterized in that, comprise the steps:
Step one): original document is scanned for picture: scan original document for original document picture, described original document picture is identical with original document size;
Step 2) the newly-built original document page: create the original document page, the described original document page is the blank page;
Step 3) import original document picture to the original document page: original document picture is imported the original document page as a setting, and the size of the adjustment original document page is to overlapping completely with original document picture;
Step 4) design the original document page: on the original document page, the table border identical with background and static text are set, make the original document page and original document completely the same;
Step 5) design actual document page: create the inchoate instrument page, i.e. actual document page, then the content outside Background in the original document page is all copied to actual document page, Database field and form function are placed into the correspondence position of actual document page;
Step 6) preserve report form template: the different content node query statement of the difference page of the original document page, actual document page, actual document page and the original document page, original document picture and retrieve data being saved in report form template, then preserve report form template;
Step 7) browse form: in report server, the data needed with the retrieval of report data query statement, fill it in actual document page;
Step 8) report printing: select cover molding formula or non-cover molding formula, if select non-cover molding formula, directly print actual document page; If select cover to beat, then the data retrieved by report data query statement and function expression result of evaluation are filled into the correspondence position in the difference page of actual document page and the original document page, then print.
2. document form cover printing method as claimed in claim 1, it is characterized in that, the described original document page and actual document page all comprise several rows and some row, described step 4) comprise following steps:
1) col width adjusting the original document page is high with row, makes each cell of original document picture, just in time comprises the one or more cells on the original document page;
2) Merge Cells: merge the cell on the original document page, make each cell in background picture, correspondence comprises a cell on the original document page, even in original document Background, certain cell of document form comprises the multiple cells on the original document page, then by this multiple cell span, the cell after merging is overlapped completely with the cell in Background;
3) form and cell borders are set: according to the frame of the form on original document picture and cell, for cell corresponding on the original document page arranges identical frame;
4) static text is added: on the original document page, add the position corresponding with the word of original document picture add identical original document page word; Font and the alignment thereof of described original document page word are consistent with the word of original document picture.
3. document form cover printing method as claimed in claim 1, it is characterized in that, the described original document page and actual document page all comprise several rows and some row, described step 5) comprise following steps:
A. the second worksheet is created, i.e. actual document page;
B. search the original document page actual use region: search the last location lattice (LastCell) in the original document page, determine that actual document page needs line number and the columns in the region used according to line number and the row number of this element lattice;
C. adjustment row is high with col width: the width height of the row of actual document page and the width of row being set to the height of the row corresponding with the original document page and row is identical;
D. Merge Cells is processed: in the search original document page, effectively use each cell in district, if this cell is Merge Cells, then find out the cell set that this Merge Cells comprises, and in actual document page, merging treatment is done in the cell set of correspondence;
E. Copied Cells frame: the search original document page effectively uses each cell in district, if there is frame, then corresponding unit lattice arrange identical frame in actual document page;
F. copy text: the search original document page effectively uses each cell in district, if there is text, then corresponding unit lattice arrange identical text in actual document page;
G. setting data storehouse field and form function: obtain the position that Database field or form function are placed into the correspondence of actual document page from data source.
4. document form cover printing method as claimed in claim 1, it is characterized in that, the described original document page and actual document page all comprise several rows and some row, described step 6) in, described report form template saves as XML file, the original document page, actual document page, the difference Page-saving of actual document page and the original document page is an Area Node in described XML file, each Area Node comprises several row nodes, described row node corresponds to the row in report form template, each row node comprises some cell nodes, described cell node corresponds to the cell in report form template, the attribute kit of each cell is containing width, frame, font, fill color and text etc., the attribute of described cell arranges decision by respective cells in report form template, the region child node of the original document page and actual document page is obtained by each cell searching for report form template, the difference of actual document page and the original document page is based on the region child node of actual document page, by each cell of actual document page, deduct all properties appeared in original document corresponding unit lattice points, namely obtain the region child node of the difference of actual document worksheet and original document worksheet, under described original document picture exists assigned catalogue, preserve original document picture file name in report form template, described data query statement is also kept in report form template with the form of a node.
5. document form cover printing method as claimed in claim 1, it is characterized in that, in described step 8) in, form browser interface arranges check box beat to indicate whether to overlap, or cover is set respectively on form browser interface and makes button and button made by non-cover, or arrange respectively to overlap and play menu and menu played by non-cover.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510107187.XA CN104715030B (en) | 2015-03-12 | 2015-03-12 | A kind of document form covers printing method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510107187.XA CN104715030B (en) | 2015-03-12 | 2015-03-12 | A kind of document form covers printing method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104715030A true CN104715030A (en) | 2015-06-17 |
| CN104715030B CN104715030B (en) | 2018-02-02 |
Family
ID=53414357
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510107187.XA Expired - Fee Related CN104715030B (en) | 2015-03-12 | 2015-03-12 | A kind of document form covers printing method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104715030B (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105196708A (en) * | 2015-09-22 | 2015-12-30 | 深圳前海百递网络有限公司 | Printing setting method and printing device |
| CN108805684A (en) * | 2018-04-17 | 2018-11-13 | 海闻科技有限公司 | A kind of tax administration platform application system |
| CN111367945A (en) * | 2020-02-28 | 2020-07-03 | 平安医疗健康管理股份有限公司 | Report query method, device, equipment and computer readable storage medium |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1227407A2 (en) * | 2001-01-24 | 2002-07-31 | Seiko Instruments Inc. | User interface for creating printing templates |
| CN101577009A (en) * | 2008-05-08 | 2009-11-11 | 北京润乾信息系统技术有限公司 | Method for realizing overlay printing on prior form |
| CN102722899A (en) * | 2012-05-28 | 2012-10-10 | 重庆大学 | Positioning printing system for report |
| CN103713901A (en) * | 2013-12-24 | 2014-04-09 | 金蝶软件（中国）有限公司 | Showing method and system of bills |
-
2015
- 2015-03-12 CN CN201510107187.XA patent/CN104715030B/en not_active Expired - Fee Related
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| EP1227407A2 (en) * | 2001-01-24 | 2002-07-31 | Seiko Instruments Inc. | User interface for creating printing templates |
| CN101577009A (en) * | 2008-05-08 | 2009-11-11 | 北京润乾信息系统技术有限公司 | Method for realizing overlay printing on prior form |
| CN102722899A (en) * | 2012-05-28 | 2012-10-10 | 重庆大学 | Positioning printing system for report |
| CN103713901A (en) * | 2013-12-24 | 2014-04-09 | 金蝶软件（中国）有限公司 | Showing method and system of bills |
Non-Patent Citations (2)
| Title |
|---|
| HEZONGWU2009: ""EXCEL实现票据套打高效化"", 《百度文库》 * |
| NHPNTYHHT，: ""如何用excel制作表格套打格式"", 《百度文库》 * |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105196708A (en) * | 2015-09-22 | 2015-12-30 | 深圳前海百递网络有限公司 | Printing setting method and printing device |
| CN108805684A (en) * | 2018-04-17 | 2018-11-13 | 海闻科技有限公司 | A kind of tax administration platform application system |
| CN111367945A (en) * | 2020-02-28 | 2020-07-03 | 平安医疗健康管理股份有限公司 | Report query method, device, equipment and computer readable storage medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104715030B (en) | 2018-02-02 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101025738B (en) | Template-free dynamic website generating method | |
| Jacobs et al. | Adaptive grid-based document layout | |
| US7363581B2 (en) | Presentation generator | |
| CN111753500A (en) | Method for merging and displaying formatted electronic form and OFD (office file format) and generating catalog | |
| CN110032720A (en) | A kind of visualization report typesetting and automatic generation method and system based on XML | |
| CN103365855A (en) | Method and server for generating web pages | |
| CA2773152A1 (en) | A method for users to create and edit web page layouts | |
| CN106021394A (en) | Website construction method and apparatus | |
| CN103258015A (en) | Method for dynamically generating questionnaire based on XML | |
| CN105094930A (en) | Image positioning system and method | |
| CN101828165A (en) | Watching of feeds | |
| CN104715030B (en) | A kind of document form covers printing method | |
| CN104679453A (en) | Information input, storage, typesetting and printing general system and information input, storage, typesetting and printing method | |
| CN112307720A (en) | PSD (position sensitive Detector) document-based HTML (Hypertext markup language) design template automatic conversion method and system | |
| CN109213480A (en) | A kind of method, storage medium, equipment and system for developing the back-stage management page | |
| CN107193549A (en) | Webpage quick development method based on metadata | |
| CN104424174A (en) | Document processing system and document processing method | |
| US11644949B2 (en) | Autotagging a template of a reporting workbook | |
| US20070162848A1 (en) | Predictive styling | |
| US8788926B1 (en) | Method of content filtering to reduce ink consumption on printed web pages | |
| US20090249192A1 (en) | Creating a view from multiple templates | |
| US8185818B2 (en) | Mixed techniques for HTML crosstab rendering | |
| CN103605640B (en) | Form adaption method and device | |
| CN112558894B (en) | Canvas-based dynamic webpage printing method, system and storage medium | |
| CN115272530A (en) | Intelligent dynamic cover synthesis method and system for enterprise online education |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20180202 Termination date: 20210312 |