+ Post New Thread
Results 1 to 6 of 6
MIS Systems Thread, Error 9 : Subscript out of range - SIMS .net reporting in Technical; My colleagues and I are all using the same version of Waters Edge and Excel and, in theory, all our ...
  1. #1

    Join Date
    Oct 2008
    Location
    London
    Posts
    1
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Error 9 : Subscript out of range - SIMS .net reporting

    My colleagues and I are all using the same version of Waters Edge and Excel and, in theory, all our laptops are set up the same.

    However, when an identical report is run with an output to Excel, their output seperates neatly into seperate sheets in the workbooks (e.g. ethnicity or first Language) and I get "Error 9 ; Subscript out of range"!!!

    We've checked Excel settings and we're all the same.

    What am I missing? Why am I getting the error?

    Thanks (in advance)
    Liz

  2. #2
    BJG
    BJG is offline
    BJG's Avatar
    Join Date
    May 2008
    Location
    Norwich
    Posts
    465
    Thank Post
    89
    Thanked 35 Times in 25 Posts
    Rep Power
    22
    Do you have individual logons for using these laptops...? If so, have you tried logging on to one of the others to see if it might be caused by something in your user settings...?

    Do you get a "Debug" button when the error comes up...? If so, click that and tell us what it says...

    PS This is the "Educational IT Jobs" section. This belongs under "Office Software" or "MIS Systems" in the Technical Forums area.
    Last edited by BJG; 17th May 2012 at 09:03 AM.

  3. #3

    Join Date
    Jan 2007
    Posts
    100
    Thank Post
    0
    Thanked 34 Times in 23 Posts
    Rep Power
    21
    Ensure that all windows updates have been applied to the workstation.

    Make sure you are on the latest version of SIMS (7.144) and import the latest report definition file.

    this can also be an issue with the report macros and the version of Office you are running.

  4. #4

    Join Date
    Jun 2011
    Location
    Crawley
    Posts
    10
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    why is this in the Educational IT Jobs forum?
    would it not get a better set of replies if it were in a better forum?

  5. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,851
    Thank Post
    672
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    I've moved to the MIS forum, where it will get more eyes on it.

    @Lizziepuff

    Try another user as has been mentioned. If you delete your 'My SIMS Documents' folder it will be recreated and should sort it. It's usually a template issue.
    It is also worth making sure your Office install is fully updated and patched. That grouping is done via a Macro, so also worth lowering your Macro security while testing to see if that makes a difference.

  6. #6

    Join Date
    Oct 2009
    Location
    Bournemouth
    Posts
    16
    Thank Post
    1
    Thanked 2 Times in 2 Posts
    Rep Power
    10
    Copy ReportData.enc from a working machine to your SIMS.net folder replacing the one thatís there
    Copy ReportData.enc and ReportData.xls from a working machine into My Documents\tempSimsRpt
    Run SIMS.net Ė and check that the previously broken reports now work
    Last edited by Ron_Bate; 28th May 2012 at 01:21 PM.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] MS Excel crashes on SIMS.net reports
    By samtayuk in forum MIS Systems
    Replies: 2
    Last Post: 21st January 2012, 01:22 PM
  2. [SIMS] SIMS.net Reporting
    By MikeW in forum MIS Systems
    Replies: 2
    Last Post: 24th November 2010, 11:11 AM
  3. ATEN KVM "Out of Range" problem
    By randle in forum Hardware
    Replies: 6
    Last Post: 2nd July 2008, 12:49 PM
  4. SIMS.net report problem
    By localzuk in forum MIS Systems
    Replies: 6
    Last Post: 20th May 2008, 03:22 PM
  5. Error Doing Tidy Backups in Sims.Net
    By tech_guy in forum MIS Systems
    Replies: 0
    Last Post: 7th January 2008, 01:58 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
  •