8.5 to XI upgrade problem

[TimmieLynn]

I have a report that was created in Crystal 8.5 in Crystal XI that prints a purchase order. When I first opened the report I updated the data sources from a Pervasive database to ODBC. That is the only changes I have made. In the details section I have a formula that looks like so:

IF {table1.field1}="USD"
THEN {table2.field1}
ELSE {table2.field2}

The formula prints on the first line but does work in any lines that follow. The problem did not occur in Crystal 8.5. When I instert any of the fields from the if statement directly into the report they will print on all lines. Any suggestions?

 

[synapsevampire]

Hmmm, not sure, something about connectivity altering the way a field is interpreted I'd guess.

Try:

IF not(isnull({table1.field1}))
and
uppercase({table1.field1}) = "USD" THEN
{table2.field1}
ELSE
{table2.field2}

If that works then it's either a null issue or a mixed vs. uppercase difference.

-k

 

[TimmieLynn]

Thanks for your suggestion, that seems to have worked.