locked
How to get the last revision quote to SSRS report RRS feed

  • Question

  • HI,

    My report current result like this

    Qoute ID Revision
    Q1 1
    Q1 2
    Q1 3
    Q2 1
    Q3 1

    I would like to filter if the quote ID is same , only get the last revision quote into report

    Qoute ID Revision
    Q1 3
    Q2 1
    Q3 1

    How can i compare the Quote ID and Revision in fetchxml or dataset filter ?

    Thank You

    • Edited by Arvin Wong Wednesday, March 11, 2015 11:36 AM
    Wednesday, March 11, 2015 11:36 AM

Answers

  • <fetch distinct='false' mapping='logical' aggregate='true'> 
        <entity name='Quote'> 
           <attribute name='revisionnumber' alias='estimatedvalue_max' aggregate='max' /> 
           <attribute name='quotenumber' alias='quoteid' groupby='true' /> 
        </entity> 
    </fetch>"

    Regards, Saad

    • Marked as answer by Arvin Wong Wednesday, March 11, 2015 5:43 PM
    Wednesday, March 11, 2015 1:09 PM