SSRS reports

(0) Share

Report

Posted on by Community Member

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.

I have the same question (0)

All responses (3)

Answers (3)

Sort by

Verified answer

rajeshbn 55 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Pawar Pravin 5,237 on at

Like (0)

Report
Copy link

Link copied!

Hi ,

Please refer below url for reference (c point)

pravinpawarweb.wordpress.com/.../

Was this reply helpful? Yes No
Verified answer

Bipin D365 28,985 Moderator on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No