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