<div>
Do the notes records have an indication of the last one?<br />
Date, sequence number?<br />
<br />
If so one way to do this is to group on the invoice number in the subreport<br />
Sort descending on the date field or sequence number<br />
Show the notes field in the group header<br />
Suppress the details<br />
<br />
mlmcc
</div>


Do the notes records have an indication of the last one?
Date, sequence number?

If so one way to do this is to group on the invoice number in the subreport
Sort descending on the date field or sequence number
Show the notes field in the group header
Suppress the details

mlmcc

<div>
Note Id and date for each note in the field distinguishes one note from the next. &nbsp;The last entry is at the top.
</div>


Note Id and date for each note in the field distinguishes one note from the next.  The last entry is at the top.

<div>
<div class="content wysiwyg-content">
I have a crystal report that groups records by invoice number, and a subreport to pull notes from the customer table. &nbsp;The problem is the note field has multiple entries. &nbsp;The subreports pulls all the customer notes. &nbsp;I need to only pull the last entry. I can't seem to get it to do so.<br />
is this possible?
</div>
</div>


I have a crystal report that groups records by invoice number, and a subreport to pull notes from the customer table.  The problem is the note field has multiple entries.  The subreports pulls all the customer notes.  I need to only pull the last entry. I can't seem to get it to do so.
is this possible?

Need to pull only last entry in a multi entry field

Crystal Reports is a business intelligence application from SAP SE. It is used to graphically design data connections and report layouts from a wide range of data sources including Excel spreadsheets, Oracle, SQL Server databases and Access databases, BusinessObjects Enterprise business views, and local file-system information. Report designers can place fields from these sources on the report design surface, and can also deploy them in custom formulas (using either BASIC or Crystal's own syntax), which are then placed on the design surface. Crystal Reports also supports subreports, graphing, and a limited amount of GIS functionality.