SSRS Dataset for CRM Appointments >"Required Attendees" - attribute "Party List" not supported?? RRS feed

  • Question

  • Hi all,

    I am trying to create a Summary Report per ACCOUNT, and one table will hold my appointments details. I have a table with Dataset for Appointment info.. I noticed that it does not allow me to report on required attendees??? Is this true? If so is there a workaround around this? I basically want my report to show appointments details and of course who participated.

    Any advice is much appreciated! I used below fetchXML to get Appointment details

    <fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
    <entity name="appointment">
    <attribute name="subject"/>
    <attribute name="statecode"/>
    <attribute name="scheduledstart"/>
    <attribute name="activityid"/>
    <attribute name="instancetypecode"/>
    <attribute name="requiredattendees"/>
    <order attribute="subject" descending="false"/>
    <link-entity name="account" from="accountid" to="regardingobjectid" alias="ae">
    <filter type="and">
    <condition attribute="accountid" operator="eq" value="@name"/>

    • Edited by Donyc Monday, April 7, 2014 12:51 AM
    Sunday, April 6, 2014 9:22 PM

All replies

  • here is the screenshot of the error
    Monday, April 7, 2014 2:57 PM
  • It's a limitation of FetchXML, a solution is to copy the string values of the standard attribute to a custom field (by plugin or with a workflow using a custom activity) and use the custom field inside the report.

    My blog: www.crmanswers.net - Rockstar 365 Profile

    Monday, April 7, 2014 3:23 PM