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.

You'll need to supply more information. Edit your question and show some sample data and how you expect the output to look (do a mock-up in Excel of something). Also state what you have tried so far. — Alan Schofield, Jan 23 '18 at 12:41
It would also help us to understand what you have tried so far. What piece are you struggling with? — Wes H, Jan 23 '18 at 14:03

score 0 · Accepted Answer · answered Jan 23 '18 at 21:40

0

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

answered Jan 23 '18 at 21:40

aduguid

3,099
6
18
37

How can you display option sets within a SSRS report?

Excel mock-up

Report table layout

1 Answers1