locked
Convert SQLReport code to FetchXML code RRS feed

  • Question

  • Hi,

    Please help me with Convert SQLReport code  to FetchXML code

    (CASE

    WHEN (CRMAF_Fileteredava_masterpolicy.ava_renewal = 1)

    THEN

    ACB.ava_renewalservicingcost

    ELSE

    ACB.ava_newbusinessservicingcost

    END

    ) as ServiceCost

    From

    Filteredava_masterpolicy as CRMAF_Fileteredava_masterpolicy

    Regards

    RajasekharReddy


    Thursday, January 7, 2016 7:34 AM

All replies

  • Hello,

    It is not possible to convert this query exactly to FetchXml. You will have to do following:

    1. Include all required fields to FetchXml query.

    2. Use IIF clause inside report to show value from ava_renewalservicingcost or ava_newbusinessservicingcost depending on value in ava_renewal field


    Dynamics CRM MVP
    My blog

    Thursday, January 7, 2016 8:04 AM
    Moderator