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 ...
7th September 2010, 10:21 AM #1
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
7th September 2010, 10:48 AM #2
hmm think I got it: I can filter by result set as well to pick out the correct info.
7th September 2010, 11:01 AM #3
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.
7th September 2010, 11:02 AM #4
oh, you solved it by yourself
7th September 2010, 11:03 AM #5
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
By LosOjos in forum MIS Systems
Last Post: 12th June 2010, 07:37 AM
By mattx in forum Jokes/Interweb Things
Last Post: 18th October 2009, 10:45 AM
By Joe_Pineapples in forum Hardware
Last Post: 7th July 2009, 01:14 PM
By laserblazer in forum General Chat
Last Post: 15th February 2009, 12:15 PM
By speckytecky in forum Hardware
Last Post: 17th September 2007, 01:54 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)