SSRS report - FetchXML - Dynamics 365 - attribute value

(0) Share

Report

Posted on by Community Member

In my fetchxml, I am joining a custom entity with accounts to pull some additional information. The values for standard attributes display fine, while values for custom attributes display "Microsoft.Xrm.Sdk.EntityReference". I checked with XRM toolbox fetchXML tester and it displays the value correctly. I am using VS 2015 with target server version as "SQL Server 2016 or later" and using report preview feature.

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

Charles Abi Khirs 3,569 on at

Like (0)

Report

Hello,

You can build your query using Advanced Find and then get the fetchxml from it and apply it to your report.

Was this reply helpful? Yes No
Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

Hello,

Can you please post a screenshot that demonstrates issue you mentioned?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thank you

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I just noticed that it is happening for some standard attributes as well (as shown in the image)

Was this reply helpful? Yes No
a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

That's awesome! What version of FetchXml authoring extension do you use?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

9.0

Was this reply helpful? Yes No
Verified answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report

That's what I thought. This 9.0 extension is buggy but I never had time to complain. Here is what I do that can work for you as well:

1. Uninstall 9.0 extension.

2. Install 8.2 - www.microsoft.com/.../details.aspx

3. To resolve issue with TLS 1.2 enabled you can use approach I described in my post - butenko.pro/.../microsoft-dynamics-365-v9-0-how-to-fix-connectivity-issues-between-ssdt-report-authoring-extension-and-dynamics-365

Good luck.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report

Spot on. authoring extension version is the issue.

Thanks a lot.

Was this reply helpful? Yes No