Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Problem with missing data with linked tables.
This is what I have Two equal.... Rebate (member#) --> Member (member#) Rebate (Supplier#) --> Supplier (supplier#) Two Left Outers Rebate (member#) --> Sales (member#) Rebate (Supplier#) --> Sales (supplier#)- castle63
- Post #5
- Forum: Business Objects: Crystal Reports 3 Integrate
-
Problem with missing data with linked tables.
Thanks for the post lbass. Glad to see I wasn't the only one working on Saturday. :) My linking/SQL is as follows. I did an Inner Join to match the supplier and member tables. And Left outer joins to "try" and get the sales figures and rebate numbers. SELECT RebateJournal."documentdate"...- castle63
- Post #3
- Forum: Business Objects: Crystal Reports 3 Integrate
-
Problem with missing data with linked tables.
I am having a problem linking tables in such a way that I get ALL the data. I have four tables (Member, supplier, sales and rebates) I want to see all activity for a member (what rebates they got and what sales they had as well). Basically several rows for a member that says...- castle63
- Thread
- Replies: 5
- Forum: Business Objects: Crystal Reports 3 Integrate
