Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Items disappear when linking to another table Post Reply Post New Topic
Author Message
almj
Newbie
Newbie


Joined: 15 Nov 2010
Online Status: Offline
Posts: 3
Quote almj Replybullet Topic: Items disappear when linking to another table
    Posted: 15 Nov 2010 at 3:37am

I’m working in crystal reports XI. I experience the same type of problem with many of my reports, if I get help with this one it will help a lot!

I have a number of articles that I want to have as a list on my report.  I also want to show every invoice related to each article number. When I link the article-table to the invoice-table the articles that have no related invoice disappear. I want them to be included even though they have no posts in the linked invoice-table.

My guess is that the solution is to find somewhere in how I link the tables, but I have tried different options and can’t get it right. Any ideas anyone?
IP IP Logged
Duraplex
Newbie
Newbie


Joined: 15 Nov 2010
Online Status: Offline
Posts: 2
Quote Duraplex Replybullet Posted: 15 Nov 2010 at 4:40am

Sounds like you might want to use a left join.
IP IP Logged
almj
Newbie
Newbie


Joined: 15 Nov 2010
Online Status: Offline
Posts: 3
Quote almj Replybullet Posted: 16 Nov 2010 at 8:03pm
Thanks. That helps kind of half way =)
I get all the articles in the report, but as soon as I add information from the invoice-table the articles without any invoices dissapear. Any suggestions to what I can do about that? Something with one of the other link-options perhaps?
IP IP Logged
almj
Newbie
Newbie


Joined: 15 Nov 2010
Online Status: Offline
Posts: 3
Quote almj Replybullet Posted: 17 Nov 2010 at 1:50am
Now it worked! =)
I had one more table, companies, that was linked to the invoice-table. When I set that link as well to left outer it worked.

BUT.... Next problem. When I go to the select expert and select a certain period for the invoices, the articles that had no invoces in that period disappears. Any suggestions to how I can deal wit that?
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump 		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



This page was generated in 0.039 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.