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!
-
How do you keep One to Many Relationship with Parameter Field
I have a "Left Outer Join" SQL statement linking an "Apartment" table and "Resident" table from an Access Database. The report runs fine in Crystal Reports, it prints all apartment numbers out even if there are no residents for that apartment. However, when I add a...- precious
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 4 Other topics
-
forcing a group to display
Kobe: Have you found a solution to this problem yet? I am having the exact same problem and have not found a satisfactory solution. I have created a report that has a one to many relationship. The report prints from an "Apartment" file, groups by "ApartmentID", and prints...- precious
- Post #5
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Keep Left Outer Join with parameter field
I have a "Left Outer Join" SQL statement for my "Access Database". When I create my Crystal Report it works great, however, when I add a parameter field to the report, the report comes back with the requested records as it should. But I want the first field in each record...- precious
- Thread
- Replies: 1
- Forum: Business Objects: Crystal Reports 4 Other topics
