Problem with report template logic

[Patrick_Paul]

I just can’t seem to get the hang of these report templates. I have a report I’d like to generate that spits out a list of trainees with an assessment that’s 80 days since their last one or greater that have an active status, grouped by their state. I’ve done the report for the trainees table, for entire table. Here’s the template, it’s short and sweet:

Trainees with assessments greater than 20 days overdue:

<<Start:orderby(Select(trainees [RandomID], (and([Last Assessment]<NOW()-80, isnotblank([last assessment]),[Current Status]=Active Approved))), [location state])>>

<<[Trainee First Name]>> <<[Trainee Last Name]>> at <<[Location]>>, <<[Location State]>> under  <<[Mentor].[Mentor First Name]>> <<[Mentor].[Mentor Last Name]>>

<<End>>

That last tag is and End, as usual, doesn’t show up in the post.

What I end up with is an email that contains every trainee in the whole company, and all their data columns (basically a “detail view”), one after another?! Stumped again.