Display latest record in a Report

[KAPITYAN]

I have a one to many relationship but I only want to see the most recent event in my report. I am using a calculated field SELECT TOP 1 ContactID FROM Contacts WHERE ContactID = target.[@field:ContactID] ORDER BY CallDate but I get all the results not the most recent.

For example, I have a table Contacts with one person and table calls with. But I only want to see the when the last call was made. I want to display only the recent record/s.

[NailDyanC]

You can limit the number of returning results in your tabular report. You just need to sort it by CallDate in descending order and in the Advanced tab, you can limit the Total records returned. You may check the screen shot below for reference.

[astroboy]

Aside from limiting the total records returned in your DataPage, I also suggest changing the sort order of your records on the Results Page Options wizard. This will help you control the order of your records being displayed on the Results page. Here's a HowTo article that you may check for more information:

https://howto.caspio.com/datapages/reports/interactive-reporting-options/

[BrillMindzz]

changing the sorting in data sheet will help

[RuisiHansamu]

I believe this forum post is quite similar to this one. Feel free to check it our here as it provides me the SELECT statement I needed.