Children identified as DD who are within 90 days of 8th birthday

←Return to the main Advanced Reporting page

We wanted a way to know which students are still classified as Developmentally Delayed (DD) within 90 days of their 8th birthday. This report will also include all students identified as DD who are over 8 years old.

Here is how the final report is constructed

One important note about this report: it have a lot of custom variables!

Within 90 or overdue?, Age Out Date, and 90-Days Prior are all custom fields we will create below.

Here's a what the Results Objects and Query Filter looks like:

Remember, after creating the initial report, all editing of a report happens in the Design window. This button is found in the upper-right hand corner of the SAP window.

Creating Custom Variables

Select the Available Objects Icon on the left-hand side of the screen.

Right click on Variables and then select New.

First, let's make the Age Out Day measure.

This just tells us on what day the student's 8th birthday occurs. This sounds simple but this database can make it just a little difficult.

Here's the formula for the variable:

=If Not(IsNull([Date of Birth])) Then ToDate(MonthNumberOfYear([Date of Birth])+ "/" + DayNumberOfMonth([Date of Birth])+ "/"+ FormatNumber(Sum(Year([Date of Birth])+8);"####");"MM/d/yyyy")

It may be easiest to just copy and paste this in!

Second, let's make the 90-Days Prior measure.

This just tells us what day is 90 days prior to the student's 8th birthday. This is just a little more complicated than the first variable.

Here's the formula for the variable:

=If Not (IsNull([Date of Birth])) Then RelativeDate(ToDate(Concatenation(FormatNumber(MonthNumberOfYear([Date of Birth]);"00");"") + Concatenation(FormatNumber(DayNumberOfMonth([Date of Birth]);"00");"") + Concatenation(FormatNumber(Sum(Year([Date of Birth])+8);"0000");"");"MMddyyyy");-90)

This one could probably be shortened but the Concatenation function is fairly limited so I chose a version that's more readable.

Finally, let's make the Within 90 or overdue? variable.

This makes the field more readable and helps prioritize areas of need. If it's overdue - get to that one ASAP!

Here's the formula for the variable:

=If [Age Out Day]<=CurrentDate() Then "Overdue" ElseIf [90-Days Prior]<=CurrentDate() Then "Within 90 Days"

In the next step, we'll have the report automatically filter out all values except for "Overdue" and "Within 90 Days".

Create and Input Control to Filter Out Unwanted Values

This query captures ALL students identified in the area of DD. By creatively using an Input Control, we can have the report only show those students who are 8 or older or those within 90 days of turning 8 years old.

Select the Input Controls icon on the left-hand side of the window.