David Smith

David Smith

  • NA
  • 2k
  • 0

rdlc field expression

Nov 19 2010 3:24 PM
Read the comments in red below.

= Max(Field!Code.Value)

Raw Table

 Time               TestName        Status

1/01/10           Beer                 FAIL
1/01/10           Beer                 ""
1/01/10           Beer                 ""
1/01/10           Beer                 ""

2/20/10           Beer                 PASS
2/20/10           Beer                 ""
2/20/10           Beer                 ""
2/20/10           Beer                 ""


Output Im trying to Produce for a pivot or crosstab via rdlc file:  Status By Time



 Time               TestName        Status

1/01/10           Beer                 FAIL
2/20/10           Beer                 PASS



With this expression  = Max(Field!Code.Status) :  Status By Time

this value is incorrect, it suppose to say FAIL if you look above in the raw table the value is FAIL
I thinking because the testname has the same value and PASS is the max it included PASS for that test (1/01/10)
So how do write the expression to give me the max value by time via Status

 Time               TestName        Status

1/01/10           Beer                 PASS   
2/20/10           Beer                 PASS