>I have SET REPORTBEHAVIOR to 90 and it's working fine now since I have SET COMPATIBLE OFF (using LIKE() function as LIKE(someexpression, ALLTRIM(someexpression)).
>
>But I have that second problem which I don't know how to solve which is:
>In reports in 8.0 I have Numerical field with Format: ##,###,###,###,###,###.##
>In reports those fields are sometimes smaller because of limited space and I check Strech with overflows in order to appear normal, otherwise it would appear asterisk **,***,***,***,***,***.**
>In 8.0 those fields were working fine but in 9.0 those fields are stretching into another line expanding band making it taller which is totally unexpected for me.
>How to fix that so that works fine in 9.0?
I think the only way to fix this problem is to slightly expand the field.
If it's not broken, fix it until it is.
My Blog