Reports Won't Print Full Page Width
Juan Alonso
When I go to print the report it only prints to 8 1/2 width.
These reports are printed normally on a WIDE CARRIAGE PRINTER (OkiData
Microline 591 24-pin).
What can I do to print these guys like they use to print.
I looked and even if I re-create the report from scratch it won't print wide
carriage printing.
When I say I looked, I mean, I looked at every single setting you can think
of.
Here is a small list.
I used wide form setting on the driver...(FanFold 11hx13.6w).. no chance..
I used landscape settings.. no way.. prints sideways instead of accross.
I used custom form settings in print server settings when I created them,
got it on screen but still won't print right.
Is there a way for me to do this? Or am I going to have to redesign the way
I make reports. This is rediculous.
Why couldn't MS create a report writer that we can use any custom size we
want and only the FONT SIZE will
determine where it can be fitted to. The old way of doing this was easy.
You can go as far as 254 characters in width
and it would never give me this kind of problem. Freakin Windows
Limitations.. this is not right.
Well if anyone can help I would greatly appretiate it.
Thanks in advance,
Juan.
Fred Taylor
printer is attached to. Then make sure your report is using that custom
page.
--
Fred
"Juan Alonso" <jo...@npdlink.com> wrote in message
news:%232Pw3Q2...@TK2MSFTNGP04.phx.gbl...
Juan Alonso
I tryed everything dude. This is frustrating.
Ok.. let me be more specific and perhaps you can really see this.
I print on wide carriage paper.. thats about 11 hight by about 13.8 width.
I define a form that I can use to have this size.
When I create the report I use the form I created. At desing time, I can
fit all my fields just fine cuz I am using the custom form I made.
I go to print and then I have a problem. It will only print to 8.5 width
marker (the printer hardware setting default is set to print wide pages).
I
can't make it go past that marker. The funny thing is that if I select
landscape then it prints sideways on my paper.. I then created it using
FanFold which creates a wide paper, but hey guess what.. not when it
prints.. it will still print only up to 8.5 width.. what the heck.. whats
this obey Windows shit.. why can't MS just make it to where the ruler line
actually composes to paper size specified and thats all it should do.. not
this restriction shit due to printer driver or any other WINDOWS factors.
Report creation should allow you to send information as if sending to the
standard input/output device regardless of driver in Windows "STD/PRN"
without any size restrictions. In fact it should be character based. If
you say for example I want 66 x 132.. that would give you 66 characters by
132 characters at 10 pitch. This should be drawn like this.. so if you use
a smaller pitch than 10 for your character font, you will have more room to
fit stuff in. If you use larger font then it becomes less spacious. So
this
way the report is not based on Windows settings, but rather report
settings.
Now after this, when it prints out it should use full width as if drawing
an
image of itself first then printing.. this way if the printer is the
problem
because you don't have it set to print wide it will be the only thing to
have to adjust...
Like right now if I wanted this kind of behavior I would have to use the
old
SET CONSOLE OFF, SET TALK OFF, SET ECHO OFF, SET DEVICE TO PRINTER and then
use the @.. Say .. commands and functions in order to get this type of
result.
Come on.. you can't tell me with all the Visual Foxpro 9 Enhansments to the
report writer, no one thought about doing this in order to simplify the
writer flexabilities..??? I doubt that no one thought of it... Especially
knowing that most corporations print wide as reports because of the amount
of columns they need to analyse information.
Anyway, if you hear of a way to play with this.. or to even get a good
result.. let me know.. Im stuck having to find out by trial and error
here..
lets see.. If I see a way I will post it here.. meanwhile I ask everyone to
please pin what ever you can find to this message so others can share it..
it is one frustrating event with this wide report issue.. it really is.. I
have over 150 different reports that print wide.. and I would have to go
over at least 500 thousand lines of code to adjust them all with "@..Say"
commands..
Ok.. Fred.. If you get any other information please shoot it this way
brother.. Im really needing help man..
Thanks,
Juan.
>
>
> "Fred Taylor" <fta...@mvps.org!REMOVE> wrote in message
> news:%23Z8NqM7...@TK2MSFTNGP02.phx.gbl...
tom knauf
did you check with sys(1037) whether your new printer form is used ?
What happens, if you save the printer with the environment (can take it off
afterwards) ?
Try to delete the line with PAPERSIZE= in the report (use it)
There is also a directprint Class at universalthread if I remember
correctly.
HTH
Tom
Juan Alonso
am posting them in case they did not go through.
Fred...
Thanks,
Juan.
---------------------------------------------------------------------------------------------
Dear Tom,
I set the printer correctly and I set the report correctly.
It is using the form I said to use, but it don't care.
I never use printing environment nor data environment on any of my forms or
reports..
Do you know of a way to generate PRG code from an FRX?
Let me know.. I think that would be more helpful than to screw with this
crap any longer.
Thanks,
Juan.
Juan Alonso
I got a tool that I used and it has made everything so clear in regards to
reports.
This tool has been around since Foxpro Dos v.2.0
The tool is Frx2Prg.Prg
I adjusted it with two things it did not have.
One was to ignore the first line where to formating goes.
I did this because the first line of a report FRX file is the main format
line.
I had reports in FoxPro 2.0 and some in 2.6 so this header was slightly
different.
I also tested it with new VFP 9 FRXs and so you can compile it in vfp9 and
still use it.
It is not perfect but it gives you about 90% of your stuff ready to be
coded.
And two, It now produces the PICTURE clause for each line printed so that
you don't have to worry about the length of the fields you are printing.
This was a tackle since some fields were pushing others off the page and
being that our OkiData printers wrap at the end of the line.. well guess
what? So was the data wrapping around throwing them behond the page markers
I needed.
Anyway this is what has helped in printing without the regards to Windows
Printer Drivers.
Unfortunately, Windows printer drivers are limited and even if you create a
new form to adjust the reports they are useless.
You would have to do it to each Windows computer that will be using the
reports. SHAME ON YOU MICROSOFT.
This limitation took me back to the primitive programming of DOS Batch
Programming. By creating temporary text files for printing, I have been
able to cover any width to any paper on any printer.
If you would like the tool with its current adjustments I can post the zip
file at my personal sit: www.geocities.com/jacinc2 and you can add or
manipulate it as you please, email me if you want it through emails.. at:
jac...@gamil.com
Thank you and don't forget to write yourself in if you make any changes so
that others can use the tool and know all who has been involved in making
this tool better.
Im so glad this tool was even started because it really helped me, not only
in being to do these wide reports, but the time it took the original people
to sit there and analyze an FRX file to distiguish the sections that
identify the parts thereof.
If by any means you can't find the tool at my site shoot me an email and
I'll send it to you.
Thanks to all the people that has helped me and I hope I can be a help to
others as well.
Juan.
"Juan Alonso" <jo...@npdlink.com> wrote in message news:...
> ** I don't know, but the first time I posted these, I did not see them so
> I am posting them in case they did not go through.
>
>