MIS Systems Thread, Report for list of subjects taught in year x in Technical; Hi folks
A SIMS question: I have a need several times a year to generate a list of subjects currently ...
20th March 2014, 10:48 AM #1
Report for list of subjects taught in year x
A SIMS question: I have a need several times a year to generate a list of subjects currently taught in a particular year group. I'd like to be able to design/run a report with which I can select a year group and end up with a single list of subjects without picking through class codes/duplicates etc. Is this possible?
For example, I'd like to end up after selecting, say, year 8 with a list that looks like:
I've searched on here and asked our SIMS guy and he can't think how to do it.
Last edited by jedwards2; 20th March 2014 at 10:50 AM.
20th March 2014, 11:21 AM #2
create a new report, focus should be "School > Subject".
Add the 'Subject' field.
For your filters, select the 'Classes for subject' subreport and set the condition to 'exist'. Click in to the 'Classes for subject' section, add a new filter on 'Students' subreport, again the condition should be 'exist'. Finally, add a filter to the 'Student's subreport on either 'Year Group' or 'National Curriculum Year' (or anything else you want to for that matter!) and make sure to tick 'prompt at runtime'.
When you're done, your filters should look like this:
The rest is up to you, carry on and present it however you like
Thanks to LosOjos from:
jedwards2 (20th March 2014)
20th March 2014, 11:54 AM #3
Many thanks, that's exactly what I needed.
By chris_uk in forum MIS Systems
Last Post: 19th November 2012, 10:58 AM
By WStore_Dan in forum Our Advertisers
Last Post: 19th May 2009, 09:46 AM
By cjohnsonuk in forum MIS Systems
Last Post: 25th March 2008, 11:27 AM
By humpda in forum Scripts
Last Post: 26th July 2007, 09:33 AM
By richard in forum Wireless Networks
Last Post: 8th March 2007, 01:36 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
Tags for this Thread