Oracle 9i and SQL 7

[BlurredVision]

I have to create a couple reports that are compatible in both Oracle 9i and SQL 7. The only issue I've come upon is how boolean's are stored. Oracle will store them as 1/0, and SQL will store them as True/False.

I could convert them to one or another using a formula, but I was hoping there was a way of converting all boolean’s to one or another from within crystal setup (v10/XI)

Many Thanks, Brian

 

[BlurredVision]

Never mind.. It just clicked that booleans within oracle are stored as a number...

I just created this simple formula to handle it

BooleanVar Boo := CBool(ToNumber({BooleanField}));