Trying to show Multi Select Option Set Values in Fetch XML Report, but get an error the field doesn't exist when it does.
HAs anyone been able to show these in a field in a report?
*This post is locked for comments
Hi Drew,
Do not try in XrmToolBox
Have you tried in SSRS report in Visual Studio 2015?
It still shows error, the attribute does not exist in that entity.
Could you please have a try?
Let me know your result
Regards,
Zhenyu
Hi Graeme,
So I just ran a test in a new instance I created. I did the following:
1. Added new field (new_multioptionset) to Account and published "all customizations"
2. Set values on a few accounts
3. Ran the following fetchXML from the XrmToolBox:
<fetch mapping='logical'>
<entity name='account'>
<attribute name='accountid'/>
<attribute name='name'/>
<attribute name='new_multioptionset'/>
<link-entity name='systemuser' to='owninguser'>
<filter type='and'>
<condition attribute='lastname' operator='ne' value='Cannon' />
</filter>
</link-entity>
</entity>
</fetch>
4. It returned a number of results, example below:
A. Datum - Selected A (100,000,000) and B (100,000,001)
Adventure Works - Selected B (100,000,001) and C (100,000,002)
Alpine Ski House - Selected A (100,000,000)
In my current instance it appears to be delivering the results I would expect for this. Version 9.0.2.449 (DB 9.0.2.449) online
Hope this helps!
Thanks Graeme, I will review more and hope to get back to you tomorrow.
Hi Drew, I get the error 'Object reference not set to an instance of an object.' when i put the code into the xml checker.
Hi,
As mentioned above, I would also suggest to check your fetchxml outside of your report. If it is a problem with fetchxml, you will be able to track it. Otherwise it would be a rendering issue at the SSRS level.
Hope this helps.
Hi Graeme,
A couple of things here.
First of all, you should be able to test your fetchxml online here if you like: http://msxrmtools.com/fetchxml
Secondly, please verify you have published all customizations, not just the entity to make sure the metadata is published.
let me know if this does not help.
Thanks drew.
Share
Report
All responses (
Answers (
<?xml version="1.0"?>
<fetch distinct="true" mapping="logical" output-format="xml-platform" version="1.0">
<entity name="msdyn_project">
<attribute name="msdyn_projectid"/>
<link-entity name="msdyn_projectteam" alias="ProjectTeam" link-type="outer" to="msdyn_projectid" from="msdyn_project">
<link-entity name="bookableresource" alias="BookableResource" link-type="outer" to="msdyn_bookableresourceid" from="bookableresourceid">
<attribute name="new_salarytype"/>
</link-entity>
</link-entity>
</entity>
</fetch>
Hi Graeme, can you paste the full code to review?
Hi Drew, I had but keep getting the error its not in the system when it is.
Obtainign it suing '<attribute name="new_salarytype"/>' via a lin entity refernce form a related record.
It works for all the other fields i'm getting just not this multi-select option set.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156