Skip to Content
Jul 15 at 07:15 AM

Old or possibly corrupt data being read from the Database?

125 Views Last edit Jul 14 at 07:21 PM 2 rev

A Crystal Report recently came across my desk where a date field wasn't matching up with what the User had just entered and viewed in the application. Both the application and the Crystal Report were attached to the same Database Source and were both displaying the same field, but for whatever reason the Crystal Report was displaying an incorrect date. After tearing the entire report apart trying to figure out what was causing the issues I realized that the Field in the Table was simply not pulling back valid data after displaying nothing else but the one field, it was either old or corrupt. I ended up solving the issue by removing the table and re-adding it and the field, but the question remains... why did it happen? Has anyone had any issues similar to this and was able to figure out what was the cause?