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.
ThankyouCan you post some sample data and the result you want
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment