Print Preview ActiveX Active Users: 22 / Visits Today: 147
Highest Active Users: 22
Print Preview ActiveX
Home | Profile | Register | Active Topics | Members | Search | FAQ | RSS
Save Password
Forgot your Password?

 All Forums
 Print Preview
 Help file
 Text on the right side always printed to next row?
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic: DrawPictureMemory Topic Next Topic: ZZZ  

Starting Member

1 Posts

Posted - 10/03/2005 :  05:28:55  Show Profile  Reply with Quote
I'm wonder about addtextat, why the text for the most right side column on the last row of page always printed to the next row on next page and here I give my part of script and sample report. I hope some of you can tell me how to correct the script. Thank's before.

While Not rsDTbl.EOF
.FontSize = 8
.AddTextAt rsDTbl.Fields("KdBrg"), "1 cm", , prALLeft, prASNone
.AddTextAt rsDTbl.Fields("Nama"), "2.7 cm", , prALLeft, prASNone
.AddTextAt rsDTbl.Fields("Satuan"), "8.7 cm", , prALLeft, prASNone
.AddTextAt FormatNumber(rsDTbl.Fields("HrgBeli"), 0, False, False, True), "11.8 cm", , prALRight, prASNone
.AddTextAt FormatNumber(rsDTbl.Fields("Qty"), 0, False, True, True), "12.8 cm", , prALRight, prASNone
.AddTextAt rsDTbl.Fields("Dsc"), "13.8 cm", , prALRight, prASNone
.AddTextAt FormatNumber(rsDTbl.Fields("Disc"), 0, False, True, True), "15.7 cm", , prALRight, prASNone
.AddTextAt FormatNumber(rsDTbl.Fields("Brutto") - rsDTbl.Fields("Disc"), 0, False, False, True), "17.6 cm", , prALRight, prASPage
.Modal = True
.EndDocument prOTScreen

Download Attachment: [img]images/icon_paperclip.gif[/img] Report.pdf
7.6 KB

Edited by - dickywinarto on 10/03/2005 11:21:23
Go to Bottom of Page

New Member

77 Posts

Posted - 10/04/2005 :  18:01:00  Show Profile  Reply with Quote
You need to move this to another topic section rather then in the Help File section.

But anyway I believe it's the prASPage is doing you in. You need to test for end of page and then issue the prASPage only if your at the end of the page with an empty text string.
Go to Bottom of PageGo to Top of Page
  Previous Topic: DrawPictureMemory Topic Next Topic: ZZZ  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
Print Preview ActiveX © Mandix Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000 Version 3.4.02