I modified my store procedures and I am using Crystal Reports 8.0 to pull up the sales result and Group by the Salesperson fields. However it is pulling up the Salesperson that does not exist anymore and I compared the transactions with the crystal and my SQL 2000 backend results....My backend on that row of results is showing me the salesperson different from Crystal... Please help if anybody seen this problem. Thank you... It has worked before