Many Thanks, I indeed built the report using a Crystal Cross-tab & everything worked out just fine.

Thanks to all who advised.