R:azzak,

Looks like I had the right idea, Claudine had the right syntax and you had
the right solution; great minds think like. This command is exactly what I
need. It sure seems like R:eXtreme will blow our socks off...again...

Javier,

Javier Valencia
913-915-3137


-----Original Message-----
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of A. Razzak
Memon
Sent: Wednesday, September 24, 2008 6:37 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Exiting a Report

At 05:43 PM 9/24/2008, Javier Valencia wrote:

>I have a confidential report that it is called from many locations
>within an application. Rather than add code to check if the user
>has the permission to generate the report before the report is
>started, I would like to place the code in the report itself
>(Before generate). Is there a way to stop the report with code
>from the "before generate" EEP? I have tried CLOSEWINDOW but it
>does nothing and the report continues to execute...any ideas?


At 06:21 PM 9/24/2008, Claudine Robbins wrote:

>Looks like you need a PROPERTY REPORTNAME 'ABORT'


Claudine,

You must have some inside scoop on this particular enhancement
implemented in R:BASE eXtreme (version 9.0), to be officially
unveiled at the 10th Anniversary R:BASE Developers' Conference.

http://www.rbase.com/conference/  (October 17 - 20, 2008)

This conditional PROPERTY to generate and/or abort the actual
report may be used as "Before Generate" action for reports.

Syntax: PROPERTY REPORT reportname 'ABORT'

Example 01:

-- Start here ..
-- "Before Generate" Action for Reports
-- Supported Version: R:BASE eXtreme 9.0.1.11017 or higher
-- Validate User Access
    CLEAR VAR vPassword,vCaption,vEndkey
    SET VAR vPassword TEXT = NULL
    SET VAR vCaption TEXT = 'Print Payroll Master Report'
    SET VAR vEndKey TEXT = NULL
LABEL GetPassword
    CLS
    DIALOG 'Enter Password to Print Payroll Master Report' +
    vPassword=28 vEndKey PASSWORD +
    CAPTION .vCaption +
    ICON APP +
    OPTION TITLE_FONT_COLOR BLACK +
    |BUTTON_OK_CAPTION &Accept +
    |BUTTON_CANCEL_CAPTION &Cancel +
    |THEMENAME WaterColor
IF vEndKey = '[Esc]' THEN
    GOTO GetPassword
ENDIF
IF vPassword IS NULL OR vPassword <> 'xxxxxxxxxx' THEN
    PAUSE 2 USING ' Invalid or Missing Password!' +
    CAPTION .vCaption ICON STOP +
    BUTTON 'Click here to enter password again ...' +
    OPTION MESSAGE_FONT_NAME Verdana +
    |MESSAGE_FONT_COLOR RED +
    |MESSAGE_FONT_SIZE 10 +
    |MESSAGE_FONT_BOLD OFF +
    |BUTTON_COLOR WHITE +
    |BUTTON_FONT_COLOR GREEN +
    |THEMENAME WaterColor
    PROPERTY REPORT ConfidentialPayrollMaster 'ABORT'
ENDIF
LABEL Done
CLEAR VAR RBTI_%,iv%,vPassword,vCaption,vEndkey
RETURN
-- End here ..

Very Best R:egards,

Razzak.


Reply via email to