+ Post New Thread
Results 1 to 13 of 13
MIS Systems Thread, *Urgent* SIMS Reports: Cannot set effective Date in Technical; Trying to run 2 reoprts on SIMS to export All Current Teaching Staff and All Current Support Staff with an ...
  1. #1

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,644
    Thank Post
    858
    Thanked 645 Times in 428 Posts
    Rep Power
    498

    Question *Urgent* SIMS Reports: Cannot set effective Date

    Trying to run 2 reoprts on SIMS to export All Current Teaching Staff and All Current Support Staff with an effective date of 1st September 2009 to reflect staff who have left and new staff

    However I cannot set an "Effective Date" parameter for staff!
    I can set one for Students and right at the start of a new report, but as soon as I set it defaults to Students and I cannot change the focus to Staff!

    I really need to be able to set the effective date so I can export all staff ready for importing them into AD

    Oh and the Staff are back on 1st september so it can't really wait till then

  2. #2
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,421
    Thank Post
    10
    Thanked 486 Times in 426 Posts
    Rep Power
    110
    I don't think you can, at least with the supplied report. You can choose to report on current and then future staff getting a complete list, but this may include people with leaving dates at the end of the holidays.

  3. #3

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,644
    Thank Post
    858
    Thanked 645 Times in 428 Posts
    Rep Power
    498
    Hmm - we used to be able to do this

  4. #4
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    4,996
    Thank Post
    120
    Thanked 280 Times in 258 Posts
    Rep Power
    106
    Will setting the academic year to the new one make any difference?

  5. #5

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,644
    Thank Post
    858
    Thanked 645 Times in 428 Posts
    Rep Power
    498
    Tried that - not worked

  6. #6
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    54
    Rather than looking for an effective date, include Filters with Fields for Employment Start and End dates - either by actual dates or other definitions (e.g. Start date is before 02/09/2009 and End date is 'null').
    Last edited by Sivadam; 13th August 2009 at 10:18 AM.

  7. Thanks to Sivadam from:

    Gatt (18th August 2009)

  8. #7
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    922
    Thank Post
    56
    Thanked 161 Times in 113 Posts
    Rep Power
    67
    Quote Originally Posted by Gatt View Post
    Trying to run 2 reoprts on SIMS to export All Current Teaching Staff and All Current Support Staff with an effective date of 1st September 2009 to reflect staff who have left and new staff

    However I cannot set an "Effective Date" parameter for staff!
    I can set one for Students and right at the start of a new report, but as soon as I set it defaults to Students and I cannot change the focus to Staff!

    I really need to be able to set the effective date so I can export all staff ready for importing them into AD

    Oh and the Staff are back on 1st september so it can't really wait till then
    You can use the staff contract end date.

  9. Thanks to penfold_99 from:

    Gatt (18th August 2009)

  10. #8
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    54
    .... is there an echo in here .... ?????

  11. #9
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    922
    Thank Post
    56
    Thanked 161 Times in 113 Posts
    Rep Power
    67
    Quote Originally Posted by Sivadam View Post
    .... is there an echo in here .... ?????
    nope just a bloke that does read all the posts

  12. #10
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    54
    Quote Originally Posted by penfold_99 View Post
    nope just a bloke that does read all the posts
    should there not have been a not in that reply.... .... or not?

  13. #11

    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    4,342
    Thank Post
    367
    Thanked 624 Times in 509 Posts
    Rep Power
    156
    Too.... many... not's... must... lye... down... not.

  14. #12
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    922
    Thank Post
    56
    Thanked 161 Times in 113 Posts
    Rep Power
    67
    Quote Originally Posted by Sivadam View Post
    should there not have been a not in that reply.... .... or not?
    should have been not but fat fingers to blame

  15. #13

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    6,644
    Thank Post
    858
    Thanked 645 Times in 428 Posts
    Rep Power
    498
    Cheers Guys - using the filters worked

SHARE:
+ Post New Thread

Similar Threads

  1. Set Date for Teachers
    By LeMarchand in forum How do you do....it?
    Replies: 8
    Last Post: 9th January 2009, 12:10 PM
  2. SIMS Effective Date
    By danIT in forum MIS Systems
    Replies: 2
    Last Post: 18th July 2008, 02:05 PM
  3. Formatting auto date in MS Access Reports
    By RabbieBurns in forum Windows
    Replies: 4
    Last Post: 24th June 2008, 02:41 PM
  4. set date and time BTech exam
    By Outpost in forum How do you do....it?
    Replies: 2
    Last Post: 19th March 2008, 12:21 PM
  5. Finally set a date!
    By Gatt in forum General Chat
    Replies: 12
    Last Post: 16th January 2008, 03:57 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
  •