I have 2 tables of which some records in the second one are missing. I haev to complete those, how do I locate those and display them on my report? I use a left join or not exists clause in a query to get the results on the database, but I don't know how to write a formula that does the same thing in crystal for me.
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!
Creating a formula that does a Left Join on two tables
- Thread starter p8ass8
- Start date
Hi,
You do not use a formula to do this. You can either join the tables in the Database expert and set the join to be a Left Outer, or use your working SQL code as a Command Object and base your report on that..
![[profile]](/data/assets/smilies/profile.gif "[profile] [profile]")
To Paraphrase:"The Help you get is proportional to the Help you give.."
You do not use a formula to do this. You can either join the tables in the Database expert and set the join to be a Left Outer, or use your working SQL code as a Command Object and base your report on that..
To Paraphrase:"The Help you get is proportional to the Help you give.."
- Status
Similar threads
- Locked
- Question
- Locked
- Question