[sims] SIMS report issue

[Mcooper2406]

Morning,

 

Sorry if this is in the wrong place but I'm not an IT professional.

 

I'm trying to run a SIMS report that will have every child in the school along the left hand column, all subjects across the top row and list each child's individual teachers in the main part of the report as below:

 

[TABLE=class: grid, width: 500]

[TR]

[TD]Name[/TD]

[TD]Reg[/TD]

[TD]English[/TD]

[TD]Maths[/TD]

[TD]Science[/TD]

[TD]French[/TD]

[/TR]

[TR]

[TD]Joe Bloggs[/TD]

[TD]3C2[/TD]

[TD]Mr A[/TD]

[TD]Mr B[/TD]

[TD]Mr C[/TD]

[TD]Mr D[/TD]

[/TR]

[/TABLE]

 

 

I've got as far as being able to produce a report that has every child and their teachers but unfortunately it looks like the following:

 

[TABLE=class: grid, width: 500]

[TR]

[TD][/TD]

[TD]Reg[/TD]

[TD]subject[/TD]

[TD]Teacher[/TD]

[TD][/TD]

[/TR]

[TR]

[TD]Joe Bloggs[/TD]

[TD]3C2[/TD]

[TD]Maths[/TD]

[TD]Mr A[/TD]

[TD][/TD]

[/TR]

[TR]

[TD]Joe Bloggs[/TD]

[TD]3C2[/TD]

[TD]English[/TD]

[TD]Mr B[/TD]

[TD][/TD]

[/TR]

[TR]

[TD]Joe Blogs[/TD]

[TD]3C2[/TD]

[TD]Science[/TD]

[TD]Mr C[/TD]

[TD][/TD]

[/TR]

[TR]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[TR]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[TD][/TD]

[/TR]

[/TABLE]

 

As you can see the repeated names and formatting of this report is less than ideal as it has something like 11000 rows to the data.

Apologies if this is a silly question but the only other workaround seems to be incredibly complex (to me) formulas in excel. The IT department and data manager don't think there is a way to do it so any help would be hugely appreciated.

 

Again apologies if this is in the wrong place or incredibly simple.

 

Thanks,

Edited October 3, 2017 by Mcooper2406

[mukz]

Hi There,

 

Maybe a pivot table would help. Tbh i have never done it before but i am pretty sure it would be something which can be achieved.

Google usually holds the answers.

 

Unfortunately i am on holiday and purposefully cut my access to the network so am unable to help. If no one has helped by the tome I get back i will surely try and help you

[Steve21]

Shouldn't be that bad, Just have to make a filter per subject name and then filter duplicates as an example just doing it for 2 subjects (Maths/English in my example)

 

 

You might need to do a duplicates removal after depending how your SIMs has people data retained, but that can just be done with 2 clicks in Excel etc using the CSV output

 

Or did you want it 100% within SIMs?

 

Steve

[Mcooper2406]

Thanks for your fast response that has worked almost perfectly, the only problem I have now is where there is split groups it is generating two rows of information for the student.

 

For example:

 

[TABLE=class: grid, width: 500]

[TR]

[TD][/TD]

[TD]Maths[/TD]

[TD]English[/TD]

[TD]Science[/TD]

[/TR]

[TR]

[TD]Joe Bloggs[/TD]

[TD]Mr A[/TD]

[TD]Mr B[/TD]

[TD]Mr C[/TD]

[/TR]

[TR]

[TD]Joe Bloggs[/TD]

[TD]Mr Z[/TD]

[TD]Mr B[/TD]

[TD]Mr C[/TD]

[/TR]

[/TABLE]

 

If I ignore duplicates it does the same thing but with a blank name like so:

 

[TABLE=class: grid, width: 500]

[TR]

[TD][/TD]

[TD]Maths[/TD]

[TD]English[/TD]

[TD]Science[/TD]

[/TR]

[TR]

[TD]Joe Bloggs[/TD]

[TD]Mr A[/TD]

[TD]Mr B[/TD]

[TD]Mr C[/TD]

[/TR]

[TR]

[TD][/TD]

[TD]Mr Z[/TD]

[TD]Mr B[/TD]

[TD]Mr C[/TD]

[/TR]

[/TABLE]

 

 

Is there any way to ignore split classes and just take one teacher of each group?

 

Thanks again for all your quick responses!

[Steve21]

Personally it'd be easier just to export the whole CSV, then within Excel just do a remove Duplicates and select the column with their names. If it's like a one-off task for printing something it's literally 2 buttons to click or is this going to be used constantly and need regenerating?

 

Steve

[Mcooper2406]

Oh sorry yeah that's pretty obvious now you've said it!

 

I'll do that!

 

Thanks