Sonamg
Oct 15th, 2003, 11:34 PM
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
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