Search code examples
reporting-servicesdynamics-crm-2011fetchxml

Define an expression according to the last record

I've created a custom report in Fetch XML with an expression calculating the time spent on each incident according to a date range parameter. No problem here to create the expression but this one should only concern the last contract record (I still need the previous ones to appear on the report though). Is there any way to do that?

Thanks in advance !

Solution

  • How about the function for Last value within a certain scope? E.g.

    =Last(Fields!ProductNumber.Value, "Category")