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