Thank you for all the great support that I get through this forum.
I am producing a report that displays a summary of a data import. I have a single table that lists all the exceptions from the import and why the item was rejected.
I also have a summary at the top of the page that displays two items:
Total items processed - easy - just get a row count
Total item rejected - my problem
I have added two extra fields to my datatable which are the counters for these two items. I need to get the last row of the datatable will will have the total items rejected.
At the moment the merge field it taking the top / first record. Is there any way to force it to use the last record?