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.
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....
There are currently 1 users browsing this thread. (0 members and 1 guests)