Hello everyone! :)

Pleeeaaase i need your help.

Crystal Reports 2008

Situation:
If {A.Status} = "Withdrawn"
show maximum date from {B.Date}
where {B.State} = "Withdrawn"

else if {A.Status} = "Declined"
show maximum date from {B.Date}
where {B.State} = "Declined"

how do i make this happen? to show only the maximum date from table B where the state is Withdrawn for a.status Withdrawn and maximum date also from table B where the state is Declined where the a.status is Declined.

Since there might be a lot of times where the application has been withdrawn, or declined, the report gives out rows for each one. it doesn't only pick up the maximum date. hence, duplicates. HUHUUU. i am at wits end :'( Please help meee