snowdrop1 Posted June 8, 2010 Share Posted June 8, 2010 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>>! Link to comment https://forums.phpfreaks.com/topic/204168-sql-snowdrop-groupings/ Share on other sites More sharing options...
fenway Posted June 8, 2010 Share Posted June 8, 2010 What errors? Link to comment https://forums.phpfreaks.com/topic/204168-sql-snowdrop-groupings/#findComment-1069565 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.