Not sure anyone can help me out here but I am experiencing the following problem:
When running an SQL query using Crystal Reports via my program, I am losing the same records consistently across any report that would or should put this report record.
It runs fine up to record 2019017, then fine all the way to 2019076 - skips 2019077, 2019083, 2019091 and 2019102.
I am searching for any record number with a PET_LOAD_NUMB between '2019000' and '2019107'
The missing records have been verified to be present in the database. When I run the SQL in MSSMS all the records return fine, with no error.
Every report I'm running is missing the EXACT same 5 records. Any thoughts as to why?
Please be specific. Seriously would appreciate any helpful suggestions and hints of what to look for.