Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Data comparison Post Reply Post New Topic
Author Message
andybrst
Newbie
Newbie


Joined: 04 Sep 2009
Online Status: Offline
Posts: 5
Quote andybrst Replybullet Topic: Data comparison
     Posted: 29 Jan 2010 at 2:16am
Is it possible to compare two lines of data (from the same table) within Crystal, and report back the second line wherer the criteria is met.
 
i.e. I have a table listing all the service calls placed against a clients machine. I wish to be able to identify which call received was within 3 weeks of the previous calls' completion.
 
I hope this makes sense.
 
Regards
 
Andy
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet Posted: 01 Feb 2010 at 11:30am
If the records are right after each other, you can do a 'previous' or 'next' function in the section expert and suppress using a formula. 
IP IP Logged
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