Joined: 06 Aug 2007
Online Status: Offline
Posts: 1
Topic: Displaying records even if one field has no data Posted: 06 Aug 2007 at 3:57am
Please help!
I am trying to pull records into a report and everything looks good. But when I add the database field for "drug test" only the individuals who have been tested appear. I want to show all records so that I can see who has been tested and who has not.
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 06 Aug 2007 at 10:29am
This is tough to figure out in a forum. It could be how the tables are linked (is the Drug Test field being linked to? If so, you need to make it a left outer join in the Database Expert so that it can still use empty fields. What about the record selection formula? Anything going on there that uses Drug Test field? You need to look at that as well.
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
IP Logged
