Student Attendance List Report V 2.5

Thu, 09/24/2009 - 3:13pm •

Submitted by jtreadwell •

Login or register to post comments
send to friend

Oracle Version: Premier report displaying student attendance for a given time length as a printable list. Will display daily and meeting attendance.

V 1.0: Initial Release
V 1.1: Fixed printability for IE. Should now print correctly.
V 1.2: Added attendance key at the bottom of the report.
Added labels at the top of each table describing the data that was searched for in that table.
i.e. Daily Attendance for Test, Student from 5/1/2008 to 5/16/2008
V 2.0: Updated for Oracle.
V 2.1:
- Moved common report information to included pages to free up space. These 5 common pages will be used in all reports from now on.
- Added /admin/javascript/printable.css
- Added /admin/javascript/extra.css
- Added /admin/reports/includes/reportHeader.html
- Added /admin/reports/includes/reportMid1.html
- Added /admin/reports/includes/reportFooter.html

V 2.5:
- Updated includes for 6.0 (not necessary to update if using Reports Bundle.
- Other minor changes to /admin/reports/attendance/stdAttList.html

**Starting with this version this report is automatically included in the reports bundle

Contributor:

Jason Treadwell

Pro:

Premier - 5.1.x:

Premier - 5.2.x:

Premier - 6.x:

Report Type:

Web Based Report

Comments

Start date causes report to be blank?

Submitted by robingage on Tue, 02/16/2010 - 5:45pm

I'm running this for a report on a student who was enrolled in school and in classes on 8/17/09. I'm using 2/16/10 as the end date.

When I set 8/17/09 as the start date the report is blank, same with setting it to start on 8/18/09. But, when I set it to 8/19/09 it runs perfectly.

I can verify that the student has non-blank attendance on both 8/17 and 8/18.

I've used 8/17 as the start date on other students and the report runs fine.

Ideas?

We're running PS 6.1.0 and only use Meeting attendance.

Same report by Date

Submitted by kpierce on Mon, 02/15/2010 - 10:41am

I love this report, however, I was wondering if there is a report exaclty like this one where you choose a date rather than a student. So the report would give me a list of all students with an attendance code for a particular day with the comments. Is there an easy way to change the code for this report or is there a way to edit the built in "Absentee Report" to add comments?

Meeting attendance "Non-select tlist_sql filtered out" ?

Submitted by dstrollo on Mon, 01/25/2010 - 4:10pm

This is a great customization for us, so a big thank you. The daily portion works great, however, the meeting attendance section shows the student and date parameters, and on the line right under that it returns "Non-select tlist_sql filtered out". The headers show up, but not the meeting attendance data. Any help or suggestions to try would be greatly appreciated.

Oops, sorry - I just saw the t-list suggestion. I'll try that first.....I did the fix from PowerSource, but it still doesn't work. What am I missing? Thanks.

Well, the PowerSource solution didn't work, buy installing your customization did! All set and thank you.

Donna Strollo
Network & Data Manager
Prospect Heights D23
Prospect Heights, IL

Splitting Report

Submitted by mcphilbrick on Fri, 01/15/2010 - 11:25am

At the high school, this report was not showing an accurate account of the daily attendance but the meeting attendance portion of the report was correct. I'm assuming that the problem stems from the fact that we use meeting attendance and convert it to daily attendance based on 1st block.

I was able to modify the report for the high school by removing the table that displayed the results for daily attendance.

Since our grade school uses daily attendance only, I was going to take the original report and remove the table for meeting attendance. I opened the report in Dreamweaver and deleted the table for meeting attendance. When I run this report in PowerSchool, the student selecton screen shows the table headings for daily attendance. However, the resulting report switches to meeting attendance.

Is it possible to split this report to display only the daily attendance? If so, what did I do wrong?

Student Attendance List Report

Submitted by smaitland on Fri, 01/08/2010 - 12:30pm

We are currently running PowerSchool 5.2. Can I run this report on this version of PowerSchool?

Sharon Maitland

re: Student Attendance List Report

Submitted by jtreadwell on Fri, 01/08/2010 - 2:23pm

Try this version: http://www.powerdatasolutions.org/content/student-attendance-list-report...

Jason Treadwell
Custom Solutions Specialist
jason@powerdatasolutions.org
www.powerdatasolutions.org

Is there a way to run this

Submitted by jsmthfld on Mon, 01/04/2010 - 3:49pm

Is there a way to run this report for a selection of students at once with each individual student report on a seperate page? Is there a report out there that does that?

RE: Is there a way to run this

Submitted by MattFreund on Wed, 01/06/2010 - 9:12am

Here are some reporting engine reports that may do what you're looking for - http://www.sisresources.com/index.php?/Attendance/student-attendance-det...

Matt

The Student Attendance List

Submitted by jsmthfld on Mon, 01/11/2010 - 4:27pm

The Student Attendance List worked great! Thanks so much!

P4 Blank for every student

Submitted by johnnasset on Mon, 11/30/2009 - 12:52pm

Not sure why but no student has a mark for period 4. This is across all schools for kids who show marks on all periods. Any ideas?

Possible updates

Submitted by MackHucks on Tue, 11/03/2009 - 9:05am

I had an issue where attendance was not being reported. It came from a "feature" of oracle that did not allow the date to be queried properly. I added the to_date('date_var','mm/dd/yyyy') and it took care of those students that did not report correctly. I also saw attendance records for dates our meeting attendance was corrected. I added "AND att.attendance_codeid <> '1556'" to my bottom join to disregard the present attendance.
This was for meeting attendance issues.

Student Attendance Meeting Error

Submitted by henshaw on Wed, 10/14/2009 - 11:31am

Everything looks great on the Daily Attendance....what do we have to do to modify the report to get the Meeting Attendance to work?

re: Student Attendance Meeting Error

Submitted by jtreadwell on Wed, 10/14/2009 - 4:06pm

The report should already work for meeting attendance. What are the errors you are getting?

Jason Treadwell
Custom Solutions Specialist
jason@powerdatasolutions.org
www.powerdatasolutions.org

Student Attendance List Report v2.5

Submitted by mgillen on Wed, 09/30/2009 - 8:20am

Does this report include comments? I am looking for an attendance report that will work for both daily and meeting attendance and will show comments. This request is due to H1N1.

re: Student Attendance List Report v2.5

Submitted by jtreadwell on Wed, 10/14/2009 - 4:07pm

The daily attendance will show comments.

Jason Treadwell
Custom Solutions Specialist
jason@powerdatasolutions.org
www.powerdatasolutions.org

Student Attendance List Screen Error

Submitted by kpulliam on Tue, 09/29/2009 - 3:33pm

I installed the pages as described but am getting an error on the input page.
In the box that has Meeting Attendance for from to
directly underneath of that I am getting a message that states:

Non-select tlist_sql filtered out

I can select a student and dates but do not get any data.
Any suggestions would be greatly appreciated.
I am on version 6.0.0

Re: Student Attendance List Screen Error

Submitted by brian_andle on Wed, 09/30/2009 - 7:02am

See PowerSource Doc ID 55553 or TLIST Security on this site.

Brian Andle

Worked for me

Submitted by robingage on Fri, 01/29/2010 - 7:47pm

Thanks for pointing out that article, it worked- after some confusion about what password it was looking for.

Similar