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

I have the same question (0)

All responses (7)

Answers (1)

Saroj Das 3,355 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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>

Was this reply helpful? Yes No
Suresh Sorde 1,077 on at

Like (2)

Report

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

Was this reply helpful? Yes No
Verified answer

Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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

Was this reply helpful? Yes No
Rakhi Sharma on at

Like (0)

Report

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.

Was this reply helpful? Yes No
alx.kpk 35 on at

Like (0)

Report

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

nishantrana.me/.../

Was this reply helpful? Yes No