+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, Sims Sub Reports Subtotal in Technical; I`m trying to do a report to count how many achievemnt points and behaviour points each student has received in ...
  1. #1
    Jamie_a's Avatar
    Join Date
    Dec 2006
    Location
    Sheffield
    Posts
    82
    Thank Post
    9
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Sims Sub Reports Subtotal

    I`m trying to do a report to count how many achievemnt points and behaviour points each student has received in a given period. my report consiste of the students names form etc, a sub report on behaviour listing the points and one on achievement listing the points is it possible to subtotal each of these.

    Thanks

  2. #2
    BatchFile's Avatar
    Join Date
    Aug 2007
    Location
    Cumbria
    Posts
    948
    Thank Post
    544
    Thanked 128 Times in 106 Posts
    Rep Power
    60
    Try this one for size - You may need office 2007 for the macro to run EDIT: Nope, works in 2003, that one!

    SIMS won't report behaviour points between dates straight out of the box; it needs a bit of fudging (as in reporting all the points for all the incidents and using a macro to add em up)
    Attached Files Attached Files
    Last edited by BatchFile; 29th January 2010 at 09:00 AM.

  3. Thanks to BatchFile from:

    Jamie_a (29th January 2010)

  4. #3
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    54
    Jamie - check the various threads on SupportNet. And the various Files that some of us have uploaded to SupportNet, FielSharing!

  5. Thanks to Sivadam from:

    Jamie_a (29th January 2010)

  6. #4
    Jamie_a's Avatar
    Join Date
    Dec 2006
    Location
    Sheffield
    Posts
    82
    Thank Post
    9
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Found a few that almost do what i needIs there a guide anywhere showing how to edit the macro part just so i can tweka them a bit?

  7. #5
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    4,996
    Thank Post
    120
    Thanked 280 Times in 258 Posts
    Rep Power
    106
    If you post what you want and the relevant code I will help you alter it.

  8. #6

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,842
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    The posted reports with built-in macros are surely the way to go, but depending on what output you have, sometimes the Excel Sub-Total feature (Data | Sub Totals) can help break the data quickly.

SHARE:
+ Post New Thread

Similar Threads

  1. SIMS - Reports
    By Edu-IT in forum MIS Systems
    Replies: 9
    Last Post: 31st January 2010, 08:09 AM
  2. Example Assessment Reports in SIMS
    By garethedmondson in forum MIS Systems
    Replies: 5
    Last Post: 7th November 2009, 11:47 AM
  3. SIMS AM - Printing Reports
    By MattGibson in forum MIS Systems
    Replies: 4
    Last Post: 10th May 2009, 08:13 AM
  4. Deleting Reports in SIMS
    By enjay in forum MIS Systems
    Replies: 15
    Last Post: 23rd March 2009, 08:52 AM
  5. Dates in SIMS reports
    By cjohnsonuk in forum MIS Systems
    Replies: 0
    Last Post: 19th March 2008, 12:25 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •