CRM multiselect field need to be added to SSRS

(0) Share

Report

Posted on by Indhu

I am importing all the fields form CRM to SSRS, to create a dynamic SSRS report. I have a multiselect field in CRM, when I try to add this multiselect field in SSRS DataSet, it is throwing me an error saying ,"The attribute [field] cannot be found on the contact entity." can someone help me in fixing this. Field - SelectCourse-> which contains list of course. Depending on the selected course i should show the report. I don't think parameter is necessary in this.

*This post is locked for comments

All responses (2)

Answers (1)

Verified answer

Alex Fun Wei Jie 33,626 on at

Like (0)

Report

RE: CRM multiselect field need to be added to SSRS

Hi,

this is one of the limitation of using multi select option set. You can refer below link to know more limitations.

nishantrana.me/.../limitations-of-multi-select-option-sets-in-dynamics-365-ce
Suggested answer

Adrian Begovich 1,019 Super User 2025 Season 1 on at

Like (0)

Report

RE: CRM multiselect field need to be added to SSRS

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.