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 :)
I believe it should be custom entity so there should be some prefix (use schema name) like Filterednew_visitors or so.
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
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
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
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
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?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 290,818 Super User 2024 Season 2
Martin Dráb 229,147 Most Valuable Professional
nmaenpaa 101,156