Results 1 to 2 of 2

Thread: Data in Database and Data displayed is report is different.

  1. Oct 15th, 2003, 11:34 PM #1
    Sonamg
    Sonamg is offline

    Thread Starter
    Junior Member
    Join Date
    May 2003
    Location
    Bhutan
    Posts
    26

    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
    Reply With Quote Reply With Quote
  2. Oct 16th, 2003, 06:01 PM #2
    billyboy
    billyboy is offline
    New Member
    Join Date
    Aug 2002
    Posts
    11
    could you paste the actual formula that you're using to compute the average?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width