Old or possibly corrupt data being read from the Database?

[former_member757801]

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?

Thanks

[former_member751964]

Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with Community Q&A, as the overview provides tips for preparing questions that draw responses from our members.

For example, you can:

- outline what steps you took to find answers (and why they weren't helpful)

- share screenshots of what you've seen/done

- make sure you've applied the appropriate tags

- use a more descriptive subject line.

The more details you provide, the more likely it is that members will be able to respond. Feel free to also take our Q&A tutorial Q&A tutorial

Should you wish, you can revise your question by selecting Actions, then Edit.

By adding a Picture to your profile you encourage readers to respond.

[former_member11696 · Accepted solution]

Sometimes the File system will "flip" a bit in the rpt file causing problems.

Sometimes the DB Client may do it also after updates to the client or DB.

Hard to say for sure, there are no tools to debug a bad report file.

Depending on the Client used you could enable CRLogger, crystals database logging component, or ODBC Trace or an OLE DB trace, they may catch the actual error.

Sometimes the Date format set on the users PC may be different than when the report was designed.

Date field are finicky most times due to lots of conversions/formatting routines in both the DB Client, the OS and CR.