Boolean values => strings ?

[proctor]

I'm a beginner at Crystal Report (ver. 8.0), and I have a problem. I wan't to write som strings in the report, which contains text that corresponds to some boolean value (from a access database).

That is, I have made something like this.

Hours | True | False | Total
---------------------------------------
Project 1 | 5.00 | 0.50 | 5.50
Project 2 | 10.50| 9.00 | 19.50
---------------------------------------
Total | 15.50 | 9.50 | 25.00
---------------------------------------

Where True/False indicates wether the hours spend is debit og nonDebit. Now I would like to write this instead of true false, that is.

Hours | Debit | nonDebit | Total
---------------------------------------
Project 1 | 5.00 | 0.50 | 5.50
Project 2 | 10.50| 9.00 | 19.50
---------------------------------------
Total | 15.50 | 9.50 | 25.00
---------------------------------------

But how can I do this ?
Is there anyway I can make a string depend on a boolean value ?

Thanks

Jesper (Denmark)

 

[proctor]

Never mind I found the solution myself.

If anyone is interrested, here it is :
I Made a formula @debit, like this
if({field}) then "debit" else "nonDebit"
And then I used @debit as column in a cross-tab, instead of the original values from the database.

Thanks (me)