Link tables using field that are different cases

[GCL2007]

I'm trying to write a Crystal Report against an Oracle database. I want to link two tables on a field which is the same however the field data is uppercase in one and lower-case in the other table. I can't seem to link the tables. Is there something I can do? CR 11

 

[lbass]

You could use a command as your datasource. Then in the From clause you can link like this:

ucase("tableA"."field") = "tableB"."field"

If the ucase creates an error, try:

{fn ucase("tableA"."field")} = "tableB"."field"

-LB

 

[lbass]

PS. If you don't want to use a command, you could also add one of the tables in a subreport that is linked on a formula or SQL expression that uses ucase or lcase.

-LB