Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Matching Record number to corresponding record Post Reply Post New Topic
Author Message
Rodemusprime
Newbie
Newbie


Joined: 19 Aug 2010
Online Status: Offline
Posts: 10
Quote Rodemusprime Replybullet Topic: Matching Record number to corresponding record
    Posted: 11 Apr 2011 at 7:24am

I am trying to create a report where i list in the first column a number range for example 80000 to 89999, and then pull from a table any record matching the first column and and name associated with it. 

My purpose is to create a list of available numbers in that first range, and see who may be assigned to that number if that is the case.
 
Here is an example of what I'm looking for
 
80000
80001
80002         Jane Doe
80003
80004         John Doe
 
Is this possible?
 
 
 
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 11 Apr 2011 at 9:59am
You can only do this if the missing numbers are in a table somewhere.
 
-Dell
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.031 seconds.