Dynamics Community Forum Thread Details

Pivot FetchXML SSRS Report

hello , could you please help me i need to do Pivot in a fetchXML Query for a SSRS Report (A chart) in CRM 365 online

here is my fetch query :

<fetch distinct="false" mapping="logical" output-format="xml-platform" version="1.0">
<entity name="contact">
<attribute name="fullname"/>
<attribute name="contactid"/>
<attribute name="NbrWeekEmail"/>
<attribute name="NBRDayEmail"/>
<attribute name="NBRMonthEmail"/>
<order descending="false" attribute="fullname"/>
<filter type="and">
<condition attribute="contactid" value="{DE376A94-26E6-E711-A82D-000D3AB4DB84}" uitype="contact" uiname="Lamyae j" operator="eq"/>
</filter>
</entity>
</fetch>