General information
Category:
Reports & Report designer
>Yes, you are right! I have found out that SET COMPATIBLE ON is causing problems.
>I use LIKE() function as filter for report in REPORT FORM command.
>Is there some solution to that or do I have to make some specific code?
>
>SP2 will address the *known* issues in the Report*.Apps that occur when SET COMPATIBLE is ON or DB4. Until then, you should SET COMPATIBLE OFF if possible.
>
>Unless you are also getting your error when SET REPORTBEHAVIOR 80, in which case this SP2 patch won't make a bit of difference.... but I think I understand from your earlier message that you only see this in the new-style reporting, right?
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?
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only