Skip to main content

Notifications

Customer Service forum

Option Set Labels in SSRS reporting- Dynamics 365-on premise deployment

Posted on by

Hello

I am trying to use an optionset fields in my reports, how Can I get the label of the options instead of their values ?

I am using visual studio 2017 for reporting.

any help would be appreciated :)

Categories:
  • Suggested answer
    a33ik Profile Picture
    a33ik 84,321 Most Valuable Professional on at
    RE: Option Set Labels in SSRS reporting- Dynamics 365-on premise deployment

    I believe it should be custom entity so there should be some prefix (use schema name) like Filterednew_visitors or so.

  • aliAlmomani Profile Picture
    aliAlmomani on at
    RE: Option Set Labels in SSRS reporting- Dynamics 365-on premise deployment

    My entity name is Visitors

    should I write Filteredvisitors ???? that is all ?? if no, then what should I do to my entity to be filtered ??

    Help me please because I am beginner

    Thanks all in advance

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,321 Most Valuable Professional on at
    RE: Option Set Labels in SSRS reporting- Dynamics 365-on premise deployment

    There is a possibility to use StringMap table but to be honest there is no need in it. The trick is to use "Filtered" views instead of usual views or tables. So if your custom entity is new_entity and your optionset name is new_optionset following query should return you both optionset value and label:

    Select

    new_optionset

    ,new_optionsetname

    From Filterednew_entity

  • Suggested answer
    Alex Fun Wei Jie Profile Picture
    Alex Fun Wei Jie 33,626 on at
    RE: Option Set Labels in SSRS reporting- Dynamics 365-on premise deployment

    Hi,

    if you are using SSRS and refereing to the optionset value name

    example : new_optionset is your schema name for optionset, you can retrieve it using new_optionsetname

    SSRS

    social.microsoft.com/.../how-to-get-label-of-option-set-and-lookup-displayed-in-ssrs-report

  • aliAlmomani Profile Picture
    aliAlmomani on at
    RE: Option Set Labels in SSRS reporting

    Hello Andrew,

    it is an on-premise Organization and I am trying to create reports for customized entity

    I am trying to use String Map Base Table, but I have no Idea how to write the query

  • Suggested answer
    a33ik Profile Picture
    a33ik 84,321 Most Valuable Professional on at
    RE: Option Set Labels in SSRS reporting

    Hello,

    What kind of deployment do you have  - is it online or onpremice?

    If this is online - it seems that somehow you managed to install FetchXml Authoring extension for VS.

    Can you please clarify those points?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,818 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,147 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans