Accountability Posted October 10, 2017 Report Share Posted October 10, 2017 Is there a way to run a report showing only the most recent iterations? Please see attachment. Thanks for your help ! Sample_Desired_Output - New.pdf Quote Link to comment Share on other sites More sharing options...
0 Ba2sai Posted October 11, 2017 Report Share Posted October 11, 2017 Try adding a Timestamp field based on record update in your DataSource table and in your Report DataPage, sort the report (descending) based on this field. https://howto.caspio.com/datapages/reports/interactive-reporting-options/ Quote Link to comment Share on other sites More sharing options...
0 Accountability Posted October 11, 2017 Author Report Share Posted October 11, 2017 Hello Ba2sai, Thank you for responding. I understand how that works unfortunately that will not yield what I am seeking. I need to have a report with the most recent document date. If documents are entered out of order the datetime stamp won't show the most recent document date. The documents have different document dates and may be entered out of order. The datetime stamp only reflects the date and time the document was physically entered but not the date on the document itself. Also I know I can have a column sorted by document date but as you can see in my attached example, I need only the most recent documents with the most recent dates (not all documents). Thanks again for responding. Quote Link to comment Share on other sites More sharing options...
Question
Accountability
Is there a way to run a report showing only the most recent iterations? Please see attachment. Thanks for your help !
Sample_Desired_Output - New.pdf
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.