[SIMS] SIMS Report Writing

[Progeniga]

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!

Thanks

[LosOjos]

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?

[Progeniga]

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

[LosOjos]

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)

[vikpaw]

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.