SQL -SNOWDROP GRoupings

[snowdrop1]

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>>!

[fenway]

What errors?