Joined: 12 Jun 2009
Location: South Africa
Online Status: Offline
Posts: 4
Topic: DataSets Posted: 09 Oct 2009 at 1:11am
Hello
I have two Tables linked together using the link table in crystal reports. The first table has columns: Code,Name,Total and the other has Code,description,Total they are linked together via the code column. Now when there are no records in the second table the report doesnt display. I need it to display even when the second table is empty. Is there a property to do this. Thanks in advance
Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Posted: 09 Oct 2009 at 10:54am
You can click on the link between the two tables (that little line connecting them on the Links tab) and select the option Left Outer Join. This tells it to use all the tables from the table on the left even if there are no matching records from the table on the right (if your good table is on the right side, then choose Right Outer Join).
HTH,
Brian
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
