In Crystal Reports XI, I have a basic field (which is an array with upto 5 elements.) The field {geography} can contain upto 5 regions per Account. For example,
Acct1 may be in {geography} Asia, NtAmerica, Europe
Acct2 may be in {geography} Nt America
Acct3 may be in {geography} NtAmerica, Asia, Europe, Other
How do I group the data by the unique region (and not end up with a bulk grouping of: Asia, NtAmerica, Europe on one line?? make sense?
So, I need to separate each element, and also group by each unique element. Is this possible?
Acct1 may be in {geography} Asia, NtAmerica, Europe
Acct2 may be in {geography} Nt America
Acct3 may be in {geography} NtAmerica, Asia, Europe, Other
How do I group the data by the unique region (and not end up with a bulk grouping of: Asia, NtAmerica, Europe on one line?? make sense?
So, I need to separate each element, and also group by each unique element. Is this possible?