Hi Char,
From how iSAMS’ Reward & Conduct notifications are designed, the built-in notification route is based on the record being created, so I wouldn’t assume it can turn those notifications into one daily or weekly digest. iSAMS can also run reports and publish selected information to the parent portal, so I’d separate the reporting requirement from the notification setting.
A practical approach would be:
- Filter the records to the chosen date window, and decide whether the window is based on record date or last update.
- Group the results by pupil and include only the fields the school has approved for parents.
- Deliver one controlled output per family or parent through the system that owns the communication. MySchoolPortal may be able to accept a digest or import, but I’d confirm that before designing around it.
- Define how no-record periods, multiple or separated contacts, opt-outs and duplicate contact details are handled.
- Never send a single output containing unrelated pupils. If a family has more than one linked child, that needs to be an intentional, verified grouping.
SSRS/iSAMS can handle the filtering, grouping and report layout. A standard SSRS subscription uses configured delivery details; if the recipient and report parameters need to change per family, a data-driven subscription or a separate controlled automation layer would normally be needed. That also depends on the school’s SSRS edition, permissions, stored credentials and email/delivery setup.
I work with iSAMS/SSRS reporting, and this is the kind of requirement where the data logic and delivery route need to be designed together. If you can confirm what access or integration options you have for MySchoolPortal, I’m happy to help narrow down the safest practical route.