[RBASE-L] - Re: PHP date

[jan johansen]

Razzak,

Thank you for the clarification and detailed instructions.
As always keep up the good work.

Jan
 


-----Original Message-----
From: "A. Razzak Memon" <raz...@rbase.com>
To: rbase-l@rbase.com (RBASE-L Mailing List)
Date: Thu, 03 Jun 2010 10:18:49 -0400
Subject: [RBASE-L] - Re: PHP date


At 09:49 AM 6/3/2010, jan johansen wrote:

>However I discovered this does work
>WHERE CustomerID = $custid AND DueDate = .#DATE


Jan,

Did you know that R:WEB Reports 4.0, R:Web Report 8.0, R:Web Repots 9.0 
(32),
and R:Web Reports 9.0 (64) will accept all R:BASE "System" as well as 
"Global"
Variables when defining the WHERE Clause?

-- Example 01
PRINT reportname WHERE colname = .vGlobalVar1 ORDER BY colname DESC +
    OPTION PDF +
    |FILENAME .vFileName +
    |SHOW_CANCEL_DIALOG OFF +
    |TITLE PDF Report Property Title Here ... +
    |SUBJECT PDF Report Property Subject Here ... +
    |AUTHOR PDF Report Property Author Here ... +
    |KEYWORDS PDF Report Property Keywords Here ...
RETURN
-- Where vGlobalVar1 & vFileName are global variables passed via PHP script

-- Example 02
PRINT reportname WHERE datecolname = .#DATE +
    OPTION PDF +
    |FILENAME .vFileName +
    |SHOW_CANCEL_DIALOG OFF +
    |TITLE PDF Report Property Title Here ... +
    |SUBJECT PDF Report Property Subject Here ... +
    |AUTHOR PDF Report Property Author Here ... +
    |KEYWORDS PDF Report Property Keywords Here ...
RETURN
-- Where #DATE (Current Date) is R:BASE System Variable
-- Where vFileName is a global variable passed via PHP script

For more examples and live presentation: http://www.rwebreports.com

Have fun!

Very Best R:egards,

Razzak.