Charles:
The only problem is that if I use the CLS before he report, it defeats the
purpose of the message, if I place it after the report, the message is still
there in front of the report. I am sure that there is an obvious solution
that I am overlooking.
Javier,
 
Javier Valencia, PE
President
Valencia Technology Group, L.L.C.
14315 S. Twilight Ln, Suite #14
Olathe, Kansas 66062-4578
Office (913)829-0888
Fax (913)649-2904
Cell (913)915-3137
================================================
Attention:
The information contained in this message and or attachments is intended
only for the person or entity to which it is addressed and may contain
confidential and/or privileged material.  Any review, retransmission,
dissemination or other use of, or taking of any action in reliance upon,
this information by persons or entities other than the intended recipient
is prohibited. If you received this in error, please contact the sender and
delete the material from all system and destroy all copies.
======================================================
 
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Charles Parks
Sent: Wednesday, July 07, 2004 10:16 AM
To: RBG7-L Mailing List
Subject: [RBG7-L] - RE: Displaying status message
 
CLS will clear a pause 3 message.
 
Another possibilty since there is more than one report is to print them to a
PDF document and use the Variable Web Broswer component to open the document
up by placing the filename into the variable then buttons can be placed on
the form so the user can pick any of the four documents to look at.
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Javier Valencia
Posted At: Wednesday, July 07, 2004 9:40 AM
Posted To: RB7-L
Conversation: [RBG7-L] - Displaying status message
Subject: [RBG7-L] - Displaying status message
I have to print a set of reports and I use the following snippet of code:
-- Print report 1
PRINT inv_report_cover WHERE +
inv_no = .vinv_no ORDER BY inv_no ASC +
OPTION SCR|Window_State MAXIMIZED
 
-- Print report 2
PAUSE 3 USING 'GENERATING SUMMARY REPORT...' CAPTION 'Invoice Utility'
PRINT invoice_report WHERE +
equip_fleet = .vequip_fleet AND fwo_stat = 'C' AND +
wo_actual_end BETWEEN .vinv_start_date AND .vinv_end_date +
ORDER BY fwo_no ASC +
OPTION SCR|Window_State MAXIMIZED
 
-- Print report 3
PAUSE 3 USING 'GENERATING EQUIPMENT FUEL REPORT...' CAPTION 'Invoice
Utility'
PRINT fuel_invoice WHERE equip_fleet = .vequip_fleet AND +
fuel_date BETWEEN .vinv_start_date AND .vinv_end_date +
ORDER BY fuel_location ASC, fuel_date ASC, fuel_time ASC +
OPTION scr|window_state maximized
 
-- Print report 4
PAUSE 3 USING 'GENERATING OTHER FUEL REPORT...' CAPTION 'Invoice Utility'
PRINT fuel_invoice_other WHERE equip_fleet = .vequip_fleet AND +
fuel_date BETWEEN .vinv_start_date AND .vinv_end_date +
ORDER BY fuel_location ASC, fuel_date ASC, fuel_time ASC +
OPTION scr|window_state maximized
 
The first report prints very quickly but the following reports may take a
considerably longer time depending on data. After I close the current report
and while the next report is being generated, I want to display a message
informing the user that the report is being generated and I want the message
to go away when the report displays. I am pretty sure that the code above
used to work but now, when the next report displays, the message remain on
the screen, in front of the report. I have tried using several variations of
the PAUSE command with no luck. I am obviously overlooking something very
simple, or I may be using the wrong command to display the message, any help
will be greatly appreciated.
Javier,
 
Javier Valencia, PE
President
Valencia Technology Group, L.L.C.
14315 S. Twilight Ln, Suite #14
Olathe, Kansas 66062-4578
Office (913)829-0888
Fax (913)649-2904
Cell (913)915-3137
================================================
Attention:
The information contained in this message and or attachments is intended
only for the person or entity to which it is addressed and may contain
confidential and/or privileged material.  Any review, retransmission,
dissemination or other use of, or taking of any action in reliance upon,
this information by persons or entities other than the intended recipient
is prohibited. If you received this in error, please contact the sender and
delete the material from all system and destroy all copies.
======================================================
 

<<attachment: winmail.dat>>

Reply via email to