Crystal Report overstating sales

Posted by chenmau on October 19, 2009, 11:03 am

Please log in for more thread options

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?

Posted by Akber Alwani on October 20, 2009, 7:13 am

Please log in for more thread options

hi,
Send your crystal report so I can check this if you want. I challange any
crystal report issue.

"chenmau" wrote:

> 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?