+ 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. 12th August 2009, 01:21 PM #1
    Gatt
    Gatt is offline

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    5,930
    Thank Post
    777
    Thanked 483 Times in 342 Posts
    Rep Power
    276
    Send a message via MSN to Gatt Send a message via Skype™ to Gatt

    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. IDG Tech News
  3. 12th August 2009, 01:27 PM #2
    DMcCoy
    DMcCoy is offline
    DMcCoy's Avatar
    Join Date
    Oct 2005
    Location
    Isle of Wight
    Posts
    3,230
    Thank Post
    10
    Thanked 443 Times in 387 Posts
    Rep Power
    101
    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.
  4. 12th August 2009, 01:55 PM #3
    Gatt
    Gatt is offline

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    5,930
    Thank Post
    777
    Thanked 483 Times in 342 Posts
    Rep Power
    276
    Send a message via MSN to Gatt Send a message via Skype™ to Gatt
    Hmm - we used to be able to do this
  5. 12th August 2009, 03:24 PM #4
    ChrisH
    ChrisH is online now
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    4,960
    Thank Post
    100
    Thanked 243 Times in 222 Posts
    Rep Power
    98
    Will setting the academic year to the new one make any difference?
  6. 12th August 2009, 03:32 PM #5
    Gatt
    Gatt is offline

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    5,930
    Thank Post
    777
    Thanked 483 Times in 342 Posts
    Rep Power
    276
    Send a message via MSN to Gatt Send a message via Skype™ to Gatt
    Tried that - not worked
  7. 13th August 2009, 10:09 AM #6
    Sivadam
    Sivadam is offline
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    50
    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.

  8. Thanks to Sivadam from:

    Gatt (18th August 2009)
  9. 13th August 2009, 11:56 AM #7
    penfold_99
    penfold_99 is offline
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    802
    Thank Post
    43
    Thanked 136 Times in 90 Posts
    Rep Power
    60
    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.

  10. Thanks to penfold_99 from:

    Gatt (18th August 2009)
  11. 13th August 2009, 12:14 PM #8
    Sivadam
    Sivadam is offline
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    50
    .... is there an echo in here .... ?????
  12. 13th August 2009, 12:23 PM #9
    penfold_99
    penfold_99 is offline
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    802
    Thank Post
    43
    Thanked 136 Times in 90 Posts
    Rep Power
    60
    Quote Originally Posted by Sivadam View Post
    .... is there an echo in here .... ?????
    nope just a bloke that does read all the posts
  13. 13th August 2009, 12:30 PM #10
    Sivadam
    Sivadam is offline
    Sivadam's Avatar
    Join Date
    Feb 2009
    Location
    Dronfield - Derbyshire
    Posts
    1,449
    Thank Post
    136
    Thanked 208 Times in 175 Posts
    Rep Power
    50
    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?
  14. 13th August 2009, 01:44 PM #11
    matt40k
    matt40k is offline
    matt40k's Avatar
    Join Date
    Jun 2008
    Location
    Ipswich
    Posts
    3,595
    Thank Post
    308
    Thanked 451 Times in 380 Posts
    Rep Power
    106
    Too.... many... not's... must... lye... down... not.
  15. 13th August 2009, 02:08 PM #12
    penfold_99
    penfold_99 is offline
    penfold_99's Avatar
    Join Date
    Feb 2008
    Location
    East Sussex
    Posts
    802
    Thank Post
    43
    Thanked 136 Times in 90 Posts
    Rep Power
    60
    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
  16. 18th August 2009, 09:09 AM #13
    Gatt
    Gatt is offline

    Gatt's Avatar
    Join Date
    Jan 2006
    Posts
    5,930
    Thank Post
    777
    Thanked 483 Times in 342 Posts
    Rep Power
    276
    Send a message via MSN to Gatt Send a message via Skype™ to Gatt
    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
« Problem with batch backup or SIMS.net using DBAttach | ePortal mobile access »

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
  •  

Forum Rules