+ Post New Thread
Results 1 to 4 of 4
MIS Systems Thread, report problem in Technical; I`ve created a report to display the number of behaviour incidents by department in SIMS. But when I run it ...
  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

    report problem

    I`ve created a report to display the number of behaviour incidents by department in SIMS. But when I run it we sometimes get upto 20 occurences of the same incident. The reports set up as follows:

    Report Name: red card Analysis by Subject

    effective on: 25/04/2007



    l Data area: Student - Population: On roll

    l Data Fields: Name & Reg, Year group; for behaviour of each student: Location

    l Filter Students where:
    Behaviour exist where Date is between 20 Apr 2007 and 20 Apr 2007 [?] "Date is between"
    and Type is Red Card Other (specify)

    l Use the default sort order: Surname, Legal Forename

    l Default Output: Analysis
    Report Title:

    Does anyone have any quick ideas of what might be the problem?

  2. #2

    Join Date
    Apr 2007
    Location
    NW1
    Posts
    38
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: report problem

    You're outputting this to analysis?? What column and rows are you selecting?

  3. #3
    Jamie_a's Avatar
    Join Date
    Dec 2006
    Location
    Sheffield
    Posts
    82
    Thank Post
    9
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: report problem

    row is year and columns subject,

    I also get multiple instances if I output to excel

  4. #4

    Join Date
    Apr 2007
    Location
    NW1
    Posts
    38
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Re: report problem

    First of all, have you unticked 'Include records with no such events' in the Behaviour filter?

    You didnt mention it but without that you will receive incorrect values. rather than use the normal filter page, use the red book filter in the data fields section. This is what i used and the report worked correctly.

SHARE:
+ Post New Thread

Similar Threads

  1. report assist
    By chrbb in forum Educational Software
    Replies: 44
    Last Post: 19th June 2009, 11:19 AM
  2. Damage Report
    By alan-d in forum School ICT Policies
    Replies: 0
    Last Post: 26th September 2007, 10:44 AM
  3. Report Students with *.mp3 *.avi *.ogg
    By roland in forum How do you do....it?
    Replies: 8
    Last Post: 24th August 2007, 04:50 PM
  4. sism report
    By Jamie_a in forum MIS Systems
    Replies: 0
    Last Post: 2nd July 2007, 10:15 AM
  5. Report Types
    By mark80 in forum MIS Systems
    Replies: 6
    Last Post: 15th May 2007, 03:35 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
  •