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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Selecting Parent and Children of a Left Outer Join
@lbass Thanks for the reply. Yes, I've left-outer joined from part to part_comp; no selection criteria. The problem I'm running into is that if a part has components, my formula only returns those components. What I need is the part AND its components. If referring to the table in my initial...- Axminster
- Post #6
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Selecting Parent and Children of a Left Outer Join
Annoyingly now, my reply of thanks is not being submitted...- Axminster
- Post #5
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Selecting Parent and Children of a Left Outer Join
@lbass Thanks for the reply. Yes, I've left-outer joined from part to part_comp; no selection criteria. The problem I'm running into is that if a part has components, my formula only returns those components. What I need is the part AND its components. If referring to the table in my initial...- Axminster
- Post #4
- Forum: Business Objects: Crystal Reports 1 Formulas
-
Selecting Parent and Children of a Left Outer Join
Hi there, my first post here! I have 2 tables joined by a left-outer. The {part} table and the {part_comp} table. What I'd like my report to do is, with the use of a groupable formula, list the parent part and its components (if any). In their most basic, relevant form, the tables look like...- Axminster
- Thread
- Replies: 5
- Forum: Business Objects: Crystal Reports 1 Formulas
