Re: Heading dates on query reports

I am not sure what the job date would be,
but you can retrieve it in a cl and then do a OVRPRTF

and output the date in the PRTTXT parm  -  it will print at the bottom of the page though..

Alternatively, using SQL and QueryManager might provide some other alternatives,
but am not very familiar with it...


just my .01c worth...



At 03:35 PM 02/13/2001, you wrote:

 

What you are trying to do is placing variable in the query heading which I believe is not possible.

Try writing a CLP,  run an OPNQRYF call  RPG and execute the TIME OpCode at page- break. Isolate date and print on report Heading.

 

 
>From: "Joe Montes"
>Reply-To: RPG400-L@midrange.com
>To:
>Subject: Heading dates on query reports
>Date: Tue, 13 Feb 2001 11:53:45 -0800
>MIME-Version: 1.0
>Received: from [192.160.127.90] by hotmail.com (3.2) with ESMTP id MHotMailBC52E3FB0013400431CBC0A07F5A0AE90; Tue Feb 13 12:28:43 2001
>Received: (from uucp@localhost)by uucphost.mcs.net (8.11.1/8.11.1) with UUCP id f1DKSgK10088;Tue, 13 Feb 2001 14:28:42 -0600 (CST)(envelope-from rpg400-l-owner@midrange.com)
>Received: from localhost (mail@localhost)by linux.midrange.com (8.9.3/8.8.7) with SMTP id PAA11009;Tue, 13 Feb 2001 15:05:19 -0600
>Received: by linux.midrange.com (bulk_mailer v1.13); Tue, 13 Feb 2001 15:05:16 -0600
>Received: (from majordom@localhost)by linux.midrange.com (8.9.3/8.8.7) id PAA10929for rpg400-l-outgoing; Tue, 13 Feb 2001 15:05:10 -0600
>Received: (from uucp@localhost)by linux.midrange.com (8.9.3/8.8.7) with UUCP id PAA10907for RPG400-L@midrange.com; Tue, 13 Feb 2001 15:05:07 -0600
>Received: from mail.lifecare.to ([208.153.226.8])by uucphost.mcs.net (8.11.1/8.11.1) with ESMTP id f1DJsUI02955for ; Tue, 13 Feb 2001 13:54:31 -0600 (CST)(envelope-from joe_montes@lifecare.to)
>Received: from jm0383 ([207.137.57.195]) by mail.lifecare.to (Post.Office MTA v3.5.3 release 223 ID# 621-67463U300L200S0V35) with SMTP id to for ; Tue, 13 Feb 2001 11:54:30 -0800
>From rpg400-l-owner@midrange.com Tue Feb 13 12:28:44 2001
>Message-ID:
>X-Priority: 3 (Normal)
>X-MSMail-Priority: Normal
>X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2910.0)
>Importance: Normal
>X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
>Sender: owner-rpg400-l@midrange.com
>X-List-Name: RPG/400 Discussion Mailing List (RPG400-L@midrange.com)
>
>Hello to all,
>
>Does anyone know if a solution exists for the following situation.
>I want to run a query during the night and retain the date prior to midnight
>(and the date changing). For example, on 01/31/2001 at 11:30pm a batch job
>query "TEST1" executes. The date on the headings is 01/31/2001. Next, on
>02/01/2001 at 12:30am a batch job query "TEST1" executes. The date on the
>headings must remain 01/31/2001. I have tried using the job date but no
>luck. I appreciate any assistance.
>
>Venu, at LifeCare.
>
>
>+---
>| This is the RPG/400 Mailing List!
>| To submit a new message, send your mail to RPG400-L@midrange.com.
>| To subscribe to this list send email to RPG400-L-SUB@midrange.com.
>| To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner/operator: david@midrange.com
>+---

---

Get your FREE download of MSN Explorer at http://explorer.msn.com
+--- | This is the RPG/400 Mailing List! | To submit a new message, send your mail to RPG400-L@midrange.com. | To subscribe to this list send email to RPG400-L-SUB@midrange.com. | To unsubscribe from this list send email to RPG400-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +---

****************************************************************
Kevin M Howcroft                http://www.kmtcinc.com
AS/400 Technical Consultant     Voice:407.830.5960
kevinh@kmtcinc.com              Fax: 407.650.2638