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 ...
16th May 2012, 03:35 PM #1
- Rep Power
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)
17th May 2012, 09:02 AM #2
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.
18th May 2012, 09:58 AM #3
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.
21st May 2012, 10:42 AM #4
- Rep Power
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?
26th May 2012, 09:34 AM #5
I've moved to the MIS forum, where it will get more eyes on it.
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.
28th May 2012, 01:20 PM #6
- Rep Power
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.
By samtayuk in forum MIS Systems
Last Post: 21st January 2012, 01:22 PM
By MikeW in forum MIS Systems
Last Post: 24th November 2010, 11:11 AM
By randle in forum Hardware
Last Post: 2nd July 2008, 12:49 PM
By localzuk in forum MIS Systems
Last Post: 20th May 2008, 03:22 PM
By tech_guy in forum MIS Systems
Last Post: 7th January 2008, 01:58 PM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)