Mcooper2406

Hi All, Sorry if this is the wrong area (or indeed the wrong forum) but I'm just looking for some advice on a SIMS report. I would like to create a report that list all conduct points for a given student and the time+date that they occurred. I'd like to use this data to create a RAG type 'timetable' for the student to visualise where they are getting the most/least points to use this to address behaviour issues. Thanks to anyone who can help!

Oh sorry yeah that's pretty obvious now you've said it! I'll do that! Thanks

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!

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,