Hello i have the following report set up actually in snowdrop Hris..however it is pulling in multiple entries by employee ref...and last name /fiirst name.
i need to group the data into a single line per employee..
i have attachecd the code...
SELECT Employee.SURNAME AS Surname_1,
Employee.DATE_LEFT AS Date_left,
Employee.FORENAME AS Forename,
Trainrec.CANCELLED AS Cancelled,
Employee.EMPLOY_REF AS Employ_ref,
Trainrec.COURSENAME AS Coursename,
(RTRIM(EMPLOYEE.FORENAME) + ' ' + EMPLOYEE.SURNAME ) AS Surname,
Trainrec.COURSE_REF AS Course_ref,
Trainrec.EXPIRY_DATE AS Expiry_date,
Trainrec.FINISHTIME AS Finishtime,
Trainrec.TYPE AS Type,
Trainrec.ATTENDED AS Attended,
(CONVERT(VARCHAR(12), TRAINREC.STARTTIME, 103)) AS Starttime,
Trainrec.STATUS AS Status
FROM EMPLOYEE
INNER JOIN TRAINREC
ON Employee.EMPLOY_REF = Trainrec.EMPLOY_REF
ORDER BY Employee.EMPLOY_REF ASC,
Trainrec.COURSENAME ASC,
(RTRIM(EMPLOYEE.FORENAME) + ' ' + EMPLOYEE.SURNAME ) ASC
can u give me the correct grou by code..!> as its coming back with errors everytime i try>>!