I have inserted this statement in my Group Formula Editor, but it doesn't have the desired results:
Maximum ({SIBINST.SIBINST_TERM_CODE_EFF}, {@NameLastFirstID}) = {SIBINST.SIBINST_TERM_CODE_EFF} AND
{SIBINST.SIBINST_FCST_CODE} = "AC"
I am trying to identify the row in SIBINST which contains the most recent term (...TERM_CODE_EFF) of all rows for that employee and then list values only if the value for ...FCST_CODE is "AC" . I've sorted and grouped by {@NameLastFirstID}. This is listed:
200201 AC BlowJoe5555
I expected that row not to appear because of Joe Blow's other row, which is not listed:
200308 IN BlowJoe5555
How do eliminate Joe Blow from my Crystal Report?
Maximum ({SIBINST.SIBINST_TERM_CODE_EFF}, {@NameLastFirstID}) = {SIBINST.SIBINST_TERM_CODE_EFF} AND
{SIBINST.SIBINST_FCST_CODE} = "AC"
I am trying to identify the row in SIBINST which contains the most recent term (...TERM_CODE_EFF) of all rows for that employee and then list values only if the value for ...FCST_CODE is "AC" . I've sorted and grouped by {@NameLastFirstID}. This is listed:
200201 AC BlowJoe5555
I expected that row not to appear because of Joe Blow's other row, which is not listed:
200308 IN BlowJoe5555
How do eliminate Joe Blow from my Crystal Report?