Can -9999 be used within calc field of type expression.

edited July 2011 in End User
In the designer on the data tab in the calc section i created a new item.
I changed it to the expression type. In the expression I filled it with a
case statement where I am using the -9999 number.
case when recid=-9999 then 0 else 1 end

It looks like reportbuilder is not replacing -9999 with the selected recid,
which it does in the where clause. Why is this not being replaced? Is this
special number only to be used in the where clause?

Luc Neville


  • edited July 2011
    Hi Luc,

    Which version of ReportBuilder and Delphi are you using? Also which
    database and DB connectivity are you currently using?

    The number -9999 is not used or known by any of the ReportBuilder data
    logic. Is the recid a field in your database that you would like to
    compare to the constant -9999? Are you able to send this SQL code
    directly to the DB (without ReportBuilder) and get a valid dataset?

    Best Regards,

    Nico Cizik
    Digital Metaphors
  • edited July 2011
    Aha, i made the wrong assumption that -9999 was a special parameter provided
    by report builder. I guess it's implemented by my company. I'll look into
    that. It should give me the information about how and at what point the
    value is being replaced.
    I just checked the code. The -9999 is only being replaced in the where
    clause . Not sure if restriction to the where clause is done with a certain

    the number -9999 is being replaced by the selected record's recid.

  • edited July 2011
    Please understand is the responsibility of the Delphi Developer to provide
    their end-users with tech support.

    These newsgroups are provided for Delphi Developers only. We do not provide
    tech support for end-users.

    Best regards,

    Nard Moseley
    Digital Metaphors

    Best regards,

    Nard Moseley
    Digital Metaphors
This discussion has been closed.