blackwill

I believe we are in the same flock so you decide which it is .......

Thank you all for your help and suggestions and after taking a bit of advice from you all I finally got it to work.

Great thanks

Yes please that would be great.

All I want is a report that will show the total number of points for each student agianst behaviour types, for either individual forms or year groups. I can pull the data myself and make a Pivot table in excel but I want sims to do it at run time, I have a report that does that but for some reason it stops at the letter 'd' in the students surname. Thanks for all your suggestions.

Yes simon37 is correct I've had a look at the anaylsis reports and while they do produce a certain amount of information, it's not grouped in manner that makes it easily analyse for the staff involved. Thus my orginal question was how do I alter the excel template attached to the report, I have a report already that does this but it has errors in it that you have to sort out. Again I 'm trying to cut down on the amount of training for staff and if it's felt to be too complicated they won't use it. So thank you sivadam for your suggestion while it helps me, it's not quite what I'm looking for. Regards

Again I repeat my last statement, and express my ignorance the only reports that I know of that do that are Assessment Manager type reports. If anyone has a howto I would be very grateful.

Showing my complete an utter ignorance here, but how do you access anaylsis reports in SIMS?

I'm trying to change a template for a report generated in SIMS.NET. Basically I want to run a report that pulls all the behaviour points for a group of students and then adds them up in a pivot table. Tried finding where the template is stored so I can alter it but as of yet no joy. Can anyone suggest anything please. P.S. I can do this after the report has run, but don't want to go through designing pivot tables with admin staff, prefer it if it done it when run from SIMS.