Jump to content

SQL -SNOWDROP GRoupings


snowdrop1

Recommended Posts

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.