Record Selection in Japanese not pulling the correct records.

[stacy_cramer]

Hello,

I am using Crystal XI running off of a Remedy SQL Database that has Japanese data in the records. When I place the following criteria in the Record Selection, I pull no records. But, If the put the criteria with the japanese criteria in the Group Selection formula, I get the records that I want but then many of my formulas are adding up all the records.

{HPD_HelpDesk_VW.Severity} in ["1","2"] and

{HPD_Affected_Organizations.Organization} like "ジブラルタ"

How can I get Crystal to recognize the japanese criteria in the Record Selection criteria?

Any help would be appreciated.

Thanks, Stacy

[stacy_cramer]

Hello,

I am using Crystal XI running off of a Remedy SQL Database that has Japanese data in the records. When I place the following criteria in the Record Selection, I pull no records. But, If the put the criteria with the japanese criteria in the Group Selection formula, I get the records that I want but then many of my formulas are adding up all the records.

{HPD_HelpDesk_VW.Severity} in \"1\",\"2\" and

{HPD_Affected_Organizations.Organization} like "ジブラルタ"

How can I get Crystal to recognize the japanese criteria in the Record Selection criteria?

Any help would be appreciated.

Thanks, Stacy