Report Builder (expression builder syntax)

[*Ludwig*]

I'm trying to create a calculated field that will compare the values from one
query field and depending on the values will assign a value to the calculated
field. In crystal reports here is the syntax I used.

IF ({AttendDet.AttendCode} = 1 OR {AttendDet.AttendCode} = 2) THEN
{AttendDet.TotAdjTime}
ELSE
0

[*Ludwig*]

Bump...

[Dean Harmon]

This is pretty straightforward CF script, but something to this effect
should work

iif((query.AttendCode EQ 1) OR (query.AttendCode EQ 2), query.TotAdjTime, 0)

Dean

"*Ludwig*" <webforumsuser@macromedia.com> wrote in message
news:d04s32$7g1$1@forums.macromedia.com...

> I'm trying to create a calculated field that will compare the values from

one

> query field and depending on the values will assign a value to the

calculated

> field. In crystal reports here is the syntax I used.
>
> IF ({AttendDet.AttendCode} = 1 OR {AttendDet.AttendCode} = 2) THEN
> {AttendDet.TotAdjTime}
> ELSE
> 0
>

[jerm]

Dean's example works for an integer value, but I need something like this to
return strings instead. I have a list of first and last names with an optional
alternate first name (for shortened names and nick-names). I want to
concantinate the alternate name on to the original name with brackets
surrounding the alternate name. I could do this in my query, but I am
evaluating the flexibility of the report writer and this should be a fairly
simple task to do - if I could figure out how to get it to work. If you take
Dean's example and use strings, you'll get an error because it thinks the
string is a variable. I've tried single quotes, double quotes, no quotes, and
evaluate() without any success. Have I run across yet another bug, or am I
doing something wrong. My code for trying this out is: iif((query.Emp_AltFname
EQ '') OR (query.Emp_FName EQ 'Dennis'), 'Testing', 'Failed')

[jerm]

Found the issue with strings. The DE() function needs to be used. Working example is: iif((query.Emp_AltFname EQ '') OR (query.Emp_FName EQ 'Dennis'), de('Testing'), de('Failed'))