Jump to content

snowdrop1

New Members
  • Posts

    7
  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

snowdrop1's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. UR NO HELP!>!>>.ANNOYING BUT NO HELP!>>!>
  2. snowdrop HRIS!!! HAVENT u heard of it..!> i need assistance and i need it fast.>!>!
  3. IF u cant understand what im asking....dont say anything at all!>
  4. HELLO i will be doing a company appraisal report shortly...where i have to enter appraisal ratings into the appraise look up table? however , is there a way of defaulting the date to the 1st july 2010, instead of having to select the date from the calender option provided. according to the manuals i have to go into the exe or ini. program and adjust it from there.. i have found the following txt... APPRAISE=select ADATE,NEXT_APP,PERFORMANCE,POTENTIAL,APP_BY,APPRAISE_REF from APPRAISE can u help?
  5. 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>>!
×
×
  • 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.