Crystal Reports Problem with join?

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design

Topic: Problem with join?
	<< Prev Page of 2

Author	Message
DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 06 Jul 2011 at 7:33am
	so you have no select statement at all (like invoice date > last week)?
	IP Logged

DBlank Moderator Joined: 19 Dec 2008 Online Status: Offline Posts: 9053	Posted: 06 Jul 2011 at 11:40am
	i ask because it sounds like you have it set up correctly but I have seen people make the their outer join into an inner join buy including a select statement that messes it up (excludes outer part rows). Also I assume you are displaying the names using data from the table of customers not invoices. Do you have any suppression criteria re: invoice results? Edited by DBlank - 06 Jul 2011 at 11:41am
	IP Logged

karenc Newbie Joined: 06 Jul 2011 Location: United States Online Status: Offline Posts: 5	Posted: 20 Jul 2011 at 8:00am
	Sorry, I was out for a while...but still could use your help!! I do have the following... {Organizations.cmoResellerOrganizationID} <> '""' and {@Commissionable} and {PartGroups.UIMUDISTRIBUTORCOMMISSIONTYPE} = -1.00 Organizations is the left table of the outer join. And yes I an using the names from that table! @comissionable is a field to make sure the invoice (right part of join) is within a certain date range. Thanks for all your help!
	IP Logged

karenc Newbie Joined: 06 Jul 2011 Location: United States Online Status: Offline Posts: 5	Posted: 20 Jul 2011 at 8:02am
	I meant to say that the {Organizations.cmoResellerOrganizationID} <> '""' and {@Commissionable} and {PartGroups.UIMUDISTRIBUTORCOMMISSIONTYPE} = -1.00 is in the select expert. If I am screwing up my outer join with the organization table being the left part of outer join AND in the above select...what are my options?
	IP Logged

<< Prev Page of 2

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.031 seconds.