SQL expression Compile issue

[RustyAfro]

CR XI R2
Oracle 9

Hi everyone,

I am trying to make a simple SQL expression against a database. When I click ok, Crystal does a check against the server and Crystal hangs for hours until I receive an error about a temp table being out of space. I unchecked "Compile SQL Expressions" thinking that would help but the same thing occurs. Is there anyway to force crystal to not compile the SQL Expression so that I can save it?

"MDC304_MED_CTRL_DIMSN"."CLM_ID" || CAST("MDC350_RH_EVT_FACT"."PAID_AMT" AS CHAR(10))

On a side note, I want to just use CHAR("MDC350_RH_EVT_FACT"."PAID_AMT") but Crystal sees the CHAR I think as a reserved word (since it highlights blue) and gives a "Missing Expression" error when it tries to compile.

 

[RustyAfro]

One correction, I was thinking db2 with the CHAR function. TO_CHAR is oracle so please disregard the side note.

One workaround to my issue is to just do the CAST in the SQL Expression and concatenate the other field to the SQL Expression in a seperate formula "whilereadingrecords".

Still, if there is a way to force CR XI to not compile (as the option states it shouldn't) that would be better.

 

[lbass]

You need parens around the whole thing, and I think you can use to_char() as in:

("MDC304_MED_CTRL_DIMSN"."CLM_ID" || to_char("MDC350_RH_EVT_FACT"."PAID_AMT" ))

I'm assuming both tables are in your report and are linked in some way.

-LB