External assessments in reports

Hi,
I am trying to set up a report template and i want to get the students’ targets to show on the report. Because our targets are set based on CAT4 results I added external assessment to the template and the preview is how I would like it to show but when I actually generate the report I end up with pages and pages of rows in the table and no results in them.
I have attached pictures of it below.

Does anyone have any ideas on why this might happen and is there a way to solve it or another way to display targets without it?

Thank you.