MIS Systems Thread, SIMS Report Writing in Technical; Can anybody help with creating a SIMS report to produce the room that a student is in for all the ...
11th February 2011, 12:54 PM #1
- Rep Power
SIMS Report Writing
Can anybody help with creating a SIMS report to produce the room that a student is in for all the periods of the current day... I'm going round in circles at the moment!
11th February 2011, 01:10 PM #2
It is possible to write a report for this, but it's not quite automatic - you'd have to specify the day when you run it.
Does it particularly need to be a report, could you not use the student's timetable for this info? Have you looked if any of the new Student Analysis/Student List/Timetables reports do what you want?
11th February 2011, 01:16 PM #3
- Rep Power
Brilliant... can you give me a pointer in the right direction on how to create the report. I was expecting to supply the day as a parameter anyway so that's fine.
And yes... it does specifically need to be a report
11th February 2011, 01:33 PM #4
It's quite long winded, but you have two choices of how to go about it.
The first (easiest) option is to make a report with "Period" focus. From there, you can add in all the information about classes that you want, but you'll have to filter to the correct student somehow (admission number?) because it won't be available from the student details "Reports" link. Set up a filter on "Day Name" to prompt at run time so you can select the correct day.
The second way is a little trickier but will allow you to run it from the Reports link on the student page, which in turn will make it easier to pick up the correct student. You need to build the report with "Student" focus, then add in "Classes" subreport, and then "Lessons", and finally "Periods". Again you need to add a filter, but just to the "Periods" subreport, again on "Day Name", and you'll want to un-tick the box on this report saying "Show results with no such periods" (or words to that effect).
It's long winded, but possible!
One thing to note is that the "Day Name" is not simple either, you may want to run a test report to show what the day names are in your system before you try filtering them, for instance for me, Wednesday period 1 is named "AWed:A1". You can run off all periods for a day by making sure the filter is "begins with" rather than "equal to", then just use the first part of the day name (e.e. "AWed" for all periods on a Wednesday)
11th February 2011, 04:02 PM #5
Perhaps to make it easier, you could not specify the day, just sort by period. It will give you the whole week, [or two] but easy to find what you want by inspection. Unless this is only step one in some other automated process.
By pete in forum MIS Systems
Last Post: 23rd April 2013, 10:26 AM
By TwoZeroAlpha in forum How do you do....it?
Last Post: 9th June 2011, 09:25 AM
By Innovate in forum MIS Systems
Last Post: 5th April 2011, 03:38 PM
By wesleyw in forum MIS Systems
Last Post: 16th June 2010, 11:47 AM
By sakwoya in forum MIS Systems
Last Post: 28th March 2010, 09:09 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)