Dave Stone
asked on
Crystal Reports Show Only Current Record
Hello,
I have a report that the experts here helped me with. I needed to only see the most recent records for a vendor report. I thought I got what I needed by grouping the report by Vendor and sorting the records by rating date (ascending). I then suppressed the Detail section and GH1. Moved the information I wanted to see to GF1 (Group Footer 1).
The Group Footer shows information for the last record in the group.
The problem now is if I use select expert to only see specific ratings the report will go back to when that that specific rating may have been.
Perhaps this is not clear. The table I am looking at has the vendor id and a vendor rating, ( C,X,E,G,etc..), and the date when one of these specific ratings was assigned to it. The rating can change for any given vendor at any given time when they are evaluated. I am trying to get a report that will only show me vendors with a current “C” or “X” rating. Any help with this would be appreciated.
Thank you
I have a report that the experts here helped me with. I needed to only see the most recent records for a vendor report. I thought I got what I needed by grouping the report by Vendor and sorting the records by rating date (ascending). I then suppressed the Detail section and GH1. Moved the information I wanted to see to GF1 (Group Footer 1).
The Group Footer shows information for the last record in the group.
The problem now is if I use select expert to only see specific ratings the report will go back to when that that specific rating may have been.
Perhaps this is not clear. The table I am looking at has the vendor id and a vendor rating, ( C,X,E,G,etc..), and the date when one of these specific ratings was assigned to it. The rating can change for any given vendor at any given time when they are evaluated. I am trying to get a report that will only show me vendors with a current “C” or “X” rating. Any help with this would be appreciated.
Thank you
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Perfect. Thank you.
Add to the Report Group Selection Formula a condition of:
MAX({Rating_Date}, {Vendor_ID}) = MAX({@That_Formula}, {Vendor_ID})