+ Post New Thread
Results 1 to 7 of 7
MIS Systems Thread, Reporting in SIMS - cannot seem to filter on new Reg Groups in Technical; The next year's pastoral strucutre has been changed and pupils promoted in preparation for Sept. I am currently trying to ...
  1. #1

    Join Date
    Jul 2014
    Location
    Warrington
    Posts
    5
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Question Reporting in SIMS - cannot seem to filter on new Reg Groups

    The next year's pastoral strucutre has been changed and pupils promoted in preparation for Sept.
    I am currently trying to create a report in SIMS that I can run with the effective date in Sept. I can set up the Report fine and if i include a Registration field and then run with a September date this report works as expected ie the pupils have the new Reg classes.
    My issue is that I want to add a filter to the Report so can filter by Reg Group but even when pressing prompt at run time and changing the effective date I only have the current reg groups to choose from and not the new ones. Please can someone help as it is driving me mad!!!!

    I have tried:
    • opening an existing report and re-adding in Reg Group filter
    • starting a report from scratch
    • setting my academic year to next year

  2. #2
    SteveB's Avatar
    Join Date
    Jun 2008
    Location
    Midlands
    Posts
    130
    Thank Post
    19
    Thanked 4 Times in 4 Posts
    Rep Power
    13
    Works ok for me. Are the students assigned to the reg groups on the date you are using as an effective date? IE Accademic yr is 01/09 and class association is 03/09. Thus running the report on 01/09 would not give you the choice to select the new reg groups as they are not populated until the 3rd . .

  3. #3

    Join Date
    Jul 2014
    Location
    Warrington
    Posts
    5
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thanks for your reply.
    The pupils are assigned to classes - if I filter the report by Year group and include a reg group field the report shows correctly.
    It is when I filter by Reg Group that the tick boxes do not show as correct classes.
    For example the Year 2 classes are currently 2GH 2JB 2EW for next year new classes have been added so they read 2JO 2SW 2JH.
    At the point of running the Report I change the effective date to next year and from the tick boxes of Reg groups to choose from I only have 2GH 2JB 2EW???

  4. #4
    SteveB's Avatar
    Join Date
    Jun 2008
    Location
    Midlands
    Posts
    130
    Thank Post
    19
    Thanked 4 Times in 4 Posts
    Rep Power
    13
    From what date are the pupils assigned to the classes though? The effective date must be selected within their group membership for the reg groups to show up. It is not good selecting 01/09/2014 if the pupils do not turn up until 03/09/2014.

    Just a guess but I cannot think what else it would be

  5. #5

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,445
    Thank Post
    369
    Thanked 650 Times in 531 Posts
    Rep Power
    160
    Tools > Validate Memberships

  6. #6

    Join Date
    Jul 2014
    Location
    Warrington
    Posts
    5
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Thanks for the suggestions. Just in case you ever come across this issue Capita advised me to include Group Memberships (Historical) blue box in my report and under this select Group name. Now apply a filter to this field (using the red box on the right) as follows: Group type is Reg Group AND Active on is 5th Sept 2014 AND Group Name equals (prompt at run time). Now when running my Report I select an effective date in Sept and type the exact name of the new reg group (eg 2JO) and this works fine.

  7. #7
    SteveB's Avatar
    Join Date
    Jun 2008
    Location
    Midlands
    Posts
    130
    Thank Post
    19
    Thanked 4 Times in 4 Posts
    Rep Power
    13
    Glad you got it sorted, however the standard approach does seem to work fine for the green abbey test database.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 3
    Last Post: 27th March 2014, 12:09 PM
  2. Replies: 8
    Last Post: 12th November 2013, 09:31 PM
  3. Replies: 1
    Last Post: 12th July 2013, 08:03 PM
  4. [SIMS] Individual Reports in SIMS
    By tben2505 in forum MIS Systems
    Replies: 8
    Last Post: 6th March 2012, 01:07 PM
  5. [SIMS] Reporting in SIMS Help
    By 01hanstu in forum MIS Systems
    Replies: 30
    Last Post: 12th October 2011, 09:42 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
  •