report problem

[Jamie_a]

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?

[the.damon]

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

[Jamie_a]

row is year and columns subject,

 

I also get multiple instances if I output to excel

[the.damon]

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.