Student Contacts in CMIS Facility
I have a report that informs 'Student Contacts' of their ePortal usernames and passwords if they have been granted ePortal access. When run this report generates multiple copies of letters for Student Contacts who are linked with more than one Student.
Does anyone know of a way to use the filters to restrict the return to a single contact?
I have used the filter (Stucontact.Eportal='Y') which filters the letters to Student Contacts with ePortal access but this does not resolve the multiple copy issue. I have also tried to use this SQL extract (select DISTINCT ContactId from nsturelcontacts where setid='2009/2010' and eportal='Y') but this also fails to limit the returns.
Any clues from anyone?