Show Multi Select Option Set Values in Fetch XML Report.

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

Drew Poggemann 4 on at

Like (0)

Report

Hi Graeme,

Have you reviewed this article?

docs.microsoft.com/.../multi-select-picklist

Looks to fit well with what you are looking to do.

Hope this helps.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Drew Poggemann 4 on at

Like (0)

Report

Hi Graeme, can you paste the full code to review?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Thanks drew.

<?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>

Was this reply helpful? Yes No
Suggested answer

Drew Poggemann 4 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Suggested answer

RaviKashyap 55,410 Moderator on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Drew Poggemann 4 on at

Like (0)

Report

Thanks Graeme, I will review more and hope to get back to you tomorrow.

Was this reply helpful? Yes No
Suggested answer

sandeepstw 4,601 on at

Like (0)

Report

Hi,

Use of Alias in FetchXML

Follow this article - www.inogic.com/.../use-of-alias-in-fetchxml

Was this reply helpful? Yes No
Suggested answer

Drew Poggemann 4 on at

Like (0)

Report

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!

Was this reply helpful? Yes No