SIMs report rtf problem

[edtheteach]

Hi all,

 

My first post and I'm totally stuck...

 

I'm trying to create a report which will provide each teacher with a list of their vulnerable pupils by class alongside advice on how to deal with them. We have a number of SEND pupils and just saying that each pupil has a pupil profile isn't working as it's obvious that they are not using them.

The report looks like this.

 

 

I've then created an rtf template to present the data

... and it sort of works.

 

But... and I've now spent hours and hours trying to sort this...

I only want it to display the SEND Type Descriptions that have no end date - so not to display needs that are no longer relevant and have an end date added to them.

I also don't want it to display for certain lessons - we have Assembly etc on our timetable allocated to each year group, but I can't get it to accept filters to not display those lessons.

 

The answer must be in the filtering... but... I've hit a wall.

[BKGarry]

Filter the SEN Needs of a student, like you have for Students of a class, and have it with the end date is empty/null

 

As for the Assembly stuff, it may be worth filtering the lesson to not include those subjects subject code, but you will need the two letter subject code for the lessons, which should be retrievable from Tools > Setups > subjects

[edtheteach]

Tried that...

 

When I filter lessons where:

subject code of the class does not contain 'As' - it works fine and takes out all the assembly slots, but if I then add in an 'or' where subject code of the class does not contain 'Gr' to take out the guided Reading slots, it not only ignores that but puts back in all the Assembly slots as well...

 

Have even tried putting both As and Gr in the same filter so they appear 'As, Gr' but that results in both being ignored.