+ Post New Thread
Results 1 to 12 of 12
MIS Systems Thread, SIM's Reports in Technical; Is their a way of extracting the Information held in SIM's Marksheets in a report and not Individual Reports so ...
  1. #1
    Steven_Cleaver's Avatar
    Join Date
    Jul 2008
    Location
    Birmingham
    Posts
    458
    Thank Post
    171
    Thanked 81 Times in 65 Posts
    Rep Power
    50

    SIM's Reports

    Is their a way of extracting the Information held in SIM's Marksheets in a report and not Individual Reports so in essence design a Report that could Extract all of my Report Grades for Year 7 exporting this info from the Marksheet wouldn't work as I would need it as a report I could design. I have had a look at Designing the Report but can't easily see where to add the information from the Marksheets if this is feasible.

    The reason I want it in a Report is I want to use CommandReporter to extract this info, I have had a look at a couple of the Threads on this but can't easily see if it is feasible to extract the Aspects held on the Marksheets this way.

    Many thanks

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    yes it is possible, but you need to have lots of filters to make it pull back a finite subset of data. i have a couple of reports that bring back the 'result' field, for specific subject named aspects linked to user selectable resultsets. we use it for proof reading. is that the sort of thing you were thinking of..?

  3. Thanks to vikpaw from:

    Steven_Cleaver (5th December 2012)

  4. #3
    Steven_Cleaver's Avatar
    Join Date
    Jul 2008
    Location
    Birmingham
    Posts
    458
    Thank Post
    171
    Thanked 81 Times in 65 Posts
    Rep Power
    50
    Hi Vikpaw that sounds like it I am just having difficulty in finding the right fields to get the results out I can get the Aspect names out but am having difficulty getting the right Fields to display the data for these and get your bit about filtering is their any chance you can point us in the right direction with the fields I need to include in the report to get the Results out.

  5. #4
    Steven_Cleaver's Avatar
    Join Date
    Jul 2008
    Location
    Birmingham
    Posts
    458
    Thank Post
    171
    Thanked 81 Times in 65 Posts
    Rep Power
    50
    Hi Vikpaw had another dig around in SIM's reports from what you said and I think I can now see where to get this but looks like a bit of work creating these to extract the information I need, thanks again.

  6. #5

    Join Date
    Mar 2011
    Location
    Bristol
    Posts
    119
    Thank Post
    24
    Thanked 24 Times in 20 Posts
    Rep Power
    17
    Hi Steven,

    I don't know if this is something specific to our school, but I have noticed that including multiple assessment result sub-reports makes them run incredibly slowly! Not only that, I find that if I have any more than 3 or 4 the report will just hang or SIMS will crash. For this reason I try to avoid adding assessment fields into SIMS reports. However, I can see why this is your only option here!

    Be wary of results with no result set, as you may find multiple results coming through. The 'display first result only' tick box in the sub reports filter may come in handy here (or filtering the subreport by result date might be more effective.

  7. Thanks to Ecclesbury from:

    Steven_Cleaver (5th December 2012)

  8. #6
    Steven_Cleaver's Avatar
    Join Date
    Jul 2008
    Location
    Birmingham
    Posts
    458
    Thank Post
    171
    Thanked 81 Times in 65 Posts
    Rep Power
    50
    Hi Ecclesbury

    The first couple I ran were a bit slow as I was including a lot of stuff I didn't need but when I reduced this they are still a bit slow but running these on another machine so it doesn't effect the other stuff I am doing, didn't crash though but our SIM's Server and my machine are reasonably Hig Spec. Thanks for the tip display first result for the sub reports learning more as I go along.

  9. #7

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    i would go for filtering the sub-table. pulling in only the first result is random, and likely that you want them all, i.e. the results!

  10. #8
    Steven_Cleaver's Avatar
    Join Date
    Jul 2008
    Location
    Birmingham
    Posts
    458
    Thank Post
    171
    Thanked 81 Times in 65 Posts
    Rep Power
    50
    Cheers Vikpaw with the help of our LEA I have got it to show the Grades for our Inteim reports so now know what I am after is feasible but just need to play with the filters and order to get it to display the right info and not to show multiple data multiple times just need to work how to best structure this.

  11. #9

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    yes, that's the thing, it's very easy to end up with a cross product, and then nothing lines up well. sometimes you just have to dump to Excel and ask it to remove dupes.

  12. #10
    Steven_Cleaver's Avatar
    Join Date
    Jul 2008
    Location
    Birmingham
    Posts
    458
    Thank Post
    171
    Thanked 81 Times in 65 Posts
    Rep Power
    50
    Your right playing with this it is difficult to get it out how you want so am thinking of getting it out in as clean as format as possible might need multiple reports for the amount of data I am extracting and for its various uses then possibly use VBA or Visual Studio to clean up the sheet and extract the data from the sheet so have it is in the format I want, then when I have this working use Command Line Reporter scripted and scheduled to automate the Report Extraction. To be honest what I am after is automating our data analysis from the marksheets at the moment takes us about a day and a half to produce the Analysis for a year and obviously if groups\classes changed this is out of data but if I can automate the extraction can virtually make this live at most a day behind as I would probably update every evening.

    My issue is we are starting to use our data in school much more heavily from Analysis of pupil progress to Staff performance to Department Performance to Whole School Performance and using these to target our intervention strategies, students, departments and whole school using the schools Qualty Assurance system so need the data we are using to be up to date and as accuarte as possible as we are now heavily reliant on this.

    I'll try and document this as I go in case it is useful to anyone else.

  13. #11

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,843
    Thank Post
    671
    Thanked 1,381 Times in 1,143 Posts
    Rep Power
    349
    Have you thought of using Discover..? It won't do everything, but may shed some of the reliance on exported numbers.
    I have heard of some systems, where the data is shipped over to another SQL instance or Access even, then analysis is produced linked to this secondary data source. so you can have semi-live links / analysis.

  14. #12
    Steven_Cleaver's Avatar
    Join Date
    Jul 2008
    Location
    Birmingham
    Posts
    458
    Thank Post
    171
    Thanked 81 Times in 65 Posts
    Rep Power
    50
    I have had a go with Discover but it doesn't give me quite what we want although as it develops this may change, I am also sort of looking as you say at shipping over to another SQL instance or using Access and connecting creating ODBC data source instance to extract data only and might to be honest use multiple methods as different methods may suite what we want to extract and how we want to use it.

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] Re: SIMS MIS reporting error
    By philserre in forum MIS Systems
    Replies: 3
    Last Post: 28th January 2013, 11:00 AM
  2. [SIMS] SIMS .net Report Supplier
    By Shuriken1 in forum MIS Systems
    Replies: 7
    Last Post: 25th August 2012, 12:25 PM
  3. [SIMS] SIMS/SLG Report (Conduct) Card Link!
    By Sivadam in forum MIS Systems
    Replies: 2
    Last Post: 19th May 2011, 09:05 AM
  4. [SIMS] SIMS Annual Reporting
    By laserblazer in forum MIS Systems
    Replies: 12
    Last Post: 6th December 2010, 11:03 AM
  5. [SIMS] SIMS.net Reporting
    By MikeW in forum MIS Systems
    Replies: 2
    Last Post: 24th November 2010, 11:11 AM

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
  •