Muazzam1
April 29th, 2006, 03:58 AM
My report is calculating the sum of spindles in spindle table for number of machines. Each machine contain 480 or above spindles.
When I calculate to total bags produced by number of machines during the month, it calculte wrong and shows very huge amount like 72480 instead of 142 or something else.
When I remove the field which calculate the total spindles then it shows correct sum of total bags.
I want to know what is the problem. Or what is the indexing scheme.
I have checked normalization and mapping of database tables both in crystal report and SQL Server 2000. These are correct.
Thankyou
When I calculate to total bags produced by number of machines during the month, it calculte wrong and shows very huge amount like 72480 instead of 142 or something else.
When I remove the field which calculate the total spindles then it shows correct sum of total bags.
I want to know what is the problem. Or what is the indexing scheme.
I have checked normalization and mapping of database tables both in crystal report and SQL Server 2000. These are correct.
Thankyou