Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Convert SQLReport code to FetchXML code RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    1
    Sign in to vote

    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