Home RAP
New Blog Posts: Merging Reports - Part 1 and Part 2

Use parameter in SQL Editor

Goodday everybody,

I hope i have a simple question. I'm trying to use a parameter in sql editor mode. But the editor gives an error when confirming. Ive tried using () whit the parameter but is does not work. Can anyone give me a push in the right direction?

SELECT REP.PROJECT_NUMBER
, REP.PROJECT_DESC
, REP.PHASE_NUMBER
, REP.PHASE_DESC
, REP.INVOICE_DATE
, sum(iif(REP.invoice_date < :Date, REP.AMOUNT, 0)) as BEFORE_AMOUNT
, sum(iif(REP.invoice_date >= :Date, REP.AMOUNT, 0)) as AFTER_AMOUNT
from VW_REP_PHASE_INVOICE_AMOUNT REP





Comments

  • Hi Edward,

    Please update your profile with the registered email address for the license.

    We only have resources to provide tech support to Delphi developers with an active RB license.


    Best regards,

    Nard Moseley
    Digital Metaphors
    www.digital-metaphors.com
Sign In or Register to comment.