Announcements
 Crystal Reports Forum : General Information : Announcements
Message Icon Topic: New to Crystal Reports Post Reply Post New Topic
Author Message
Spike
Newbie
Newbie
Avatar

Joined: 08 Feb 2007
Location: Australia
Online Status: Offline
Posts: 1
Quote Spike Replybullet Topic: New to Crystal Reports
    Posted: 08 Feb 2007 at 7:19pm
Hi,  I need to achieve an exercise and am new to Crystal Reports.  We have a large database where client numbers have been allocated according to an alpha range.  Thereby there are unallocated numbers throughout the database.  I wish to access the unallocated numbers and don't know how to go about this.  I can easily get a report on the allocated, but the reverse???????
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 08 Feb 2007 at 8:40pm
Do a full outer join on the two tables. This gets you the all the records (even the unallocated ones). Then you have get just the unallocated records by selecting the ones where the records are null.
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
bobwith5
Newbie
Newbie
Avatar

Joined: 02 May 2007
Online Status: Offline
Posts: 1
Quote bobwith5 Replybullet Posted: 20 Jun 2007 at 3:17am
Smile
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.