Topic: Report on missing data Posted: 06 Apr 2009 at 1:37pm
Hi,I’m new to Crystal Reports. I’m trying to create a report that will return all customers from Table1 that do not have sales listed in Table2.It’s not that there is field with a null value in Table2. It’s that Table 2 lacks any row for that customer. Any help with this would be greatly appreciated. Thanks.
Thanks DBlank! Thanks for the quick responce and for the answer to my problem. I've got a ways to go with this report but I tried the left join and was able to get the initial data I needed!
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