× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Thanks Chuck and Jim. That was it exactly. I'd been running the query using option 9 from the 'Work With Query Management Queries' screen. I just ran it again using the STRQMQRY changing the parms as advised and it worked great.

Thanks again guys.

message: 1
date: Wed, 16 May 2012 11:01:56 -0600
from: Jim Essinger <dilbernator@xxxxxxxxx>
subject: Re: QMFORM Page Footer Question

How are you running the query?

STRQMQRY has two additional parms if you specify *PRINT on output. They are DATETIME and PAGNBR, and they default to *YES. Run your query with those two parms changed and it should remove the info you don't want.

Jim

On Wed, May 16, 2012 at 9:44 AM, Emily Smith <ESmith@xxxxxxxxxxxxxxxxxxxx>wrote:

Folks,

I'm currently working on a QMQRY and corresponding form. On my form, I
have defined a header that contains all of the usual information
(Title, Date and Time, Page number). I have nothing defined as a page footer.
However, when I run the query and generate the report, the date,
time, and page number appear at the bottom of each page. Is there a
way to get rid of this?

TIA,

Emily Smith
CONFIDENTIALITY NOTICE: This email message is private, confidential
property of the sender, and the materials may be privileged
communications intended solely for the receipt, use, benefit, and
information of the intended recipient, you are hereby notified that
any review, disclosure, distribution, copying, or taking of any other
action in reference to the contents of this message is strictly
prohibited, and may result in legal liability on your part. If you
have received this message in error, please notify the sender
immediately and delete this message from your system. We believe that
this email and any attachments are free of any virus or other defect
that might affect any computer system that it is received and opened
in, however, it is the responsibility of the recipient to ensure that it is virus free and the sender accepts no responsibility for any loss or damage.
--
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.




------------------------------

message: 2
date: Wed, 16 May 2012 10:26:09 -0700
from: CRPence <CRPbottle@xxxxxxxxx>
subject: Re: QMFORM Page Footer Question

On 16 May 2012 08:44, Emily Smith wrote:
I'm currently working on a QMQRY and corresponding form. On my form, I
have defined a header that contains all of the usual information
(Title, Date and Time, Page number). I have nothing defined as a page
footer. However, when I run the query and generate the report, the
date, time, and page number appear at the bottom of each page.
Is there a way to get rid of this?

I do not think the issue is the QMFORM, neither the FINAL TEXT nor the PAGE footing text. Rather, that the issue is the PRINT REPORT options which include the specification of the FORM itself; i.e.
FORM=form-name DATETIME=YES|NO PAGENO=YES|NO. These parameters are all manifest on the STRQMQRY command as parameters QMFORM() DATETIME() PAGNBR(). Presumably all you need to do is explicitly specify these two additional print-report options, beyond the form-name, because they both default to YES; e.g.:

STRQMQRY QMQRY(qry-name) OUTPUT(*PRINT) QMFORM(form-name)
DATETIME(*NO) PAGNBR(*NO)

Regards, Chuck


**************
CONFIDENTIALITY NOTICE: This email message is private, confidential property of the sender, and the materials may be privileged communications intended solely for the receipt, use, benefit, and information of the intended recipient, you are hereby notified that any review, disclosure, distribution, copying, or taking of any other action in reference to the contents of this message is strictly prohibited, and may result in legal liability on your part. If you have received this message in error, please notify the sender immediately and delete this message from your system. We believe that this email and any attachments are free of any virus or other defect that might affect any computer system that it is received and opened in, however, it is the responsibility of the recipient to ensure that it is virus free and the sender accepts no responsibility for any loss or damage.


As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.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 on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.