Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Questions about DB Joins and missing data Post Reply Post New Topic
Author Message
flanman
Senior Member
Senior Member
Avatar

Joined: 04 Nov 2009
Online Status: Offline
Posts: 123
Quote flanman Replybullet Topic: Questions about DB Joins and missing data
    Posted: 24 Dec 2009 at 7:33am
Have a report that makes the following innerjoins
Drive >People>TeamMemberDetail>TeamMaster

This allows me make the following connection.

Drive.recuriterID > People.PersonID>TeamMemberDetail.PersonID>
TeamMemberDetail.TeamID>TeamMasterTeam.ID

This allows me to match a sales person  to thier sales  team name (for grouping).  This is all working fine.

However, I have a marketing department this is actually setup like a person with no teammember or teamdetail reference.

So when I run the report the marketing department is left out. How can I also grab the marketing dept without any references in the last two tables?

Thanks again in advance.

Flanman
IP IP Logged
flanman
Senior Member
Senior Member
Avatar

Joined: 04 Nov 2009
Online Status: Offline
Posts: 123
Quote flanman Replybullet Posted: 24 Dec 2009 at 7:44am
Never mind on this one. I had our DB manager add my marketing folks to the other two tables and all is fine.
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.016 seconds.