Would anybody be able to help me with a report.
I need to run a report that generates the number of behaviour points a pupil has received for a date range, but all attempts seems to produce the total for the year and takes hours to run, does anyone have one they could make available to me.
You'll need to say what MIS ssytem you're using.
It'll be different in Bromcom, SIMS, Aspen etc.
if it's sims, I have a bunch made up - all are slightly tweaked from what the LA Support desk gave me.
key thing with behaviour/achievement reports is to use Student Conduct Information, then add in that category the Points/Date/Type stuff - then set a filter against the date with "Prompt at runtime"
it won't give you a total, and you'll have to convert the text numbers to actual numbers in excel to autosum it up, but that's about 2 seconds.
Is it not possible to get it to total up in Sims, the problem is i need to generate a letter based on the highest number of points awarded, and as its SMT that will be running it, there needs to be as few as steps possible, from what your saying there is a formula in Excel then a mail merge to go through.
every report my LA Support has provided us for this kind of thing is tied to an excel template, which then does all the calculations.
since I prefer my excel sheets I've set my own very basic reports up that I paste in - but that's yearly/weekly stuff I run for our house competitions, not on individuals.
here are two of my LA Support reports - completely unchanged - should be one for AP, one for BP.
There's a built in report for aggregated student conduct points, but rather the date range is limited to between a date in the past to present. Also probably won't be great for producing the letters.
Have a look on SupportNet file sharing at #859 or #871, though they may well have been superceded by better versions, it will be a good start. possibly similar to above files.