|
Let me just say...I have spent almost the entire day trying to learn as much as I can about Crystal Reports.
Ok, here's what I want. I have a lot of Variables in my Database Fields (over 50). Most of these fields have values of 1 or 0. In the report I would like it to say TRUE or FALSE to correspond to those values. I have tried using the Formula Fields...but was only able to get one field at a time...like...
if {Variables.value1} = "1" Then
Formula = Chr(254)
else
Formula = Chr(168)
End If
This formula makes checkboxes that I can use to show 0 or 1 as true (checked) or false (not checked).
Ideally I would be able to use this formula for all my fields...but obviously can't because it is field specific. Using the CurrentFieldValue is supposed to make it a universal formula...but I haven't been able to get that to work.
ANY IDEAS?!?!
| 
