I am pretty new to Crystal Reports so this may have a simple answer.
I am running a zip code report for all patients in a clinic I work for. They want a count of the number of patients in each zip code found in the database. I have the report that lists out the zip codes and gives a count for each. However, some zip codes are just 5 digits while others have "5-4" or even the full 9 digits without the dash. So I could potentially show:
97681 (total: 500)
97681-1234 (total: 1)
976812345 (total: 1)
Instead of it listing that way, I'd rather it just show:
97681 (total: 502)
Is there a way to tell it that I only want to view the first 5 numbers of the zip code and to strip everything else off of the end...and then group them and show me the counts? Does that make sense?
Oh, and I'm on Crystal 8.5.
Thanks!
Elizabeth
I am running a zip code report for all patients in a clinic I work for. They want a count of the number of patients in each zip code found in the database. I have the report that lists out the zip codes and gives a count for each. However, some zip codes are just 5 digits while others have "5-4" or even the full 9 digits without the dash. So I could potentially show:
97681 (total: 500)
97681-1234 (total: 1)
976812345 (total: 1)
Instead of it listing that way, I'd rather it just show:
97681 (total: 502)
Is there a way to tell it that I only want to view the first 5 numbers of the zip code and to strip everything else off of the end...and then group them and show me the counts? Does that make sense?
Oh, and I'm on Crystal 8.5.
Thanks!
Elizabeth