Supresing the word False from report results

[sanjaych]

I have a report that is returning True and False values from a tick box field within the database. I only want the report to display the true values. The problem is that I have 12 tick boxes in a row and I can't get the formula correct in selection editor without skewing the report results.

 

[lbass]

Is there one field or 12 fields? Please show some sample data (for several records) so we can see how this field(s) displays in the detail section. Also, please show what you tried for a record selection formula and explain in what way the results were skewed.

-LB

 

[Madawc]

If it's just display, you can have something like

If {your.field} = "True" then "True" else ""

Also check - are these string fields or 'boolians', which display as True or False.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP

 

[sanjaych]

If it is a string value will your formula change?

 

[lbass]

Madawc's formula assumes that it is a string, but it is not a selection formula.

Please respond to my previous post.

-LB

 

[sanjaych]

I have sorted it - Madawc's formula worked, I was applyinhg the formula via the selection editor which is why it was not working for me.

When i add a formula field to the report the formula works fine.

All sorted thanks.