SIMS PoS Individual Reports

[babatate]

I'm not sure if what I am asking is possible, but here goes:

 

I am playing with the report template for Individual Student end of year reports from the SIMS Programmes of Study

 

The template provided allows for each subject to have an 'Achievement' bulleted list, pulling through the Statements for those NC statutory objectives attracting a code of S or M (Secure or Mastered). The merge field looks like this:

 

<>.

 

Unfortunately for a higher ability child this can be extensive (and similarly for a lower ability child in the 'Developing' list).

 

My Headteacher has asked if the list can be truncated to the first 5 results under each section but I'm not sure if this is possible (or how to achieve that0, can anyone assist, please?

 

Many thanks

Barbara

[vikpaw]

I haven't used those fields, but it's unlikely. If the statements are of fixed length, you could put the results in a table row of fixed size, and it might truncate, but the results wouldn't be predictable with variable length strings.

[babatate]

Thanks for such a quick response - no, they're variable length.

Bother!

B

[vikpaw]

Worth checking the manual, if it is capable of filtering by code, limiting numbers wouldn't be that hard, but it's unlikely to be there. You'd need a change request.

[Esteban_Child_of_the_Sun]

There are a couple of ways you could do this, unfortunately they aren't built in to SIMS. The first is you could have a word Macro that you manually run on each generated report that truncates the table of results returned to 5 rows, this is time consuming. You could export the reports in to a folder and have a quick PowerShell script iterate over all the reports in a given directory doing the same as the Macro using embedded VB script, but they then aren't in SIMS.

[vikpaw]

There are a couple of ways you could do this, unfortunately they aren't built in to SIMS. The first is you could have a word Macro that you manually run on each generated report that truncates the table of results returned to 5 rows, this is time consuming. You could export the reports in to a folder and have a quick PowerShell script iterate over all the reports in a given directory doing the same as the Macro using embedded VB script, but they then aren't in SIMS.

Could the macro be squeezed into the Ind.Rep template? I'm sure that for some reason this wasn't possible before because it creates two documents or something weird.

[Esteban_Child_of_the_Sun]

Capita have attached a signature tot he template so any changes to it stop it running at all.

[vikpaw]

Meh!