Example: display the most recent action for a proposal
  1. Insert a group on the proposal
  2. Insert  a maximum summary on the action date field
  3. Insert the action information fields into the Details section
  4. Conditionally suppress the Details section based on the following formula:{Action_Date} <> Maximum({Action_Date}, {PROPOSAL.EN_US})

If you do not want groups in your report, use a subreport to determine the latest action.
  1. Create a subreport and insert it into the report
  2. Link the CnBio_IDKEY field to the subreport
  3. In the subreport, group on the action date field
  4. Create a maximum summary field on the Action Date field
  5. Create a shared variable formula to send the most recent action date back to the main report
    WhilePrintingRecords;
    Shared DateTimeVar LatestActionDate;
    LatestActionDate := Maximum({Action_Date})
  6. Conditionally suppress the Details section in the main report based on the following formula:
    WhilePrintingRecords;
    Shared DateTimeVar LatestActionDate;
    {Action_Date} <> LatestActionDate