I'm converting Crystal 8.5 reports to Crystal XI (11.0.0.1282). Most convert without issue. However, in some reports the selection criteria contains parameters that are set equal to a wild card value (*) when the parameter value is set to "any" or "all". Otherwise, the parameter is set to the matching field value in the database.
Here's the edited selection criteria from one of these reports:
(If {?Org. Type} = "Any value" then ADDRESS.TYPE} like "*"
else {ADDRESS.TYPE} = {?Org. Type}) and
(If {?County} = "Any value" then {ADDRESS.COUNTY} like "*"
else {ADDRESS.COUNTY} = {?County}) and
(If {?Township} = "Any value" then {ADDRESS.TWNSHP} like "*"
else {ADDRESS.TWNSHP} = {?Township}) and
{VW1_ORG_ADDRESS.ZIP} = {?Zip } and
(If {?Geo Code} = "Any value" then {ADDRESS.GEO_CODE} like "*"
else {VW1_ORG_ADDRESS.GEO_CODE} = {?Geo Code}) and
(If {?Flag} = 'Yes' then {ADDRESS.FLAG} = '1'
else If {?Flag} = 'No' then IsNull ({ADDRESS.FLAG}) or {ADDRESS.FLAG} = '0'
else If {?Flag} = 'All' then {ADDRESS.FLAG} like "*");
We are trying to move forward with Business Objects XI and without this resolved, most of our production reports will provide bad data.
I've already tried playing with null handling options in both Report Options and Options.
I would keep these in 8.5 if I could. But, these reports also depend on a custom function which now requires a connection to the repository.
Any help is appreciated.