How do you change Crystal Enterprise Options 1

[Lseveron]

Hiya

My formula worked fine through Crystal Developer AFTER I had gone File --> Options --> Fields --> Number --> Number and selected (1123) rather then system default Number Format

the formula is translating a BitField into a Boolean in the following way

numberVar i := {Bitfields};
numbervar j := 16;
stringVar x := totext(i mod 2);
while ( j > 0 ) do (i:=truncate(i/2,0);x:= (totext(i mod 2)) + x;j:=j-1;
if x[4]='0' then 'Unlocked' else 'Locked'

The problem is after putting it into place running through Crytal Enterprise every record ends up being 'Unlocked' I belive this is because I can't find out where to change that option through Crystal Enterprise as mentioned before
and making the bitfield have 2 decimal places, although could also be anything else any help on this would be greatly appreciated.

 

[lyanch]

Ah i think I see what you need.

Try changing totext(i mod 2) to totext(i mod 2, "#&quot

the "#" tells it to not add decimals, commas etc so that 10010001 comes out as exactly that, not 10,010,001.00. I haven't followed your formula the rest of the way through, but anyplace you are trying to get rid of decimals, commas etc from your string can be removed.

Lisa