Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Reports print blank page

10 views
Skip to first unread message

Dave Loveridge

unread,
Aug 19, 2004, 12:12:01 AM8/19/04
to corel.developer.paradox

We have some reports that were created in version 8. When they were upgraded
to V10. they all print a blank page, I have tried for quite a while to stop
it and the only solution I have been able to come up with is to create new
reports from scratch, is there any other way to fix this.

Thanks in advance

Dave Loveridge

Bertil Isberg

unread,
Aug 19, 2004, 2:15:28 AM8/19/04
to corel.developer.paradox

Dave

Have you installed any of the service packs to WP Office 2002? Avoid
service pack 4, stay with SP3 if you are using Paradox.


--
Bertil Isberg
CTECH
FAQ newsgroup: corel.wpoffice.paradox-faq
Paradox Buglist: http://w1.826.comhem.se/~u82608896/

remove spamfilter (reversed) to reply


Jeff Shoaf

unread,
Aug 19, 2004, 7:14:25 PM8/19/04
to corel.developer.paradox

In one of the P9 service packs, they changed a report printing default
from printClipToWidth to printOverflowPages. If you're using a
reportPrintInfo record, you can set it by using:

reportPrintInfoVariable.panelOptions = reportClipToWidth

Dave Loveridge

unread,
Aug 19, 2004, 11:55:14 PM8/19/04
to corel.developer.paradox

We are using Service pack 3.


"Bertil Isberg" <bertil...@retlifmapsSCB.se> wrote in message
news:41243fbb$1_3@cnews...

Dave Loveridge

unread,
Aug 19, 2004, 11:56:56 PM8/19/04
to corel.developer.paradox

I will give it a try.
Thanks

"Jeff Shoaf" <jeff...@alltel.net> wrote in message
news:41252125_1@cnews...

Bertil Isberg

unread,
Aug 20, 2004, 3:19:54 AM8/20/04
to corel.developer.paradox

Jeff
<<
reportClipToWidth
>>

The constant name is printClipToWidth

Bertil Isberg

unread,
Aug 20, 2004, 3:20:47 AM8/20/04
to corel.developer.paradox

Dave

<<
We are using Service pack 3.
>>

Then you probably got the solution from Jeff.

Jeff Shoaf

unread,
Aug 20, 2004, 6:12:25 PM8/20/04
to corel.developer.paradox

Whoops - you're right! I thought it looked odd when I typed it in, but
couldn't see the problem.

Dave Loveridge

unread,
Sep 13, 2004, 2:58:45 PM9/13/04
to corel.developer.paradox

Well, I have not been able to get this to work.
Any other suggestions?

"Jeff Shoaf" <jeff...@alltel.net> wrote in message

news:4126641e_2@cnews...

Jeff Shoaf

unread,
Sep 13, 2004, 7:32:22 PM9/13/04
to corel.developer.paradox

Please show your ObjectPAL code - just copy and paste the var block, the
section where you set up your reportPrintInfo options, and the section
where you open and print the report.

Dave Loveridge

unread,
Sep 14, 2004, 3:25:33 PM9/14/04
to corel.developer.paradox

VAR
P STRING
Q QUERY
V tableView
R Report
st number
pn string
poQBE Query
tc TCursor
prnOptions PrinterOptionInfo
EndVar
active.unlockRecord()

reportPrintInfoVariable.panelOptions = PrintClipToWidth


executeQBE(Q,"Poprint.db")
printerSetOptions(prnOptions)
R.open("RFQ.RSL")
R.print("RFQ.RSL")
close(R)

"Jeff Shoaf" <jeff...@alltel.net> wrote in message

news:41461acd_1@cnews...

Bertil Isberg

unread,
Sep 14, 2004, 3:49:15 PM9/14/04
to corel.developer.paradox

Dave

<<
VAR
P STRING
Q QUERY
V tableView
R Report
st number
pn string
poQBE Query
tc TCursor
prnOptions PrinterOptionInfo
EndVar
active.unlockRecord()

reportPrintInfoVariable.panelOptions = PrintClipToWidth


executeQBE(Q,"Poprint.db")
printerSetOptions(prnOptions)
R.open("RFQ.RSL")
R.print("RFQ.RSL")
close(R)
>>

Let's look at this code

1) reportPrintInfoVariable.panelOptions = PrintClipToWidth

I don't see the variable - reportPrintInfoVariable - declared and neither
can I see it used.

2) printerSetOptions(prnOptions)

I don't see any assignments to prnOptions

3) R.open("RFQ.RSL")

You open the report ignoring reportPrintInfoVariable

4) R.print("RFQ.RSL")

By supplying the filename in print(), you print a completely fresh report
which ignores reportPrintInfoVariable.

5) close(R)

May be valid syntax, but r.close() is more in line with the rest of your
code.


Help files show an example on how to use reportPrintInfo

var
stockRep Report
repInfo ReportPrintInfo
endVar
; first, set up the repInfo record
repInfo.nCopies = 2
repInfo.makeCopies = True
repInfo.name = "Stock"
stockRep.print(repInfo)

In your case, with variable names from the helpfile example, it would be
repinfo.panelOptions = PrintClipToWidth
repinfo.name="RFQ"
stockrep.print(repinfo)

--
Bertil Isberg - CTECH
Paradox buglist:
online: http://w1.826.comhem.se/~u82608896/
FAQ newsgroup: corel.wpoffice.paradox-faq

Dave Loveridge

unread,
Sep 14, 2004, 4:19:01 PM9/14/04
to corel.developer.paradox

This is old code, written by someone else, it is not how I would have done
things.
PrnOptions PrinterOptionInfo was for something else that has been taken out
I just forgot to take out the last line.
But I also am still learning, it finally works
thanks Bertil
Dave

"Bertil Isberg" <bertil.isberg@NOcomhemSPAMdotse> wrote in message
news:414744b3_2@cnews...

0 new messages