0 Replies Latest reply on Nov 30, 2006 7:30 AM by Lemur99

    First Time Passes Pie Chart

    Lemur99
      Hi,

      Im trying to display a chart of the users who have passed the most modules first timemodules that my users have passed first time.

      I cannot add/chnage the database but if passible i could add a different database.

      This is my query for the passes and fails i have.

      select *
      from pps_scos, pps_transcripts, pps_principals
      where pps_scos.sco_id = pps_transcripts.sco_id
      and pps_transcripts.principal_id = pps_principals.principal_id
      and pps_scos.name like 'MT%'
      and pps_principals.name like 'Lee Duncan'
      AND dbo.PPS_TRANSCRIPTS.STATUS not LIKE 'I'
      AND dbo.PPS_TRANSCRIPTS.STATUS not LIKE 'X'
      AND dbo.PPS_TRANSCRIPTS.STATUS not LIKE 'R'
      AND dbo.PPS_TRANSCRIPTS.STATUS not LIKE 'N'
      AND PPS_TRANSCRIPTS.TICKET not like 'l-%'

      the relevent iformation that it returns here is -

      MTM-072 Hand Injuries F Lee Duncan
      MTM-072 Hand Injuries P Lee Duncan
      MTM-099 Sexually Transmitted Diseases F Lee Duncan
      MTM-099 Sexually Transmitted Diseases P Lee Duncan
      MTM-066 Testing VITAL Connectivity P Lee Duncan
      MTM-073 Understanding Email P Lee Duncan
      MTM-055 It's Your Choice P Lee Duncan

      I then want to store the amount that i have passed first time, in this case 3 and then turn it into pic chart. But i need to do this with all users, any suggestions on how this could be done?

      Regards,
      Lee Duncan