Crystal returning incorrect records

[Former Member]

I have a report that contains one table and one subreport. When the report is refreshed it randomly mixes records together. This error occurs in the container report only, I have even removed the sub report and refreshed with the same results.

For example the report may contain 25 people (records), each record shows the persons name, address, Login code and Password code. I should always see Jane Doe with her address and log in codes listed together, then Joe Smith with his address and login codes, etc. However, I end up getting Jane Doe with all of her correct information and then Jane Doe again with Joe Smith's address and login codes. If I refresh again, it will change to different peoples records being mixed up. Each refresh comes back with different results.

[Former Member · Accepted solution]

Sounds like a linking issue.

In your database expert, check how the tables are linked up. You could be facing a "one to many" linkage.

I suggest working backwards.

Create a copy of your report. Start removing the tables from your report to see if the # of records start diminishing. This will help you understand what's happening.

Regards,

Zack H.

[Former Member · Accepted solution]

Thank you Zack, I had initially thought that it would be a link issue as well, until I realized that this report was built using only one table. The only linking that is in the report is the subreport link, which I checked and even removed the sub report all together to see if the problem resolved itself, but it did not.

I also located another report using the same table and sub report. I was able to get this report to work perfectly, which is why I am so baffled at the original reports issue. The two reports appear to be identical. At this point I have solved the users issue by using the second report to replace the broken one, but I would really like to understand what is causing the issue for future use.

[Former Member · Accepted solution]

I have had similar problems with the default viewer in Infoview. To solve it, I had to print in a different format (PDF). In the developer, I could not resolve the issue, and submitted a ticket which was never resolved.

Sounds like you may have a similar issue. BO's solution was to recreate the report from scratch.