Data in Database and Data displayed is report is different.
I'm developing Examination System; very lately I am facing very cretical problem. My problem is something like this........
Database field and data are:
Mks1 Mks2 Mks3 Mks4 Mks5 Average Result
50 60 79 80 45 63 1
the field Average is calculate by system using this formula:
tot=(Mks1+Mks2+Mks3+Mks4+Mks5)
Average=round(tot/5,0)
though in database the average is found 63 only, but when it is displayed in crystal report, the average is displayed in something like this 1,657,098,945
what could the problem? please help me......
I use VB6.0, Crystal Report 7.0 & MS SQL Server 2000
