It's looking great right now, sample attached with redactions.

I kept cteCalendar as you designed it, and changed ctePreCrossTab to use my attendance table.

It correctly merges the data correctly, one student...

One PDF is acceptable to me if I have it sorted correctly (a copy of acrobat pro should allow me to break it up manually),

BUT

I will likely try the SSRS...

Good Morning!

1) This is really cool stuff you're showing me, THANK YOU!

2) I created the temp table per the instructions, created fnTally, and enclosed the calendar code into a stored...

The attendance table contains records for each school day (roughly 18 per month).  So weekends, holidays, etc are not represented.  When joined with the calendar table there are nulls represented...

The finished product will be a rendering of a Florida Department of Education form that will be sent home with the student to get a parent signature, which then must...