Crystal Report pulling invalid users and incoreect substotal 1

[fredong]

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

 

[Naith]

Go to the Database menu, and select Verify Database. Then rerun the report.

Naith

 

[fredong]

I found out my own problem is that you have re modified the SQL statement on your scripts. just remember not to use the same field and update it twice because crystal does not like it even though it works on the backend.