In Crystal Report is there a way to by pass the Database Expert and join the tables using SQL directly.

 

SELECT max(height.cdsiteno) as Institution,max(height.cdinstno) as Facility,max(height.cdassessdate) as CreateDate, max(height.cdassesstype) as Assessment, max( height.cdchartno) as Chart, max(height.cddate) as  HeightDate, max(height.cdvaluescm) as HeightCM, MAX(patinfo.cdlastassess) as LastPlan, weight.cddate as WeightDate, weight.cdvalueskg as WeightKilo
FROM (HEIGHT as HEIGHT
LEFT JOIN PATINFO AS PATINFO
ON ((((`PatInfo`.`CDSiteNo`       =`Height`.`CDSiteNo`)
  AND (`PatInfo`.`CDInstNo`           =`Height`.`CDInstNo`))
  AND (`PatInfo`.`CDChartNo`        =`Height`.`CDChartNo`))
  AND (`PatInfo`.`CDAssessDate`   =`Height`.`CDAssessDate`))
  AND (`PatInfo`.`CDAssessType`   =`Height`.`CDAssessType`))
left JOIN Weight AS Weight
ON ((((`Height`.`CDSiteNo`       =`Weight`.`CDSiteNo`)
  AND (`Height`.`CDInstNo`           =`Weight`.`CDInstNo`))
  AND (`Height`.`CDChartNo`        =`Weight`.`CDChartNo`))
  AND (`Height`.`CDAssessDate`   =`Weight`.`CDAssessDate`))
  AND (`Height`.`CDAssessType`   =`Weight`.`CDAssessType`)
WHERE PATINFO.CDLASTASSESS = TRUE
GROUP BY weight.CDChartNo, weight.cddate, weight.cdvalueskg
ORDER BY  weight.cdchartno asc, weight.cddate desc