How can i show Minimum, Maximum and Average value?

Discussion in 'Business-Intelligence' started by avreporter, Mar 2, 2014.

  1. avreporter

    avreporter Administrator Staff Member

    I want to show here the min,max and avg values of the parameters in the above time frame. But when i put the format min(Fields!...) into the table i receive errors
  2. avreporter

    avreporter Administrator Staff Member

    First step select the quantity and Minimum Summarization method.

    BI1.png
  3. avreporter

    avreporter Administrator Staff Member

    Next step create expression:

    BI2.png
  4. avreporter

    avreporter Administrator Staff Member

    Edit RDLC Report:

    BI3.png
  5. avreporter

    avreporter Administrator Staff Member

  6. avreporter

    avreporter Administrator Staff Member

    Start queary and you can see the result:

    BI5.png
  7. avreporter

    avreporter Administrator Staff Member

    Maximum and Average value shown is similar than Minimum value.

    BI6.png

Share This Page