web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / CRM multiselect field ...
Microsoft Dynamics CRM (Archived)

CRM multiselect field need to be added to SSRS

(0) ShareShare
ReportReport
Posted on by Indhu 55

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

  • Suggested answer
    Adrian Begovich Profile Picture
    Adrian Begovich 1,032 Moderator on at

    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.

  • Verified answer
    Alex Fun Wei Jie Profile Picture
    Alex Fun Wei Jie 33,628 on at

    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

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
ScottDurow Profile Picture

ScottDurow 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans