+ Post New Thread
Results 1 to 5 of 5
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 ...
  1. #1

    Join Date
    Oct 2010
    Location
    Cambridge
    Posts
    11
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    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!

    Thanks

  2. #2

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,432
    Thank Post
    1,432
    Thanked 1,160 Times in 794 Posts
    Rep Power
    705
    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?

  3. #3

    Join Date
    Oct 2010
    Location
    Cambridge
    Posts
    11
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0
    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

  4. #4

    LosOjos's Avatar
    Join Date
    Dec 2009
    Location
    West Midlands
    Posts
    5,432
    Thank Post
    1,432
    Thanked 1,160 Times in 794 Posts
    Rep Power
    705
    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)

  5. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    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.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 4
    Last Post: 23rd April 2013, 10:26 AM
  2. Report Writing
    By TwoZeroAlpha in forum How do you do....it?
    Replies: 10
    Last Post: 9th June 2011, 09:25 AM
  3. [SIMS] Any good options for writing to SIMS?
    By Innovate in forum MIS Systems
    Replies: 26
    Last Post: 5th April 2011, 03:38 PM
  4. Report writing
    By wesleyw in forum MIS Systems
    Replies: 6
    Last Post: 16th June 2010, 11:47 AM
  5. Replies: 7
    Last Post: 28th March 2010, 09:09 AM

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
  •