Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / SSRS report error
Microsoft Dynamics CRM (Archived)

SSRS report error

(0) ShareShare
ReportReport
Posted on by Community Member Microsoft Employee

I have created report using Report Authoring Extension.When I add fetchXML to the Querry designer I get error:
"Could not update a list of fields for the query. Verify that you can connect to the data source and that your query syntax is correct.
The attribute "new_ponumber" cannot be found for entity "opportunity". Specify a valid query, and try again."
It seems like when ever I add any custom field in fetchXML I am receiving the same error.
Any help will be appretiated.

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SSRS report error

    thank you all for give your usefull suggesions. Actully the problem was that I was adding wrong organization name in connection string . Once I add the correct organization name the issue is solved and now I am able to use custom fields in SSRS reporting tool.

  • Suggested answer
    Hasibur Rahman Profile Picture
    Hasibur Rahman on at
    RE: SSRS report error

    If its not fixed yet - you could try looking into this

    www.sqlchick.com/.../workaround-for-could-not-update-a-list-of-fields-for-the-que.html

  • Suggested answer
    Nithya Gopinath Profile Picture
    Nithya Gopinath 17,074 on at
    RE: SSRS report error

    Hi Dinal,

    See the links below. They give the solution for the issue you are facing.

    www.sqlchick.com/.../workaround-for-could-not-update-a-list-of-fields-for-the-que.html

    arcanecode.com/.../ssrs-quick-tip-an-item-with-the-same-key-has-already-been-added

    Hope this helps.

  • Verified answer
    SCV Profile Picture
    SCV 1,004 on at
    RE: SSRS report error

    Have you appended the organisation unique name to the end of the connection string. This can be found under the developer resources under Customizations.

  • Verified answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SSRS report error

    Refer this:

    www.jasonbenedetti.com/.../crm-2013-the-attribute-cannot-be-found-for-entity-specify-a-valid-query-and-try-again

    community.dynamics.com/.../210286

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: SSRS report error

    I am having the correct organization name and the user is system administrator so there is no issue of permissions.

  • David Jennaway Profile Picture
    David Jennaway 14,063 on at
    RE: SSRS report error

    Can you clarify the issue. Is it that you can a fetchXML query will work if it has no custom fields, but it fails if you include a custom field ?

    If so, two things to check are:

    • Are you connecting to the correct CRM organisation ?
    • Has your account permissions to access this organisation ?

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans