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.