Oracle Version: Premier report that allows a user to search for student entries and exits during a certain month. Special thanks to Brian P. Andle.
V 1.0 (01/12/2008)
- Initial Release
V 2.0 (07/29/2008)
- Updated for Oracle
- Added EntryExitReportHeader.html and EntryExitReportFooter.html
V 2.0.1 (07/31/2008)
- Fixed a problem with the EntryExitReportHeader.html page and EntryExitReport.html page. All other pages are the same as V 2.0
V 2.1 (09/20/2008)
- Added Grade_Level to the report.
V 2.2 (02/27/2009)
- Fixed problem with January and February searches where they would also bring up November and December exits.
V 3.0 (10/22/2009)
- Removed the need for /admin/reports/enrollment/EntryExitReportFooter.html
- Updated main page to use common includes (see separate include package if you don’t already have it)
- Updated main page to use common scripts and style sheets (see separate include package if you don’t already have it)
- As of V 3.0 is now included in report bundle.
V 3.1 (01/08/2010)
- Fixed problem with January and February searches where they would also bring up November and December exits. Fix had been removed in the 3.0 update by mistake.
Comments
Can't get the pages to work together
I have installed - and I cannot get the pages to work together
When I bring up the EntryExitReport -- I do nto get a submit or create button.
When I bring up the EntryExitReport I cannot get any choices to make either.
Anyone have any advice?
Sory folks -- forgot to load the includes folder --
Didn't load the includes folder...
Can't get the pages to work together
I have installed - and I cannot get the pages to work together
When I bring up the EntryExitReport -- I do nto get a submit or create button.
When I bring up the EntryExitReport I cannot get any choices to make either.
Anyone have any advice?
Re: Can't get the pages to work together
You need to use the includes download. Which you can find here http://powerdatasolutions.org/content/common-includes-v-10
January search included Novermber information
I have 3.0 installed and when I search for January enters I get both November and January data. Anyone else have this issue?
Dave Black
Lewis Central Schools
January search
I am having exactly the same behavior. January search yields November and January results, February search yields December results.
Cheryl Lawrence
Caroline County Public School
re: January Search
January search should now work in v 3.1
Jason Treadwell
Custom Solutions Specialist
jason@powerdatasolutions.org
www.powerdatasolutions.org
re: January Search
Yep, I'm being told by another PDS person that I have not uploaded my fix. Sorry. The fix is really old too so it's a bit embarrassing. It'll be up as soon as I get a chance.
Jason Treadwell
Custom Solutions Specialist
jason@powerdatasolutions.org
www.powerdatasolutions.org
Create Button
The report states that you can click on the create button after you change your options. I do not show a create button on the page. Can you help me with this?
re: Create Button
The "Create" button is now the "Submit" button.
Jason Treadwell
Custom Solutions Specialist
jason@powerdatasolutions.org
www.powerdatasolutions.org
Submit/Create
I, too, do not have either a Submit or Create button. Has anyone figured this out?
Re: Submit/Create
You need to download and install http://powerdatasolutions.org/content/common-includes-v-10 All future reports not included in the bundle will use these common sets of files.
perfect!
Thanks so much. It worked great!
re: Create Button
Thanks but the submit button is not being displayed either...Am I missing something?
re: Create Button
My report also doesn't display a submit button so i'm missing the same thing you are. I hope i get it soon because it's a really nice report.
re: EntryExitReport
Is there a way to make this work in version 6?
Thanks!
Todd Kennedy
Pembina Hills Reg. Div. #7
re: EntryExitReport
It does work in 6.0. If you are seeing a Tlist_sql filtered out message see PowerSource Doc ID 55553 or search for tlist_sql fix here on PDS.
Brian Andle
Student Name on Entry/Exit
Hi Jason,
Thanks for a great report. Just one question, what does the "*" signify next to a student's name?
Sally A. Simpson
IT Manager
Lakeside Educational Network
Horsham, PA
Re: Student Name on Entry/Exit
The "*" indicates that the student has left and returned during the current school year.
Brian Andle
Header so nice, you had to render it twice?
Just downloaded this - pretty awesome! Found an aesthetic bug:
The following code (I had to disable the tags) is in both the EntryExitReport.html as well as the EntryExitReportHeader:
!-- start of title --table border="0" cellspacing="0" cellpadding="4">
tr>
td class="header printHeader">~(decode;~[gpv:status];50;Enrolled OR Exited;99;Exited;Enrolled) At ~[schoolname] In ~(decode;~(v.m);0;July-June;1;January;2;February;3;March;4;April;5;May;6;June;7;July;8;August;9;September;10;October;11;November;12;December; ) of the ~(f.add;1990;~(curyearid))-~(f.add;1991;~(curyearid)) School Year/td>
/tr>
/table>
br>br>
!-- end of title -->
Net effect is that the header shows up twice.
I removed it from the main page, leaving it the Header page (good modular design), and everything looks perfect.
Just an FYI.
--
Jay Duff
Network Administrator
Mannheim School District 83
Franklin Park, IL
re: Header so nice, you had to render it twice?
Ah yes, I was running into the dreaded 32K issue and started modularizing the page. What you have is a mix of the modular and non-modular versions. What's more is I have a bundle of reports planned that modularizes 3 pieces that work in every report making updating the main portion of each that much easier. It also makes updating certain pieces a lot nicer. This should be fixed in the next release.
Jason Treadwell
Custom Solutions Specialist
jason@powerdatasolutions.org
www.powerdatasolutions.org
Feb/Dec
I have also downloaded the new version and am still having the same issue with December exits and enrollments pulling into the report for February. I also see a double header on the report page. I love this report, we print it at the end of every month to use for budgeting purposes pertaining to enrollment trends. The superintendent shares those numbers with the board. Thanks for all you do.
Teresa
February/December dupes
I just downloaded and installed this. Works great now that I have tlist_sql set to true. However, I am still getting December along with February. Is it something on my end...I noticed that the release says that is fixed....
Thanks,
Jane
month of January pulling November
When we select the month of January or November, we are getting enrollment records for both November and January.
When we select the month of
When we select the month of January, we are getting enrollment records for November.
When we select the month of February, we are getting enrollment records for December.
Paul Tringali
PowerSchool Data Analyst
Levittown Public Schools
Ours is doing the same thing.
When selecting the month of January it pulls both January and November. The same goes for February and December. I traced the problem down to the sql statement. It converts the month to a char and then uses a LIKE statement which, for January, pulls all months with a 1 in it, and February, pulls all months with a 2 in it. I tried a few tweaks but I can't really follow the SQL enough to fix it. Please let me know when there is a fix.
Aaron Scroggins
Technology Director
Heavener Public Schools
ascroggins@heavenerschools.org
Upgrade to 5.2.1
I am also having problems with this report after the recent upgrade. Worked great before! I receive this error "Non-select tlist_sql filtered out" any ideas??
Thanks!
Re: Upgrade to 5.2.1
Please take a look at either http://powerdatasolutions.org/content/fix-tlistsql-error-5209 or Document ID 55553 on PowerSource.
Brian Andle
Upgrade Problems?
This report worked great until my recent update to PowerSchool version 5.2. Does anyone have any suggestions?
Thanks!
Entry Exit works for me now...
Jacqueline J. M. Brzezinski
For whatever reason the pref...("allow_expanded tlist_squl ";"true") shorthand verion from memory, stopped working. It did say true in the pref table...I set it to false.
Ran at the Execute line on the server and it works again..Jacquie
Thanks to Brian
Error 404
When accessing this report, on certain computers we receive an 404 Error. We don't see it on all computers. Any ideas?
Teresa Peterson
Segment?
This is a great report that we are finding very useful, but I was wondering what the "Segment" is.
Re: Segment?
You can setup reporting segments when you are in the District Office. Our Connecticut reports are done 3 times a year and I set the reporting segments to match the submission ranges. By doing that I can see the students I need to worry above before I do my state reports.
Brian Andle
btn_close_gr.gif
This report comes with an image named btn_close_gr.gif. Does anyone know what it's for or where it goes? Thanks. It's a great report.
Re: btn_close_gr.gif
It should go in the images folder. It in the pop-up windows.
Brian Andle
Re: btn_close_gr.gif
Thanks Brian. I didn't even know there were pop-ups. That is great!
Report not working after 5.2.0.9 upgrade
It works now. The Enable Tlist did not take the first time.
To test to see if it did take go to the Prefs table and search Name Contains "sql"
if it does not return something Tlist is NOT enabled. You need to try and enable it again from the server.
The report no longer works for us either after upgrading to 5.2.0.9. I have TLIST SQL security disabled.
Jamie
Cambrian SD
EntryExitReport
I love this report. It would be even better if you could make the list the current selection. Any way to make that happen?
Thanks
Bonnie Saranko
Database and Software Specialist
Andover Public Schools
Entry/Exit Report
This report is AWESOME! Thank you so, so much !
Exclude Entry-Exit Codes
Hi Jason,
Thanks for all your work on this.
Great looking report!
Any chance of either hand selecting codes or being able to exclude certain ones?
In our case when the report is run, it's inflated by those students who were normally promoted, Code PE.
Mike Dewar
Dedham MA Public Schools
Entry - Exit Report
Has anyone experienced this Report not working since version 5.2.0.9.0105 upgrade?
not working for me either
Mine is not working since the upgrade either. Just waiting to see if there is a new version to come out, or a fix for this one.
Re: not working for me either
Please see PowerSource document id 55553, for how to fix the error you having.
Brian Andle
Entry - Exit Report
Has anyone experienced this Report not working since version 5.2.0.9.0105 upgrade?
Broken in 5.2.0.9?
Yes, it is broken for us in 5.2.0.9. We get this error:
Non-select tlist_sql filtered out
Re: Broken in 5.2.0.9?
Please see PowerSource document id 55553, for how to fix the error you having.
Brian Andle
Broken
thank you for that information. it works now.
Lori
EntryExit Report
Hi Jason,
A request from my attendance director.
She asks, can the Grade Level field be included in the grid.
She wants to replace Homeroom, but I think homeroom is also important, especially at the elementary level.
So...is it possible to include a new field - grade_level?
Thank you...your work is truly appreciated!
Ellen Li
Data Manager
Glen Cove School District
re: EntryExit Report
Ellen,
I was actually surprised that it wasn't already in there. Version 2.1 includes the grade level.
Jason Treadwell
Custom Solutions Specialist
jason@powerdatasolutions.org
www.powerdatasolutions.org
re: EntryExitReport
Thanks!
Ellen Li
Data Manager
Glen Cove School District