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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)
Answered

New to Dynamics 365 - Cannot add field to Dataset in SSRS report

(0) ShareShare
ReportReport
Posted on by 25

Hi - I am trying to add a field to a report that was created for me.  I am using the Dynamics 365 Report Authoring Extensions.  When I try to add the field to the dataset, I get an error that says 'The dataset 'ReportData' contains a definition for the Field 'fieldIamtryingtoadd'. The field is missing from the returned result set from the data source.  The dataset does have a parameter associated with it that appears to select only some of the fields from the view that contains this field but I cannot find where to edit this parameter.  I've been pretty successful with picking my way through the errors that have come up when editing this report but this one has me stumped.  Please let me know if I can provide more information.  Thank you in advance for your help.

*This post is locked for comments

I have the same question (0)
  • Verified answer
    AnneBerndt Profile Picture
    25 on at

    Figured it out...finally.  The name of the field in the view is 'FieldIamTryingtoAdd' so I tried to add the field by typing it exactly as it is named in the sql view.  Once I tried to add the field 'fieldiamtryingtoadd' in all lower case, I had no problems at all :)  Hope this might help some other newbie!!!

  • Suggested answer
    a33ik Profile Picture
    84,331 Most Valuable Professional on at

    Hello,

    If you want to make your life easier building FetсhXml you should use Advanced Find or FetchXml Builder plugin from XrmToolbox.

  • AnneBerndt Profile Picture
    25 on at

    Thank you.  I will try that.

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 Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans