Print Preview ActiveX Active Users: 24 / Visits Today: 31
Highest Active Users: 106
Print Preview ActiveX
Home | Profile | Register | Active Topics | Members | Search | FAQ | RSS
Username:
Password:
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  

dickywinarto
Starting Member

Indonesia
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
rsDTbl.MoveNext
Wend
.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

dkwesley
New Member

USA
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.08 seconds. Powered By: Snitz Forums 2000 Version 3.4.02