Embedded Files
We need a way to see which students are on the Extend 1 Curriculum.
Surprisingly, this wasn't a default report in ECATS when we created this custom report.
Here is how the final report is constructed
Here is how the final report is constructed
Here's a what the Results Objects and Query Filter looks like:
Add a list of values to the Grade Abbrev Query Filter
Add a list of values to the Grade Abbrev Query Filter
Filter out unwanted grades in the Query Filter.
In the Event Selector query, select In List and then Value(s) from list.
From this list, select Currently Valid: IEP.
Sometimes here I select the Event Selector header to sort these values alphabetically.
Input Control based School and Grade Abbrev
Input Control based School and Grade Abbrev
Setting up Input Controls is a great way to make these reports more flexible without having to modify the actual query that drive the report.
I added School here because there are times when I want to only run the report for a single school or exclude a particular school from the report.
I added Grade because there are specific testing requirements for Extend 1 for various grades. Having this input control really helps around testing time.
Create the Input Control by opening the Input Control from the left side of the screen. Select New to start the process.
Select which field you want to base the Input Filter on. Let's start with School.
I usually use Check boxes but there are other options as well.
Repeat this process for the Grade Abbrev field.
The difference between useful to usable is in the design and formatting.
The difference between useful to usable is in the design and formatting.
Refresh on Open
Refresh on Open
In Properties -> Document, set the report to Refresh on Open.
Add a footer with "="This report was generated on: " + LastExecutionDate()"
Manage Breaks
Manage Breaks
For this report, one school per page. Organized by School.
Add the school name to the School Section. This helps with sorting and distribution later.
Plan breaks and sorts to match grain size of distribution or remediation.
Page Setup
Page Setup
The default page size is A4 for some reason. Change it to Letter and Landscape.
Make sure the Scale to Page is set to automatic. This should ensure you fill up the useable space.
Also, most printers support a .4 margin. I use this to the left, right, and bottom to maximize print space and readability.
Page updated
Google Sites
Report abuse