How can you display option sets within a SSRS report?

Question

I'm new to Stack overflow and new to SSRS report building. I'm currently building a report that needs to display each option from and option set in a different column I also need to pull date a last and next date range for each option it is page grouped by a company name and then further grouped by the employee's full name. any help would be very much appreciated.

Excel mock-up

Report table layout

I need it to out put like the Excel image ideally if possible, I've found the value id's but i'm stumped as to how if I can at all display them in the columns I've labelled.

Answer 1

It looks like you need to use a matrix control in your report. It will display your values in a pivot view like Excel.

Microsoft Documentation