+ Post New Thread
Results 1 to 5 of 5
MIS Systems Thread, Pick out latest result in report in Technical; I have been asked to create a report in SIMS that pulls in results from various aspects butI can't work ...
  1. #1

    sparkeh's Avatar
    Join Date
    May 2007
    Posts
    6,753
    Thank Post
    1,279
    Thanked 1,651 Times in 1,106 Posts
    Blog Entries
    22
    Rep Power
    506

    Pick out latest result in report

    I have been asked to create a report in SIMS that pulls in results from various aspects butI can't work out how to only return the latest result.

    So if I have an aspect called 'Maths result' with many results entered can I just pick out the latest result entered?

    I can see that you can filter the results by result date but I don't think that this helps much as you need to know the date that the result you want was entered on.

    Thanks in advance

  2. #2

    sparkeh's Avatar
    Join Date
    May 2007
    Posts
    6,753
    Thank Post
    1,279
    Thanked 1,651 Times in 1,106 Posts
    Blog Entries
    22
    Rep Power
    506
    hmm think I got it: I can filter by result set as well to pick out the correct info.

  3. #3
    mioiskute's Avatar
    Join Date
    Feb 2009
    Posts
    17
    Thank Post
    4
    Thanked 0 Times in 0 Posts
    Blog Entries
    1
    Rep Power
    0
    Do you use the result set? We use the result set for each term such as: Year 7 Term 1, Year 7 Term 2... So when we link the aspect to the result set, the result will come out in term such as Maths effort grade Year 7 Term 1. If we do a report filter it with the result set, we can have the latest one.
    I'm not sure that I understand exactly your problem but I hope it can help.

  4. #4
    mioiskute's Avatar
    Join Date
    Feb 2009
    Posts
    17
    Thank Post
    4
    Thanked 0 Times in 0 Posts
    Blog Entries
    1
    Rep Power
    0
    oh, you solved it by yourself

  5. #5

    sparkeh's Avatar
    Join Date
    May 2007
    Posts
    6,753
    Thank Post
    1,279
    Thanked 1,651 Times in 1,106 Posts
    Blog Entries
    22
    Rep Power
    506
    Sorry I didn't exactly explain it very well (I am not that used to creating reports in SIMS).

    But yes, we do use a result set for each term so I can filter by the correct set

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 2
    Last Post: 12th June 2010, 06:37 AM
  2. [Video] Pick Me
    By mattx in forum Jokes/Interweb Things
    Replies: 1
    Last Post: 18th October 2009, 09:45 AM
  3. Help me pick a server
    By Joe_Pineapples in forum Hardware
    Replies: 4
    Last Post: 7th July 2009, 12:14 PM
  4. Pick up a bargain!
    By laserblazer in forum General Chat
    Replies: 2
    Last Post: 15th February 2009, 11:15 AM
  5. Epson EMP - 74 Fails to pick up PC
    By speckytecky in forum Hardware
    Replies: 1
    Last Post: 17th September 2007, 12: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
  •