Are linked fields case sensitive?

[shannonlp]

Hi,


I am trying to build a report that consists of three tables. Two of the tables that need to be linked are on fields that are different cases. Specifically, for ARCHIVE_TRANS.LOGIN_ID = ARCHIVE_USER.ARCHIVE_USER_ID, LOGIN_ID is lower case and ARCHIVE_USER_ID is upper case. I'm thinking that it is causing a problem because my report is returning results. Its only when I add a
field from the ARCHIVE_USER table, no results are returned.

As a workaround, I created a view for ARCHIVE_USER with the linked field being lower case. My report returns results. Does Crystal need linked fields to be the same case or is there a function in Crystal that allows you link on fields with different cases?

Any feedback would be greatly appreciated.

Thanks,
Shannon

 

[benmorton]

Shannon:
I would create a formula that turns one of the fields into uppercase. Put this in the formula:

uppercase(ARCHIVE_TRANS.LOGIN_ID)

Then you will have to manually put the links in the select expert... something like:
"formula" = ARCHIVE_USER.ARCHIVE_USER_ID

Ben