David Smith

David Smith

  • NA
  • 2k
  • 0

Rdlc Field expression

Nov 23 2010 7:34 AM
below im using the expression  below to displaying the max value of the status field by time.
For some reason is the testname is the it will say that the max value is PASS for the raw table which incorrect
I want the max value by time instead whether the test name is the same or not, what would be the expression

= Max(Field!Code.
Status)

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 fvia rdlc file:  Status By Time



 Time               TestName        Status

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


Error THis is the output im getting at the moment when i say 

= Max(Field!Code.
Status)  which is incorrect when the testname is the same

 Time               TestName        Status

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