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
    RETURN

05. 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 MAXIMIZED

Imagine the possibilities!

Very Best R:egards,

Razzak.



Reply via email to