New to Crystal Reports
Printed From: Crystal Reports Book
Category: General Information
Forum Name: Announcements
Forum Discription: Please check this section for the latest announcements from Crystal Reports Forum
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=203
Printed Date: 27 Apr 2024 at 10:09pm
Topic: New to Crystal Reports
Posted By: Spike
Subject: New to Crystal Reports
Date 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??????? |
Replies:
Posted By: BrianBischof
Date 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> |
Posted By: bobwith5
Date Posted: 20 Jun 2007 at 3:17am
|