Joined: 08 Feb 2007
Location: Australia
Online Status: Offline
Posts: 1
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???????
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
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>
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