[sims] Reports - Filtering

[Shelly]

I'm designing a report to show me the number of late to lessons students have so we can issue detentions for over a certain amount.

 

Does anyone know how you get only the students with a positive number show when you run the report? So no student with zero are showing.

 

Hopefully that makes sense.

 

Many thanks

Shelly

[SJT]

Hi,

I may have got the wrong end of the stick here, so apologies if so.

I am assuming you are using a Lesson Monitor sub report.

There should be a tick box in the sub report for Include Records with no such mark.

This only becomes available when you have selected a data field from the sub report so might not show if you are just using the Count feature, maybe duplicate the sub report and add a field such as date so that you can then apply the tick to the filter.

[Shelly]

Hi,

I may have got the wrong end of the stick here, so apologies if so.

I am assuming you are using a Lesson Monitor sub report.

There should be a tick box in the sub report for Include Records with no such mark.

This only becomes available when you have selected a data field from the sub report so might not show if you are just using the Count feature, maybe duplicate the sub report and add a field such as date so that you can then apply the tick to the filter.

 

I've just tried your suggestion and the tick box for 'include records with no such lessonmark' seems to be unavailable to select or de-select. If I add another field it then creates multiple lines per student rather than just a total.

 

Looks like it will have to be a manual filter when exported.

 

Thank you for your help SJT

[SJT]

yes, it will do that, I would definitely be duplicating the sub report - one with a count and then adding a field to the duplicate version(with same date filters) and ticking both filter boxes so it only shows first record.

You can sort on sub reports too which may help, so it brings the ones you need to the top?

Sorry can't be more help.