[RBASE-L] - Re: PHP date

[A. Razzak Memon]

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.