Seeking Guidance one of the many Treadwell Reports
I'm looking for some guidance on adding a column to the Attendance Frequency report. It has been told to me that this report is worthless without knowing what meeting the absences have occurred. I showed how you can click on the # of Att Records to see greater detail of the period in question, but that was not good enough.
I'm looking to see what additional sql codes and such might be needed to add a meeting column.
I think I'd want to add an additional table header:
td>Meeting /td>
Modify the TList line to say something like:
~[tlist_sql;SELECT s.DCID, s.LastFirst Student, sm.meeting Meeting, s.Grade_Level, crs.Course_Name, CC.Course_Number, CC.Section_Number, t.LastFirst Teacher, CC.ID ccid, COUNT(att.ID) numRecords
An additional Inner join, something like:
INNER JOIN Section_Meeting sm ON sm.SectionID = CC.SectionID
And Finally an actual listing with
~(Meeting;t)
But this doesn't seem to work. Am I missing something?
Recent comments
18 hours 40 min ago
18 hours 53 min ago
1 day 14 hours ago
1 day 16 hours ago
2 days 9 hours ago
2 days 11 hours ago
2 days 12 hours ago
2 days 12 hours ago
2 days 13 hours ago
2 days 13 hours ago