Just curious why you went the SQL route instead of using Crystals functions and grouping capabilities as a means to display the data in the desired format?

Seems as though if you returned a simple result set, Crystal could have done the same job with less of your time spent getting it to work in SQL...just curious.