Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Display Latest Transaction Post Reply Post New Topic
Author Message
johnformby
Newbie
Newbie


Joined: 16 Jul 2014
Online Status: Offline
Posts: 4
Quote johnformby Replybullet Topic: Display Latest Transaction
    Posted: 23 Jul 2014 at 10:09pm
Hello,

I have a report where I want to only select the latest weighing transaction for each container. For example, my data could be:

Date              ID    Weight
------------------------------
01/01/14 15:00    1     100
02/01/14 15:20    2     200
01/01/14 17:00    1     99

From the above, I would only need to display:

Date              ID    Weight
------------------------------
02/01/14 15:20    2     200
01/01/14 17:00    1     99

Any assistance would be greatly appreciated.

Kind Regards,

John
IP IP Logged
FrnhtGLI
Senior Member
Senior Member
Avatar

Joined: 22 May 2009
Online Status: Offline
Posts: 347
Quote FrnhtGLI Replybullet Posted: 24 Jul 2014 at 2:23am
I would probably group by container ID then by date/time (for each second) in ascending order. Then suppress the detail if {table.IDfield}=next({table.IDfield})

Edited by FrnhtGLI - 24 Jul 2014 at 2:25am
|< /\ '][' ( )
IP IP Logged
johnformby
Newbie
Newbie


Joined: 16 Jul 2014
Online Status: Offline
Posts: 4
Quote johnformby Replybullet Posted: 24 Jul 2014 at 2:37am
Hello,

Thank you for your reply. Unfortunately I have to group by Date and the transactions can happen over more than one day. Is there any way to handle this?

Kind Regards,

John
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.032 seconds.