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

rbuser

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

nicocizik

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?

rbuser

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
reason.

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

nardmoseley

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
www.digital-metaphors.com