Crystal error 'missing right parenthethis' in sql command

Getting error in Add command sql with parameter definition

SQL is :

SELECT DISTINCT PERSONS.STUDENT_NO,SCHOOLS.SCHOOL_NAME, PERSONS.PREFERRED_NAME_UPPER, PERSONS.GENDER,
       STUDENT_REGISTRATIONS.SCHOOL_YEAR, STUDENT_REGISTRATIONS.GRADE,STUDENT_REGISTRATIONS.SCHOOL_CODE,
       WSSV.IEP_FLAG, STUDENT_REGISTRATIONS.ESL_LEVEL_CODE,
       STUDENT_REGISTRATIONS.ENGLISH_SKILLS_DEVELOPMENT, FS_STUD_INTV_PROGRAMS.START_DATE,
       FS_STUD_INTV_PROGRAMS.END_DATE, FS_INTV_PROGRAMS.FULL_NAME, SCHOOLS.SCHOOL_BRIEF_NAME,
       STUDENT_REGISTRATIONS.STATUS_INDICATOR_CODE
FROM  TRILL.STUDENT_REGISTRATIONS STUDENT_REGISTRATIONS
       INNER JOIN TRILL.SCHOOLS SCHOOLS
         ON STUDENT_REGISTRATIONS.SCHOOL_CODE=SCHOOLS.SCHOOL_CODE
       INNER JOIN TRILL.PERSONS PERSONS
         ON STUDENT_REGISTRATIONS.PERSON_ID=PERSONS.PERSON_ID
       INNER JOIN TRILL.FS_STUD_INTV_PROGRAMS FS_STUD_INTV_PROGRAMS
         ON PERSONS.PERSON_ID=FS_STUD_INTV_PROGRAMS.PERSON_ID
       INNER JOIN TRILL.FS_INTV_PROGRAMS FS_INTV_PROGRAMS
         ON FS_STUD_INTV_PROGRAMS.INTV_PROGRAM_CODE=FS_INTV_PROGRAMS.INTV_PROGRAM_CODE
       INNER JOIN TRILL.WEC_STUDENT_SUMMARY_VW WSSV
         ON  STUDENT_REGISTRATIONS.PERSON_ID=WSSV.PERSON_ID
  WHERE  STUDENT_REGISTRATIONS.SCHOOL_YEAR='{?School Year}'
      AND STUDENT_REGISTRATIONS.SCHOOL_CODE='{?School Code}'
      AND WSSV.SCHOOL_YEAR= STUDENT_REGISTRATIONS.SCHOOL_YEAR
      AND FS_INTV_PROGRAMS.INTV_PROGRAM_CODE in ('{?Intervention}')
      AND Student_registrations.status_indicator_code = '{?Status}'