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>>! Quote 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? Quote Link to comment https://forums.phpfreaks.com/topic/204168-sql-snowdrop-groupings/#findComment-1069565 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.