MIDRANGE dot COM Mailing List Archive



Home » MIDRANGE-L » June 2008

Re: Query Management Reports Problem



fixed

Jerry!

Welcome to my favorite world!

You have to use OVRPRTF on QPQXPRTF, as someone else said.

The nice thing, however, is that you get ALL the data, albeit in slices. Seems to me that Query/400 just truncates it to one set - maybe wraps if you elect that option.

Just wait until you have had long text wrap in a narrow column - CW or CT edit codes inside the form - awesome!

Regards
Vern

-------------- Original message --------------
From: Jerry Adams <Jerry@xxxxxxxxxxxxxxx>

I decided to take a stab at using Query Manager, rather than Query/400, for some
reports so that I could use variables for some of the SELECT criteria. All of
that is going pretty smoothly, but the report form always wants to format for 80
character width when I use the 'Run' option in the "Work with Query Manager
Queries" thus splitting a wide (>80) report into two report files. In
Query/400 one can specify the report width and, when printing to a non-impact
printer, the report gets rotated.

I have looked everywhere for a similar option or effect in both the query and
form definitions, but zilch. I have even (horrors!) been reading the manual
(Query Manager Use). If the solution to getting a wide report on a single page
is there, I have totally missed it.

Thanks.

Jerry C. Adams
IBM System i Programmer/Analyst
B&W Wholesale
office: 615-995-7024
email: jerry@xxxxxxxxxxxxxxx

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.





Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact