[sims] Printing from an Assessment Defined Group

[SouthCoastSaint]

I thought I needed something so simple, but just can't see a way to do it.

 

Medical would like a photo report of all students with Care Plans. I have created an Assessment Defined Group (also a Discover one) but just can't see a way to bring it into the general student list to allow me to print from it.

 

Care plan has also been added as a Medical Condition, so I can actually pull that column in to the General Student List but still fail to see how I can filter by that column. I would like something really simple so that Medical can use it without much manipulation. Am I missing something?

 

Thanks

[vikpaw]

You're probably better off writing a custom report which filters on their conditions and also on the defined group.

You can add the group membership table and then do a sub-query on group name of the group is '....'

 

If you want to do it by student list reports, i can't see how to filter on medical, so they'd need to export to Excel, order by that column and ignore the rest. Which seems like too much faff.

[SouthCoastSaint]

Thanks Vic. I couldn't get the report filter to work - I did try that. Will look again next week.

 

I can't believe that user defined/assessment defined groups are not a selectable option in every part of Sims, its very hit and miss. The thing about the medical field is that we have have Care Plan as a condition, which I can drag in as a column in the report. However when I click filter it very unhelpfully doesn't offer me the column to filter by, just the standard one like year group. Very frustrating as it seems such a simple thing.

 

- - - Updated - - -

 

Thanks Vic. I couldn't get the report filter to work - I did try that. Will look again next week.

 

I can't believe that user defined/assessment defined groups are not a selectable option in every part of Sims, its very hit and miss. The thing about the medical field is that we have have Care Plan as a condition, which I can drag in as a column in the report. However when I click filter it very unhelpfully doesn't offer me the column to filter by, just the standard one like year group. Very frustrating as it seems such a simple thing.

[vikpaw]

Try something like this:

[eean]

Something important that VicPaw is showing you, but I think you may have missed is unticking 'include records with no such members'. Using this technique, you should be able to avoid using an assessment defined group entirely.

To confirm, you should be in the 'Report -> Design Report' part of SIMS, not the 'General Student List' part of SIMS. The former is far more powerful. Once you have created the report, you can save it and simply click to run.

 

If you are not familiar with this part of SIMS, I would recommend reading the lengthy manual on the subject, as you are going to have to deal with sub-queries.

To point you in the right direction:

The focus should be on the student

You can go the the 'medical' section and you can then find medical conditions. There you can apply the filter and untick that box.

You'll need to create an RTF report to be able to print the photographs.

[SouthCoastSaint]

Thanks for help with this. I have finally managed to get it working using the Medical Condition Description as the filtered field. Our nurses will be very happy!

 

Out of interest, I had a reply from Capita last week:

 

In regards to your case having attempted to create the report in question unfortunately the reporting module does not allow this specific report to just show the photos of all the students with care plans.

 

Using the fields provided the reporting module does not allow you to further filter the User defined groups to only show the photos of certain students.

 

The end product for this report as expected will display a list of pupils/the chosen user defined groups/medical condition.

 

The report will produce a list of all pupils (with photos) who show in these user defined groups with the medical condition attached to the records who have the medical condition of care plan.

 

Unfortunately there is not a way to separate these records to just show the photos of those with the medical condition of care plan.

 

If you have any further problems please contact me and I will advise you further.

[vikpaw]

Does that even make sense?!

[SouthCoastSaint]

Does that even make sense?!

 

Well luckily the Edugeek answers made sense (and worked). We all know where to come..

[PhilNeal]

@SouthCoastSaint I've followed this up and sorry you got the wrong answer. The correct procedure wasn't followed at our end.

[SouthCoastSaint]

Thank you Phil. The main thing is Nurses now have the report the needed.