+ Post New Thread
Results 1 to 4 of 4
MIS Systems Thread, Running Reports against UDGs? in Technical; Hi everyone It seems sensible that you can run a report and filter against a User Defined Group in SIMS ...
  1. #1

    Join Date
    Mar 2012
    Posts
    46
    Thank Post
    17
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Cool Running Reports against UDGs?

    Hi everyone

    It seems sensible that you can run a report and filter against a User Defined Group in SIMS - but I can't fathom out how to do it? Any advice appreciated please.

    Thanks

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,589
    Thank Post
    638
    Thanked 1,306 Times in 1,088 Posts
    Rep Power
    336
    Yep, same as any other report really but depends on what your overall report is doing as to how you find it. Here's an example of a photo report i do, for UDG .

    SIMS UDG report filter.jpg

    Okay, to be fair, i guess it comes under the advanced reporting manual, where you select another table of information and do a sub-query on it, as you can see in the image.

    Let me know if you need more help on how to do that.
    Last edited by vikpaw; 31st May 2012 at 11:19 AM. Reason: clarity

  3. Thanks to vikpaw from:

    CarpeDiem (8th June 2012)

  4. #3

    Join Date
    Mar 2012
    Posts
    46
    Thank Post
    17
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by vikpaw View Post
    Yep, same as any other report really but depends on what your overall report is doing as to how you find it. Here's an example of a photo report i do, for UDG .

    SIMS UDG report filter.jpg

    Okay, to be fair, i guess it comes under the advanced reporting manual, where you select another table of information and do a sub-query on it, as you can see in the image.

    Let me know if you need more help on how to do that.

    Sorted, you always have the answers, thanks!

  5. #4

    Join Date
    Apr 2013
    Location
    Nottingham
    Posts
    20
    Thank Post
    11
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Hi

    I've just been trying user defined groups to target a set of pupils to report on.

    I tried the query the other way round:

    I focussed on the Group and then reported on students details within the group.

    It seemed to work a bit faster than doing it Focus on students and then filter by group membership

    Hope this helps (although the thread is 10 months old)

    Regards

    Phil

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Running reports on next year's timetable for data extract
    By anne1 in forum MIS Systems
    Replies: 1
    Last Post: 1st September 2011, 02:53 PM
  2. [SIMS] Client Not Responding Running Reports
    By tmcd35 in forum MIS Systems
    Replies: 6
    Last Post: 13th September 2010, 01:42 PM
  3. Replies: 6
    Last Post: 16th December 2009, 11:02 AM
  4. Running a report against a deleted reg group
    By adamf in forum MIS Systems
    Replies: 1
    Last Post: 30th January 2009, 08:26 PM
  5. Replies: 3
    Last Post: 10th March 2006, 01:54 PM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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