Skip to Content
0
Former Member
May 18, 2009 at 05:27 PM

Joins in Crystal reports

47 Views

Hello,

Am trying to create a join between the tables JDT1 and OCR1 in crystal reports through the links in the database expert but can't seem to get it working. I have used report builder for the same and in less than 3 mins I have the following

SELECT JDT1.TransId, JDT1.Account, OCR1.OcrCode, 
       OCR1.PrcCode, OCR1.OcrTotal, 
       JDT1.ProfitCode, OACT.AcctName, 
       JDT1.DueDate, JDT1.CreatedBy
FROM JDT1 JDT1 INNER JOIN OCR1 OCR1 ON 
     (OCR1.OcrCode = JDT1.ProfitCode)
      INNER JOIN OACT OACT ON 
     (OACT.AcctCode = JDT1.Account)
ORDER BY JDT1.ProfitCode, JDT1.Account

How can I do the same with Crystal Reports without manually typing in the code ? It's also pretty simple doing dataviews in report builder, Is this the same with CR ?

Edited by: Martin Kamau on May 18, 2009 7:48 PM