[sims] Report Filtering Problem [Solved]

[Stuart_C]

Hi there,

I'm trying to create a report and I'm having some issue getting it to filter properly and I was wondering if anyone can help.

 

It've very basic, name and house and then a Count of a subreport to list the students who have got a specific achievement and the number they have. It mostly works, the problem is that my list has all the students in, the majority with a count of 0. I need to filter the list so it just shows those students with a count value greater than zero. I can't seem to filter on the "count" of a subreport. I also can't untick "Include records with no such student conduct informations" as I haven't added any fields. And if I do I no longet get the "count".

 

I can then put that list into an RTF template to produce the notice I need.

 

Any advice?

[Stuart_C]

Ah jsut found my own answer. You need to filter it twice, once on the sub-report and once in the main filter going into the subreport again. Complicated....