I am working my way through the document cr13sp1_cr_usergdr_en.pdf and am trying to make a hierarchial grouping. I'm trying to use the SQL Expression Editor to create a table with employee and supervisor info only.
In the access database that is supplied the SQL syntax is:
SELECT Employee.[First Name], Employee_1.[First Name]
FROM Employee INNER JOIN Employee AS Employee_1 ON Employee.[Employee ID] = Employee_1.[Supervisor ID];
I cannot get this to work in Crystal Reports.
I can't even get this to work:
SELECT `Employee`.`First Name` FROM `Employee`
I get a Syntax Error message:
Error in compiling SQL Expression
Database Connector Error: 'DAO Error Code: 0xc03
Description: Syntax error. in query expression 'SELECT `Employee`.`First Name`