locked
How to create a calculated column in Fetch XML RRS feed

  • Question

  • I am developing report with SSRS, connect to Dynamic CRM.

    under is the query to get information from CRM:

    <fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
      <entity name="leads">
        <attribute name="createdon" />
        <attribute name="statuscode" />
        <attribute name="fullname" />
      </entity>
    </fetch>

    now I need a computed column to calculate how many days after "createdon", how can I do it?

    I need this column to do a group, so I can not generated it in SSRS expression.

    Thank you in advance

     


    stong
    Monday, October 17, 2011 3:52 AM

Answers

  • Hi Guostong,

    You cannot include an expression within FetchXML, it has to be attribute names. So a calculated column cannot be included in fetchxml.

    HTH

    Sam


    Web: http://www.inogic.com
    Blog: http://inogic.blogspot.com
    Email: news@inogic.com
    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".
    Monday, October 17, 2011 5:34 AM

All replies

  • Hi Guostong,

    You cannot include an expression within FetchXML, it has to be attribute names. So a calculated column cannot be included in fetchxml.

    HTH

    Sam


    Web: http://www.inogic.com
    Blog: http://inogic.blogspot.com
    Email: news@inogic.com
    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".
    Monday, October 17, 2011 5:34 AM
  • Hi,

    You cannot included the calculated column in FetchXml as it will allow only available attribute. But You can perfrom that directly in SSRS itself.You can try expression to group directly .

    Thanks

     

    Monday, October 17, 2011 5:54 AM
  • In SSRS you can add calculated columns to your fetch xml by rightclick to your dataset, Fields, Add, Calculated Field. Specifiy Function and Field Name. You can basically use any field of your dataset in your equation.

    Another way would be to add the field to your Tablix of course.

    Friday, October 12, 2012 10:21 AM