I’m working on a report in Crystal (vs CR11) using a left outer join to link 2 tables. I want to see the sales of all producers. I’m using an odbc connection and db2p tables. It doesn’t seem to pick up the non-producers when I set this up; only those who have sales. Let me know if you need more information. Any help would be appreciated.
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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
left outer join not working
- Thread starter ncchish
- Start date
elsenorjose
Technical User
Have you tried running the SQL query generated by Crystal Reports directly in your database query tool? In your report go to the 'Database' menu selection and choose 'Show SQL Query'. Copy and paste that into your database query tool and run it. It could be as simple as an incorrect join.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question