Discussion:
How do I make reports wider?
(too old to reply)
Juan Alonso
2009-01-29 18:10:18 UTC
Permalink
I would like to make a report wider than 8 1/2 x 14 Legal.

I need to do this because of extra wide carriage printing we do.

The Report Builder won't let me do Custome Sizes... or is there a way to do
custom sizes?

I use VFP9 with all hotfixes and service packs.

Can any one help?

Thanks in advance,

Juan.
tom knauf
2009-01-30 08:50:18 UTC
Permalink
Hi,

I think you have to setup the format as a custom format on your printer,
select the printer in foxpro
and then the new format must be used in foxpro page layout.
How to set a new format depends whether its a printer connected to the
server or not.

You can also try to use the frx directly and edit the content of the memo,
search PAPERSIZE=
and in the registry
\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Print\Forms

There was also some code (apicalls) how to setup new customs formats from
foxpro, maybe it was on UT

HTH
Tom
Post by Juan Alonso
I would like to make a report wider than 8 1/2 x 14 Legal.
I need to do this because of extra wide carriage printing we do.
The Report Builder won't let me do Custome Sizes... or is there a way to
do custom sizes?
I use VFP9 with all hotfixes and service packs.
Can any one help?
Thanks in advance,
Juan.
Juan Alonso
2009-01-30 16:01:24 UTC
Permalink
Hey Tom.

Thanks for the information.

I tryed these already and nothing works.

My width column will not do anything higher than 14000/ which is "8.5 x 14".

And my printer settings have only standard printer information.

I need to find out if I can really manipulate the report writer in any way
otherwise I am going to have to create a function in order to allign all the
objects at the line they are in but next to each other with at least a space
between objects.

This way if I have to adjust any old Foxpro 2.x reports and Convert it to
VFP, I can use it and then readjust where they will appear on the report.

This is mainly what is happening to me. I have been converting a code from
Foxpro 2.x.. I first took it to VFP 5, then 6, jumped from 6 to 8 and now to
9.

I think I am going to have to create the function.

I have a function already that changes attributes for all the highlighted
objects I can adjust it to line them up next to each other on the left side
of the screen and work their possitions from there.

If you hear of anything out there I could already use please let me know. I
think I will give away my code for the tool so others can use it for their
reports.

Ok. Later and thanks again.

Juan.
Post by tom knauf
Hi,
I think you have to setup the format as a custom format on your printer,
select the printer in foxpro
and then the new format must be used in foxpro page layout.
How to set a new format depends whether its a printer connected to the
server or not.
You can also try to use the frx directly and edit the content of the memo,
search PAPERSIZE=
and in the registry
\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Print\Forms
There was also some code (apicalls) how to setup new customs formats from
foxpro, maybe it was on UT
HTH
Tom
Post by Juan Alonso
I would like to make a report wider than 8 1/2 x 14 Legal.
I need to do this because of extra wide carriage printing we do.
The Report Builder won't let me do Custome Sizes... or is there a way to
do custom sizes?
I use VFP9 with all hotfixes and service packs.
Can any one help?
Thanks in advance,
Juan.
tom knauf
2009-02-02 11:53:54 UTC
Permalink
Hi,

does your printer shows you the different forms (German fanfold for example
:-)) ?
Call a sys(1037) to check
If not, you cannot design a report for a different form (as far as I know)

Greetings
tom
Post by Juan Alonso
Hey Tom.
Thanks for the information.
I tryed these already and nothing works.
My width column will not do anything higher than 14000/ which is "8.5 x 14".
And my printer settings have only standard printer information.
I need to find out if I can really manipulate the report writer in any way
otherwise I am going to have to create a function in order to allign all
the objects at the line they are in but next to each other with at least a
space between objects.
This way if I have to adjust any old Foxpro 2.x reports and Convert it to
VFP, I can use it and then readjust where they will appear on the report.
This is mainly what is happening to me. I have been converting a code
from Foxpro 2.x.. I first took it to VFP 5, then 6, jumped from 6 to 8 and
now to 9.
I think I am going to have to create the function.
I have a function already that changes attributes for all the highlighted
objects I can adjust it to line them up next to each other on the left
side of the screen and work their possitions from there.
If you hear of anything out there I could already use please let me know.
I think I will give away my code for the tool so others can use it for
their reports.
Ok. Later and thanks again.
Juan.
Juan Alonso
2009-02-02 13:29:50 UTC
Permalink
Yes, yes, I do have all the forms showing.

Im freakin bad at this crap. Before, I could design my work area up to 255
characters wide, now I have to go on pre-determined papersizes. This is
straight stupid.

All I really need to do is create or find a function that can grab every
object on a form and line them up from left to right next to each other with
a space in between without moving the row they are corrently located on.

Thanks for everything. If you see or hear of a function to do this would
you please email me (***@npdlink.com).

Juan.
Post by tom knauf
Hi,
does your printer shows you the different forms (German fanfold for
example :-)) ?
Call a sys(1037) to check
If not, you cannot design a report for a different form (as far as I know)
Greetings
tom
Post by Juan Alonso
Hey Tom.
Thanks for the information.
I tryed these already and nothing works.
My width column will not do anything higher than 14000/ which is "8.5 x 14".
And my printer settings have only standard printer information.
I need to find out if I can really manipulate the report writer in any
way otherwise I am going to have to create a function in order to allign
all the objects at the line they are in but next to each other with at
least a space between objects.
This way if I have to adjust any old Foxpro 2.x reports and Convert it to
VFP, I can use it and then readjust where they will appear on the report.
This is mainly what is happening to me. I have been converting a code
from Foxpro 2.x.. I first took it to VFP 5, then 6, jumped from 6 to 8
and now to 9.
I think I am going to have to create the function.
I have a function already that changes attributes for all the highlighted
objects I can adjust it to line them up next to each other on the left
side of the screen and work their possitions from there.
If you hear of anything out there I could already use please let me know.
I think I will give away my code for the tool so others can use it for
their reports.
Ok. Later and thanks again.
Juan.
Loading...