sql expression showing boolean result??

[Guest_imported]

Hi,

I tried to use a sql expression and the result diplayed boolen values instead of the actual data is there any thing I can do to get actual data .. for eaxmple I wrote an expression for a field name =3 so its displaying true or false but I want real values.. please help!!

thanks

 

[MalcolmW]

...displaying true or false ...
The key word is displaying - in the situation you describe, a boolean value is not stored in the database, but is the logical result of sql expression.
Typically, boolean fields are displayed as True/False, Yes/No, 1/0. To change how a boolean is displayed, format the expression to the appropriate display method (pop down menu, format etc...) [sig][/sig]

 

[kenhamady]

If you put an equal sign in any expression you are going to get a boolean expression.

Cut and paste your expression in your next post, and explain what the fields should print in the column instead of the boolean. [sig]<p>Ken Hamady-

http://www.kenhamady.com<br><a

href=

http://www.kenhamady.com/>Crystal

Reports Training by Ken Hamady</a><br>[/sig]