Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2016 : Technical Questions
Message Icon Topic: How to limit results to 5 most recent transactions Post Reply Post New Topic
Author Message
sandballer
Newbie
Newbie


Joined: 12 Apr 2018
Location: United States
Online Status: Offline
Posts: 1
Quote sandballer Replybullet Topic: How to limit results to 5 most recent transactions
    Posted: 16 May 2018 at 9:02am
I have a history table that includes item#, tag# (or license plate), transaction type, and date, among many other fields. How can I return only the 5 most recent transactions (or up to 5 if less than that) for each item#/tag#/transaction type combinations?
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1428
Quote kevlray Replybullet Posted: 24 May 2018 at 5:44am
If you are grouping you can filter by the top 5.  Not sure what you would determine as the top 5.  Also if the data source is a SQL and you are using a command.  You can also use the TOP in the Select statement.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.