We have an SSRS report that connects to Dynamics CRM V9 and I tried to test if it's possible report on the new multi-select option-set field. In the SSRS query designer, when I try to use a multi-select field I receive an error saying, "The attribute [field] cannot be found on the contact entity." I've checked the spelling and syntax and it works on other fields. Are multi-selects not currently supported with SSRS? Thanks so much.
*This post is locked for comments
Hi Indhu,
This is a limitation of the MultiSelect Option Set field type. As a workaround, you could copy the MultiSelect Option Set values to a text field and then use the text field in your SSRS report.
We had to create a plugin that runs on update/create that retrieves the option-set values from the multi-select field and then copies them to a text field field. The SSRS report uses the text field. It's our current workaround until multi-selects are better supported. Here's an overview of what the plugin does:
Retrieve the multi-select value:
QueryByAttribute querybyattribute = new QueryByAttribute("contact");
querybyattribute.ColumnSet = new ColumnSet();
querybyattribute.ColumnSet.AddColumn("your_multi_select e.g. 'languages_spoken' ");
EntityCollection retrieved = _service.RetrieveMultiple(querybyattribute);
//Above code will return the option-set value; if all you want is the value for SSRS that's enough.
If you want the option display name you can create a dictionary object:
new SharedFieldCollection()
{
MultiSelectField = "languages_spoken",
//Once you match the value to the display name in the OptionsList below you can copy it over
//to the ConcatField below.
ConcatField = "languages_spoken_collection",
OptionsList = new Dictionary<int, string>()
{
{224310002, "French"},
{224310000, "English"},
{224310001, "Spanish"}
}
}
If this answer helps please mark it as a verifiable answer :)
Not sure if this will help you, but there are some limitations on multiselects. In CRM Web report designer you cannot add multiselect, so might be the same for the SSRS report:
nishantrana.me/.../limitations-of-multi-select-option-sets-in-dynamics-365-ce
Hope this helps.
Same issue, is there any solution?
Thanks!!
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,280
Super User 2024 Season 2
#2
Martin Dráb
230,235
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (