Skip to main content

Can anyone advise on the best way to create a report which shows me all future ILT sessions, how many people are enrolled, how many spaces are available (if not full), and how many people are on the waiting list (if it is full).

 

I have managed to create a report that shows me all future enrolments on session but I'm not interested in the names of the people who are booked on (as it puts each booking on a separate row.  Ideally i would just have one row per session, and the numbers. e.g.

 

I know i could do this manually but ideally having something like this scheduled weekly would be amazing.  any thoughts?

I thought I had found the answer…..but not quite.

In New Reports there is one called Session - User Statistics.  The only problem is that there is no option to include the ‘session start date’ which seems like a glaring oversight.  If anyone knows a way to add it then I'm all ears.

Just tested the report called, Sessions - User Statistics and it lists all courses and sessions with the total enrolled on 1 line...try it out...it may be what you're looking for. It does also show sessions where no one is enrolled.

Think you may have just missed my post above yours :(

I see those options on the Filter tab...Is that what you need?

 

no. I want to actually see the start date for each session on the actual report.  Strangely it gives you the option to add a ‘course date’ which of course just comes out  blank.

OK I see what you mean...yes that seems to be a gap in the View Options. Will you post an idea for this?

You could in the meantime use a VLOOKLUP to match it with the session codes?

looks like it already exists:

 

 

OK thanks...voted up.

I’ve also voted for this and added the need to sort by session date.

 

KTJD we’re including the date in our session descriptions. It’s not ideal but it might help you to some degree while we wait for the field to be added to the report.

Reply


Terms & ConditionsCookie settings