+ Post New Thread
Results 1 to 15 of 15
MIS Systems Thread, Reports - Cause SIMS to crash in Technical; Would anyone running the latest version of SIMS .net be able to try the following for me. From the reports ...
  1. #1

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,113
    Thank Post
    403
    Thanked 619 Times in 566 Posts
    Rep Power
    180

    Reports - Cause SIMS to crash

    Would anyone running the latest version of SIMS .net be able to try the following for me.

    From the reports focus, there's a report that produces a list of all the pupils in a year group. I think this is a built in report. When you run this you choose on roll, leaver or ever on roll etc and choose a year group. If you run this for one year group then close out that report and go back and try and run it again for the next year group SIMS .net throws a wobbly and you have to close down the whole application in order to run the report again.

    Is this the same for you?

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Not sure what you mean mate, can you be more specific please.
    From the reports menu, you can run reports, in here there might be built-in ones that could give you those choices. I don't have a built-in one for this, but do have my own year list report.
    The other way would be a student list report, e.g. general list, and you could filter that by year group. This report might be easier for you to use and hopefully not crash the system.

  3. #3

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,113
    Thank Post
    403
    Thanked 619 Times in 566 Posts
    Rep Power
    180
    Sorry, I was doing it off memory.

    Somehow you can get to a 'focus' option then from here there's a report to output students list. I thought this was a built in report but perhaps not. Either way, when running this report you choose a status (on roll, leaver, ever on roll) then a year group (1,2,3) and then run it. If you choose on roll then year group 1 the report runs. You cannot then however go back to run the report on roll year group 2 as SIMS throws an exception.

    Does that make sense?

    1%20-%20Reports%20menu.jpg

  4. #4

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    That's a normal data report which is mostly likely handmade. It would say CES is the supplier if it was built in. Hand made ones can go funny, it might be timing out doing a filter or something, or running out of memory. Usually, it outputs the data to word / excel and then should be fine. You have to close the document or save as, before running the same report again, perhaps there could be some minor permissions issue where it's not allowing you access to the template again.

    Do you get a fault code? Search for solution could have a clue, or the 'more details' button could have revealing info.

    Unless the format it comes out in is particularly specific you would be better off with the student list reports that came out a few upgrades ago. I don't see the option in your image, which means you either don't have permission to run them, which is odd as they should be for all, or you are on a very old version of SIMS. Do you use custom permission groups?

  5. #5

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    You could design your own new report based on that old one and see if it's any better, and / or change the parameters slightly, like make it default to on-roll, as if not on-roll they wont be in a year group anyway.

    Also, if you can't see the error, it sometimes happens to me, you might have to ALT+TAB to fine the hidden window.

    Off home now, but will check in later to see how you get on.

  6. #6
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    434
    Thank Post
    146
    Thanked 77 Times in 61 Posts
    Rep Power
    31
    Quote Originally Posted by vikpaw View Post
    You have to close the document or save as, before running the same report again, perhaps there could be some minor permissions issue where it's not allowing you access to the template again.
    As Vik says, you have to close the document (and template) the first report produces (normally a word or excel document) before you can run the new report or it will say something like "Check the previous report is not still open". Are you definately doing that?

  7. #7

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,113
    Thank Post
    403
    Thanked 619 Times in 566 Posts
    Rep Power
    180
    That screenshot was one I grabbed from Google to show where I was talking about. The report is CES.

    Quote Originally Posted by superfletch View Post
    As Vik says, you have to close the document (and template) the first report produces (normally a word or excel document) before you can run the new report or it will say something like "Check the previous report is not still open". Are you definately doing that?
    Yes. Definately.

    The error is Object reference not set to an instance of an object.

  8. #8

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,113
    Thank Post
    403
    Thanked 619 Times in 566 Posts
    Rep Power
    180
    Focus > Student > School List by Year Group is the name of the report.

  9. #9
    superfletch's Avatar
    Join Date
    Nov 2007
    Location
    South
    Posts
    434
    Thank Post
    146
    Thanked 77 Times in 61 Posts
    Rep Power
    31
    Does it occur when you run it for a particular group or only when you have run it more than once (as you've described)?

    Also - since it is a CES report try reimporting the Capita standard reports:

    Reports | Import | Browse | Pick the latest version of "Predefined Reports" | Import.

    This should overwrite the report template in case there is an issue there.

  10. #10

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,113
    Thank Post
    403
    Thanked 619 Times in 566 Posts
    Rep Power
    180
    Quote Originally Posted by superfletch View Post
    Does it occur when you run it for a particular group or only when you have run it more than once (as you've described)?

    Also - since it is a CES report try reimporting the Capita standard reports:

    Reports | Import | Browse | Pick the latest version of "Predefined Reports" | Import.

    This should overwrite the report template in case there is an issue there.
    Only when you have run it more than once.

    We recently did the SIMS upgrade so the reports have been reimported.

    Does it do this for you or not?

  11. #11

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Okay, found the report now. It does not do that for me, i can run consecutively, with no problem. It's rather slow, i'd still try the new style reports which are from Student list as mentioned before.

    I'm on XP with Office 2007 on top of Office 2003.

  12. #12

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,113
    Thank Post
    403
    Thanked 619 Times in 566 Posts
    Rep Power
    180
    I'm using Office 2010. Do you have a machine to test that?

  13. #13

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    yep, hang on. win 7 i take it?

  14. #14

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    Win 7 / Office 2010.
    Not only can i recreate but i think i can solve it for you too.
    Is there any chance that the logged in windows user used to be a windows XP user? When we had this situation that was the cause due to problems with the roaming profile storing application data - now appdata differently. It also didn't help that that was a folder we redirected.
    Try a user with a non-roaming profile, or the main [domain] Administrator account ( which is usually local profile ), and i reckon it will work for you.
    I had exactly this issue with running photo reports for all of our users that were here when we had Win XP.
    Try running a photo report and i reckon you'll get the same issue.

  15. #15

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,848
    Thank Post
    671
    Thanked 1,383 Times in 1,145 Posts
    Rep Power
    350
    I've just been toying with some issues we've been having and the network manager thinks it's possibly due to some corruption in the appdata folder. We're going to try deleting parts of that folder and force a recreation, so the whole profile doesn't need resetting. I reckon it's going to be the Office folder or subfolders that are at fault.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Parameters in SIMS reports
    By iceman in forum MIS Systems
    Replies: 2
    Last Post: 22nd April 2011, 12:04 PM
  2. [SIMS] Deleting a Student Causes Server Crash
    By LosOjos in forum MIS Systems
    Replies: 0
    Last Post: 3rd March 2010, 11:46 AM
  3. SIMS - Reports
    By Edu-IT in forum MIS Systems
    Replies: 9
    Last Post: 31st January 2010, 08:09 AM
  4. SIMS AM - Printing Reports
    By MattGibson in forum MIS Systems
    Replies: 4
    Last Post: 10th May 2009, 08:13 AM
  5. Dates in SIMS reports
    By cjohnsonuk in forum MIS Systems
    Replies: 0
    Last Post: 19th March 2008, 12:25 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
  •