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?

Syndicate content Syndicate content