Attendance Change Detail for Orgs¶
The report is a supplement for the Attendance Change for Orgs script. This script also runs from the OrgSearch BlueToolbar. It is used to know where the percentages came from and which organizations were involved. This report is also resource intensive, so we limited it to Admin role.
The recommended name is
Use the following code to Create the SQL Script. See How to create a SQL Script.
--Roles=Admin --class=StartEndReport SELECT a.PeopleId , p.Name2 , o.OrganizationId , o.OrganizationName , a.Attended , a.WeekDate FROM AttendanceChangeDetail(@orgids, @MeetingDate1, @MeetingDate2) a JOIN dbo.People p ON p.PeopleId = a.PeopleId JOIN dbo.Organizations o ON o.OrganizationId = a.OrganizationId ORDER BY Name2, o.OrganizationName, WeekDate