Grouping-Case Sensitive
Grouping-Case Sensitive
Grouping seems to be case insensitive, we need to group case sensitively. IOW, Ohio would be grouped seaparately from ohio. Is that possible?
=> RE: Grouping-Case Sensitive
Here is the info from the Help file:____By default, Report Designer does not distinguish between upper- and lower-case letters when sorting or comparing character data in Database Sort Order and Group Order operations, queries, and calculations (that is, these operations are case insensitive).__ __To change this default behavior for sorting and comparing character data, use any text editor to edit RRW.SRT, the file that controls Report Designer_s case sensitivity. This file resides in the Report Designer program directory. Directions for editing the file are contained within the file itself.____Note that database relations are not affected by the case sensitivity setting in RRW.SRT. Database relations that use character linking fields are always case sensitive. ______Kathleen__R&R Support