Use of decode in v8

[birdman5]

I have just switched over from Actuate, and i am amazed to find that the DECODE function cannot be used in the SQL expression field in Crystal v8.

I am missing something, or is that really the case?

Are there any other standard functions that cannot be used?

 

[synapsevampire]

Decode is an Oracle function, not Crystal...

Decode can be used in a SQL Expression in Crystal, I just created one.

Rather than explaining what doesn't work, try posting the offending formula and any error messages.

-k

 

[birdman5]

apologies, apologies - i have it working now. I was using standard IIF syntax (a=1,a,b) instead of (a,1,a,b)

if i had a penny...

i think the real problem is just getting used to the differences between actuate and crystal.

(p.s. is there anyway to delete a post?!)

-p

 

[synapsevampire]

Nae worries over the post, it might help another.

-k