CRM SSRS Report Error

(0) Share

Report

Posted on by Community Member

I am creating a report using Report Authoring Extension (with SQL Server Data Tools support). After adding the fetch XML to the Query designer I got error that says:

"An error occurred while executing the query. The attribute "new_educationallevel" cannot be found for entity "incident". Specify a valid query, and try again."

I don't receive such errors when I remove custom fields from the fetch XML and I need those customized fields in my report, the CRM version I am using is Online Dynamics CRM 2016 and the customization is on the Sandbox and all the customization is published.

*This post is locked for comments

All responses (7)

Answers (1)

alx.kpk 21 on at

Like (0)

Report

RE: CRM SSRS Report Error

If you trying to add a field of type "multiselect-optionset" it's not supported by reports:

nishantrana.me/.../
Rakhi Sharma on at

Like (0)

Report

RE: CRM SSRS Report Error

Hi Suyash,

When your organization has multiple instance then you have to specify the instance along with the organization url while creating the reports in Visual Studio.

For example : https://test.crm.dynamics.com;organizationuniquename

Note: Please mark my answer as verified if it is helpful for you.
Community Member on at

Like (0)

Report

RE: CRM SSRS Report Error

Hi Naareman, I am also facing same issue and by chance with same entity "Incident", did you get any permanent solution for this bug?
Verified answer

Community Member on at

Like (0)

Report

RE: CRM SSRS Report Error

I couldn't find a solution for the problem.

However I did some work around where I created a dummy report by wizard with the data I wanted and then imported that reported in VS and worked on it and it worked just fine.
Suresh Sorde 1,077 on at

Like (2)

Report

RE: CRM SSRS Report Error

Hi,

Remove the field that gives error from query and try with another custom field for testing.

If it work for this custom field then recreate educationallevel field.

Thanks
Community Member on at

Like (0)

Report

RE: CRM SSRS Report Error

I did so, and published the solution also I created multiple records and a simple report using the Wizard for those entity and all seem to work just fine.

That's part of the Fetch XML. Here attribute name "new_educationallevel" is the custom one the rest aren't when I remove the custom one it doesn't give me any error however I need that field in the report.

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">

<entity name="incident">

<attribute name="statecode" />

<attribute name="prioritycode" />

<attribute name="ownerid" />

<attribute name="new_educationallevel" />

<attribute name="ticketnumber" />

<attribute name="incidentid" />

<filter type="and">

<condition attribute="createdon" operator="this-year" />

</filter>

</entity>

</fetch>
Saroj Das 3,355 on at

Like (1)

Report

RE: CRM SSRS Report Error

Make sure your attribute is available in the entity and you have published your changes.

can you please paste your Fetch query here?

Thanks,

Saroj