At 09:02 AM 9/23/2004 +0100, Alastair Burr wrote:
With forms there is the ability to use a CLS in an On-After-Start EEP. Is there anything similar that can be done with reports?
Along with Sub-Reports, Secure PDFs and more, the R:BASE 7.5 for Windows Report Designer, to be unveiled at the Fall 2004 R:BASE Developers's Conference, also includes the following features as Report Actions:
. Before Preview . After Preview . Before Generate . After Generate
http://www.rbase.com/rbg75
The following report action can be used to achieve the above goal:
Example:
01. CONNECT RRBYW10 (R:BASE 7.5 Sample Database)
02. REPORT CustContInvoices (Sub-Report based on 5 tables)
03. Report Designer | Main Menu | Report | Actions | Before Generate
-- Custom Embedded EEP
CLS
SET VAR vMsg = +
((CHAR(009))&'Preparing Report: CustContInvoice'+(CHAR(009))+(CHAR(013))+ +
(CHAR(013)) + +
(CHAR(009))&'Please Wait ...'+(CHAR(009)))
PAUSE 3 USING .vMsg +
CAPTION ' Reports and Sub-Reports' +
ICON APP +
OPTION BACK_COLOR WHITE +
|MESSAGE_COLOR WHITE +
|MESSAGE_FONT_COLOR GREEN
RETURN
04. Report Designer | Main Menu | Report | Actions | After Generate
-- Custom Embedded EEP
CLS
RETURN05. To print 5 Table Sub-Report, use the following code:
PRINT CustContInvoice +
ARRANGE InvoiceHeader BY TransID ASC, +
ARRANGE InvoiceDetail BY DetailNum ASC, +
ARRANGE Employee BY EmpLName ASC, +
ARRANGE Contact BY ContLName ASC +
ORDER BY CustID +
OPTION SCREEN |ZOOMPERCENT 80 |WINDOW_STATE MAXIMIZEDImagine the possibilities!
Very Best R:egards,
Razzak.
