Print2PDF - Landscape and Legal

Using VFP 9.1 and XP sp2

I've used Print2PDF for some time now and found it very useful. The only
problem I've encountered until now is the VFP habit of storing printer info
in the frx. But I guess I haven't tried making a legal, landscape report
into a pdf.

If I run the report using to printer prompt and select Acrobat PDFWriter I'm
able to create the report in the page layout I need, but using print2pdf I'm
getting a VFP message box: "Detail 1 band is too large to fit on page."

Has anyone encountered this before? Any suggestions? I've looked through
the documentation for landscape, paper size, orientation, etc. to no avail.

Thanks in advance,
Dave

Man-wai
Tue Sep 18 06:47:37 PDT 2007

> I've used Print2PDF for some time now and found it very useful. The only
> problem I've encountered until now is the VFP habit of storing printer info
> in the frx. But I guess I haven't tried making a legal, landscape report
> into a pdf.

Hack the FRX. Remove the printer information.
http://fox.wikis.com/wc.dll?Wiki~FrxTips~VFP


--
@~@ Might, Courage, Vision, SINCERITY.
/ v \ Simplicity is Beauty! May the Force and Farce be with you!
/( _ )\ (Xubuntu 7.04) Linux 2.6.22.6
^ ^ 21:44:01 up 7 days 12:03 1 user load average: 0.00 0.00 0.00
news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk

Stephen
Tue Sep 18 08:06:29 PDT 2007

Not sure if it is related, but I had this error when developing a complex
report with a very deep detail band, and sending it to my normal printer. It
worked fine. However trying it on a customer's machine with a different
printer I got the error you describe. I tackled it in two ways:

I very carefully measured the header, detail and footer bands, and ensured
that the combination of all three bands would indeed fit onto the sheet of
paper.

I then looked at the Page setup option from the File menu when designing the
report and set the Print area to 'Whole page'. Finally I ensured that white
space at top, bottom, left and right in the report design were sufficient to
work on all printers so that no text would be lost, whatever the printer
margins.

The problem was then fixed.

Sincerely

Stephen

"David Tiffany" <dtiffany@nospam.com> wrote in message
news:%23UTRloU%23HHA.5360@TK2MSFTNGP03.phx.gbl...
> Using VFP 9.1 and XP sp2
>
> I've used Print2PDF for some time now and found it very useful. The only
> problem I've encountered until now is the VFP habit of storing printer
> info in the frx. But I guess I haven't tried making a legal, landscape
> report into a pdf.
>
> If I run the report using to printer prompt and select Acrobat PDFWriter
> I'm able to create the report in the page layout I need, but using
> print2pdf I'm getting a VFP message box: "Detail 1 band is too large to
> fit on page."
>
> Has anyone encountered this before? Any suggestions? I've looked through
> the documentation for landscape, paper size, orientation, etc. to no
> avail.
>
> Thanks in advance,
> Dave
>
>

David
Tue Sep 18 08:51:40 PDT 2007

Thanks. I'd already removed the printer references from the frx. Still
encountering the problem.
Dave

"Man-wai Chang ToDie" <toylet.toylet@gmail.com> wrote in message
news:%232DzVpf%23HHA.5164@TK2MSFTNGP05.phx.gbl...
>> I've used Print2PDF for some time now and found it very useful. The only
>> problem I've encountered until now is the VFP habit of storing printer
>> info
>> in the frx. But I guess I haven't tried making a legal, landscape report
>> into a pdf.
>
> Hack the FRX. Remove the printer information.
> http://fox.wikis.com/wc.dll?Wiki~FrxTips~VFP
>
>
> --
> @~@ Might, Courage, Vision, SINCERITY.
> / v \ Simplicity is Beauty! May the Force and Farce be with you!
> /( _ )\ (Xubuntu 7.04) Linux 2.6.22.6
> ^ ^ 21:44:01 up 7 days 12:03 1 user load average: 0.00 0.00 0.00
> news://news.3home.net news://news.hkpcug.org news://news.newsgroup.com.hk

David
Tue Sep 18 08:59:56 PDT 2007

Thanks Stephen.

This seems to have fixed it. I took your advice about whole page and then
measure. The report dtail is quite deep. One record per page. After a
little fiddling around it's producing a pdf with all my data visible.

Dave

"Stephen Ibbs" <stephen@datadevelopments.co.uk> wrote in message
news:%2351PDWg%23HHA.5360@TK2MSFTNGP03.phx.gbl...
> Not sure if it is related, but I had this error when developing a complex
> report with a very deep detail band, and sending it to my normal printer.
> It worked fine. However trying it on a customer's machine with a different
> printer I got the error you describe. I tackled it in two ways:
>
> I very carefully measured the header, detail and footer bands, and ensured
> that the combination of all three bands would indeed fit onto the sheet of
> paper.
>
> I then looked at the Page setup option from the File menu when designing
> the report and set the Print area to 'Whole page'. Finally I ensured that
> white space at top, bottom, left and right in the report design were
> sufficient to work on all printers so that no text would be lost, whatever
> the printer margins.
>
> The problem was then fixed.
>
> Sincerely
>
> Stephen
>
> "David Tiffany" <dtiffany@nospam.com> wrote in message
> news:%23UTRloU%23HHA.5360@TK2MSFTNGP03.phx.gbl...
>> Using VFP 9.1 and XP sp2
>>
>> I've used Print2PDF for some time now and found it very useful. The only
>> problem I've encountered until now is the VFP habit of storing printer
>> info in the frx. But I guess I haven't tried making a legal, landscape
>> report into a pdf.
>>
>> If I run the report using to printer prompt and select Acrobat PDFWriter
>> I'm able to create the report in the page layout I need, but using
>> print2pdf I'm getting a VFP message box: "Detail 1 band is too large to
>> fit on page."
>>
>> Has anyone encountered this before? Any suggestions? I've looked
>> through the documentation for landscape, paper size, orientation, etc. to
>> no avail.
>>
>> Thanks in advance,
>> Dave
>>
>>
>
>

Gene
Tue Sep 18 15:23:00 PDT 2007

"David Tiffany" <dtiffany@nospam.com> wrote:

>Thanks. I'd already removed the printer references from the frx. Still
>encountering the problem.

VFP will put them back in. Could that be your problem?

I had to solve this for printer orientation. I created two
.frx/.frt configs, one for portrait and one for landscape. I copy as
needed to a temporary file and use the temporary.

***** Start of Included Code *****
* setorient
* Set Printer Orientation
* Last Modification: 2007-04-04

procedure setorient && base
lparameters;
orient && = L: .t.=set to portrait, .f.=set to landscape

local savealias
savealias=select(0)
select 0

if orient
use cprnport.frx
else
use cprnland.frx
endif

copy to cprnuse.frx
use

use cprnuse.frx exclusive
=sys(1037,3)
use

select (savealias)

erase cprnuse.frx
erase cprnuse.frt

return

endproc
***** End of Included Code *****

[snipped previous]

Sincerely,

Gene Wirchenko

Computerese Irregular Verb Conjugation:
I have preferences.
You have biases.
He/She has prejudices.