Sims Assessment Missing Marks

[Ecalpemos2000]

I made a report in sims that looked up an aspect name and returns all the pupils and their results. I then tried to run a similar report but to return all pupils with the aspect name but with result set to IS Null, and although I know of pupils with no result Sims does not return any records.

When I first set this report up, it worked fine but since updates have been done, it does not work.

Any ideas???

[LosOjos]

This is a reply by TimH from when you previously asked a similar question in this thread.

I think it's basically impossible using standard SIMS/reports, I spent ages trying and ended up raising a Supportnet ticket which agreed !

We were running progress checks and wanted to know who had incomplete sets but you can't do this, if Johnny is doing French he should have French grades, if not doing Spanish he would show as having Spanish grades missing (which is useless).

It needs some way of know what is missing from what the individual student should have, I'm waiting for response to an escalation of the ticket.

tim

seems it's not currently possible to create the report you're trying to

[Ecalpemos2000]

my report runs and finds by aspect name the students who have a grade so it should, in theory just mean seting result to is Null, it works and returns pupils if result is set to is not null, therefore logic of database would suggest that the problem is within the coding of Sims.

[LosOjos]

I agree with you, it makes no sense when looking at it from the standard POV of how a database works, and yes it has something to do with Sims, which I'm afraid leaves the only option of raising a ticket at SupportNet as TimH did and hoping for the best

[Ecalpemos2000]

Will do, thanks very much.

[MattMitchell]

I agree with you, it makes no sense when looking at it from the standard POV of how a database works, and yes it has something to do with Sims, which I'm afraid leaves the only option of raising a ticket at SupportNet as TimH did and hoping for the best

There's not really a way to do it! I think you're imagining a query like this:

SELECT s.studentname, s.reg
FROM studentsview AS s
WHERE NOT EXISTS
(SELECT resultvalue FROM resultsview AS R
WHERE r.aspectid="Some Aspect Id"
AND r.studentid=s.studentid);

whereas what's actually happening is more like this:

SELECT s.studentname, s.reg, r
FROM studentsview AS s LEFT JOIN resultsview2 AS r
ON (s.studentid=r.studentid);

resultsview2:
SELECT * FROM resultsview
WHERE resultsview.aspectid="Some Aspect Id"
AND resultsview.resultvalue IS NULL;

There are no null result values! So all that happens is you get a list of all the students matching the criteria you want, along with a blank result.

The way round it, is not to filter on a null value! You can filter the result for aspect name, resultset, etc.; after that, either just display a count of results, or select the result value, and then you can sort the output afterwards to display either students with 0 results, or with a blank value (depending on how you've set up the report).

It might be that the new reporting engine changes all this, but we'll see!

Doing it the other way round is much easier - you can untick the "Include records with no such results" box, but there's no equivalent to get the disjoint set.