I am running Crystal Reports 11, and I have created a sales report (reporting from HQ database) to show sales for 3 different stores. The sales for 2 of the stores are correct, but the sales for the third store are completely overstated. I have isolated particular items, and compred the Crystal report sales with HQ sales and Store sales, and it is way out of whack. HQ and Store are the same (and correct), but Crystal show something completely different. I have even gone as far as drilling down on the Crystal Report to show the transactions that the items were supposedly sold on. When I go into RMS and check these transactions, they don't show that these items were sold on those transactions at all.
Any ideas as to why this is happening and what I can do to fix it?