select reportcat.name as category, report.id, report.name, report.options, 
report.reporttype
from report
left join reportcat on (report.reportcat_id=reportcat.id)
where report.options COLLATE UNI_CI like '%frmEditorPatient%'
order by reportcat.name, report.name

---

 Comments and Workarounds

---

The issue is with the Category correlation name for the reportcat.name select expression. The workaround is to use this ORDER BY clause:

ORDER BY Category, report.name

---

 Resolution

---

Fixed Problem on 3/4/2009 in version 2.02 build 9

---

 Products Affected

---

ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial