Skip to main content

Session subscription report


Forum|alt.badge.img+2
  • Helper II
  • 239 replies

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?

Did this post help you find an answer to your question?

10 replies

Forum|alt.badge.img+2
  • Author
  • Helper II
  • 239 replies
  • October 30, 2023

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.


lrnlab
Hero III
Forum|alt.badge.img+8
  • Hero III
  • 4788 replies
  • October 30, 2023

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.


Forum|alt.badge.img+2
  • Author
  • Helper II
  • 239 replies
  • October 30, 2023

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


lrnlab
Hero III
Forum|alt.badge.img+8
  • Hero III
  • 4788 replies
  • October 30, 2023

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

 


Forum|alt.badge.img+2
  • Author
  • Helper II
  • 239 replies
  • October 30, 2023

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.


lrnlab
Hero III
Forum|alt.badge.img+8
  • Hero III
  • 4788 replies
  • October 30, 2023

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?


Forum|alt.badge.img+2
  • Author
  • Helper II
  • 239 replies
  • October 30, 2023

lrnlab
Hero III
Forum|alt.badge.img+8
  • Hero III
  • 4788 replies
  • October 30, 2023

OK thanks...voted up.


  • Contributor II
  • 48 replies
  • January 11, 2024

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.


JesusValencia
Novice II

I had come across a similar situation where I needed a report that could generate a list of Usernames who where in the “Pending Admin Approval” 

I created a new report using the Users - ILT Sessions. Then selected the appropriate filters.  ​@KTJD Did you select the Session Start date? This did work on my end and generated the dates. 

there was NO option for seat count on this report set, only gave me options for Attendance Status. 


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings