MIS Systems Thread, [solved] Missing data in SIMS.net Report in Technical; I'm trying to create several reports in SIMS for use with the CommandReporter tool so I can extract data for ...
26th November 2009, 06:10 PM #1
[solved] Missing data in SIMS.net Report
I'm trying to create several reports in SIMS for use with the CommandReporter tool so I can extract data for an in-house application.
Everything seems to work fine, but in a few of the reports I've noticed some discrepancies. For example, one report details all current students and includes data such as admission, name, DOB, year, house, reg.
The report works and list all the students, but the year, house and reg data of students that have been added into SIMS since the start of this school year are blank. However, I can look these same students up within SIMS and all the data is there.
I'm not that familiar with SIMS and haven't used it much, but I created the report using the report designer, which seemed quite straightforward to use. I selected the People->Student focus, based on all students, then selected the details I needed from the Basic and Registration lists of available fields.
I added a filter to only include current students. I realise I could have based it on students on roll at the second stage of the design wizard, but that produced some other discrepancies (missing a few students completely).
Am I doing something a bit dim here, or is there something about the way SIMS works I don't know about that would explain this.
Any help would be appreciated.
Last edited by MrLudwig; 27th November 2009 at 01:36 AM.
26th November 2009, 06:16 PM #2
I'm wondering if you're inadvertently running it on a date in the past (from say back in September before this data was in place).
Thanks to kmount from:
MrLudwig (27th November 2009)
27th November 2009, 01:34 AM #3
Ah, it seems so obvious now .
Thank you very much kmount, that was spot on.
27th November 2009, 09:43 AM #4
No problem at all
By Shuriken1 in forum MIS Systems
Last Post: 25th August 2012, 01:25 PM
By NetworkGeezer in forum MIS Systems
Last Post: 16th February 2010, 10:22 PM
By shappaeye in forum MIS Systems
Last Post: 12th June 2008, 10:25 AM
By localzuk in forum MIS Systems
Last Post: 20th May 2008, 04:22 PM
By MARKR in forum MIS Systems
Last Post: 21st February 2008, 10:54 AM
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)