+ Post New Thread
Results 1 to 3 of 3
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 ...
  1. #1
    jedwards2's Avatar
    Join Date
    Mar 2009
    Location
    Birmingham, UK
    Posts
    11
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Report for list of subjects taught in year x

    Hi folks

    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:

    Art
    English
    Maths
    Science
    Technology
    ...etc

    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. Reason: clarification

  2. #2

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,528
    Thank Post
    1,462
    Thanked 1,214 Times in 823 Posts
    Rep Power
    724
    Hi @jedwards2,

    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

  3. Thanks to LosOjos from:

    jedwards2 (20th March 2014)

  4. #3
    jedwards2's Avatar
    Join Date
    Mar 2009
    Location
    Birmingham, UK
    Posts
    11
    Thank Post
    1
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Many thanks, that's exactly what I needed.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Report for number of lates in the past week
    By chris_uk in forum MIS Systems
    Replies: 8
    Last Post: 19th November 2012, 10:58 AM
  2. HP - Get up to date for out of date PC trade-in
    By WStore_Dan in forum Our Advertisers
    Replies: 0
    Last Post: 19th May 2009, 09:46 AM
  3. Individual reports for students in SIMS
    By cjohnsonuk in forum MIS Systems
    Replies: 2
    Last Post: 25th March 2008, 11:27 AM
  4. Replies: 5
    Last Post: 26th July 2007, 09:33 AM
  5. Group Policy guidelines needed for students in years 3 - 6
    By richard in forum Wireless Networks
    Replies: 6
    Last Post: 8th March 2007, 01:36 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •