boolean problem : Crystal XI 1

[ianholmes]

My Report accesses an SP rather than a table.
The field I need is defined {FieldName}: Boolean
When I move it directly to Detail, the values returned are either "True" or "False".
I need to change this into "Yes" or "No".
I have tried creating a Formula with

If {{SPName};1.{FieldName}} = "False" then
"No"
Else
"True"
but get "A boolean is required here" error message against "False".

Can someone please give me the correct syntax for such boolean handling above ?

Many thanks

 

[dgillz]

get rid of the quotes around False.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[ianholmes]

Many thanks dgillz !