I have a database with a subform and I want to design a report which includes various records of the main form and for each one I want to include only the latest record of the subform.
Up to now I have been making reports which give me all the records of the subform related to each of the records of the main form that I select.
Now I want just the last one of the subform records for each of the main form records.
Is that possible?

Don't have access to correct syntax right now, but try these two variations.  Both are based on getting FormResultSetTotal() of records

1.  Use RecordSetTotalCount in @ FormFieldValue using FormResultSetTotal for the "instance" value

2.  Use FormResultSetTotal to go to Record Position using FormResultSetTotal for the position value

var vRecord as Int
var vLastRecord as String

vRecord = @FormResultSetTotal(FormName!SubForm)

//Example 1 --- gets a field value from a specific record number
vLastRecord = @FormFieldValue(frmName!subForm,Field, vRecord)

//Example 2 --- Moves you to specific record to get access to all fields for that record.
RecordSetCurrentPosition(vRecord) 

==================
As cautioned above, syntax may be incorrect.  But depending on what you want to do with the last record, one or both of these may help you.