locked
convert ssrs reports code to fetchxml code RRS feed

  • Question

  • hi,

    I am migrating CRM 2011(On-premise) to CRM 2015(On-line), so how to achieve if-else condition in fetchxml code

    IF

    EXISTS(SELECT ava_masterpolicyid FROM FilteredAva_masterpolicylimit WHERE statecode = 0 AND ava_masterpolicyid = @MasterPolicy_ID)


    BEGIN

    {

    }

    else

    {

    }

    Thanks in Advance

    Regards

    RajasekharReddy K

    Monday, January 11, 2016 7:15 AM

All replies

  • Hello,

    It is impossible to convert mentioned script to fetchxml directly. Provide full script for inspection.


    Dynamics CRM MVP
    My blog

    Monday, January 11, 2016 8:35 AM
    Moderator
  • I'm afraid that your code is not complete. Please recheck it one more time and post complete version. Also FYI I can help and point but I would not do your work.

    Dynamics CRM MVP
    My blog

    Monday, January 11, 2016 9:03 AM
    Moderator
  • thanks got it

    Regards

    Raja

    Monday, January 11, 2016 9:12 AM
  • thanks got it

    So where is full code? Unfortunately I can't help without it.

    Dynamics CRM MVP
    My blog

    Monday, January 11, 2016 9:18 AM
    Moderator