SSRS reports

(0) Share

Report

Posted on by Community Member Microsoft Employee

In SSRS Reports For optionset value it is displaying value, How do we display name of the optionset value instead of values. SQL query onpremise organization.

All responses (3)

Answers (3)

Verified answer

Bipin D365 28,964 Super User 2024 Season 1 on at

Like (0)

Report

RE: SSRS reports

HI,

You should check StringMap table which contains all label values for Option set field.

You should join your table with StringMap to get optionset label.

Please mark my answer verified if i were helpful
Verified answer

Pawar Pravin 5,227 on at

Like (0)

Report

RE: SSRS reports

Hi ,

Please refer below url for reference (c point)

pravinpawarweb.wordpress.com/.../
Verified answer

rajeshbn 55 on at

Like (0)

Report

RE: SSRS reports

You can get the values by display name by linking with the tables OptionSetMetadata or GlobalOptionSetMetadata.