[sims] Duplicated pupils in report

[edtheteach]

Hi all,

 

Trying to pull together a report which will display all a teachers SEND pupils along with information about their needs and suggestions for the teacher.

 

The report only has a few data fields but is returning duplicated entries with the same data line appearing 3 times when it is run and I cant see why this is the case - am I being really stupid and have missed something really obvious.

The report outputs to an rtf using a user-defined template as I want to page break on each teacher's name.

 

All I'm asking for is:

Lessons - filtered to remove lessons such as Assembly etc.

Class teacher

Class Name

Students of the class - filtered so only SEND pupils are listed

Student Adno

Student Name

SEND Needs - filtered to remove any Need Descriptions that are blank

SEND Needs Type Description

SEND Need Description (which contains personalised info on the pupils)

 

When it's run, it pulls through the data as requested with the SEND needs of each child by class and by teacher, but displays every entry 3 times which makes the report enormous and useless!

[bobsmith]

screenshot the reporting tree page for us?

 

Have you got any filtering on sen stages so it only shows current?

Edited May 13, 2019 by bobsmith

[Damon]

Perhaps you need to limit the SEND Needs to their main (i.e. by priority) and show one result. Additionally, are you limiting the lessons by date range and so on? Perhaps it's showing previous memberships too, so you may end up with duplicated students. It would help to see the structure as Bob said.

[edtheteach]

After spending hours staring at the screen, I know why it's doing it, just don't know how to stop it...

 

It's picking up each incident of a lesson so if a pupil has 4 English lessons, they appear 4 times - rather than just once. How do I filter the lessons so there is just one line regradless of how many times the lesson appears - I've tried ticking 'Display first record only' but it just crashes SIMs.

The tree stucture is below - if it's still needed...