Post reply

Max from parameter value.

  • March 29, 2015 at 11:17 am

    #296512

    Hi, i have a question, how to return the max value from values which where passed from parameter?

    I have query:

    =Switch(Fields!Wartosc.Value = Max(Wartosc.Value, "DataSet1"), "Red",

    Fields!Wartosc.Value = Min(Fields!Wartosc.Value, "DataSet1"), "Yellow")

    But it returns the max & min value from whole database. Not from few values which parameter passed.

  • March 30, 2015 at 12:25 am

    #1787218

    any ideas?

  • April 7, 2015 at 9:26 am

    #1789228

    pilikowaty (3/29/2015)

    Hi, i have a question, how to return the max value from values which where passed from parameter?

    I have query:

    =Switch(Fields!Wartosc.Value = Max(Wartosc.Value, "DataSet1"), "Red",

    Fields!Wartosc.Value = Min(Fields!Wartosc.Value, "DataSet1"), "Yellow")

    But it returns the max & min value from whole database. Not from few values which parameter passed.

    It is returning the values from the database because you are using fields in the expression.

    Here is an example of using a parameter in an expression:

    =Parameters!Wartosc.Value

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply