Carriage returns in selection formula are causing errors

27 Views

Hello,

I have an application which uses the BOE XI R2 web services sdk to schedule a report. my client recently upgraded from BOE 12.0 to 12.4 and now their reports are failing due to the following error:

Error in File ~tmpb3c6fb4ac4f2c0.rpt: Error in formula Record_Selection: '{MID_MEM_IDENTIFIER.MID_MIT_CODE} = "SP-SSN" and §d; {TAU_TREATMENT_AUTHORIZATION.TAU_UID} = {?TAU_UID} and §d; {TST_TCM_STATUS_HISTORY.TST_AST_CODE} in ["A4", "A4AUTO"];' A number, currency amount, boolean, date, time, date-time, or string is expected here. Details: errorKind

the actual formula in the report looks like this:

{MID_MEM_IDENTIFIER.MID_MIT_CODE} = "SP-SSN" and

{TAU_TREATMENT_AUTHORIZATION.TAU_UID} = {?TAU_UID} and

{TST_TCM_STATUS_HISTORY.TST_AST_CODE} in ["A4", "A4AUTO"];

It appears that the carriage returns inserted in the formula during design time are being evaluated correct as "§d;" and then failing. My code does examine or process the selection formulas or any formulas of the report. I have told my clients to remove the carriage returns from all the formulas in all their reports but this is not a desirable workaround because they have 400(+) reports.

Any ideas on how I can resolve this?

Thanks,

Coleen