Page tree
Skip to end of metadata
Go to start of metadata

The Certificate of Completion report prints the certificates of completion for users from their learning history.

This is a user side report since it has (User) at the end of the report name.

  

  

Report NameCertificate Of Completion Learning Event
REPORT_NAME_IDCertificateOfCompletionLearningHistoryUser
REPORT_ID191
CATEGORY_ID 
GROUP_ID
WORKFLOW_IDView User Certificate of Completion Learning Event Report
TYPEBIRT /PRD
PUBLISHEDYes
SHOW_IN_MENUNo

 

SQL Query used

master
SELECT s.lname, 
       s.fname, 
       s.mi, 
       c.cpnt_title 
FROM   pa_student s, 
       pa_cpnt c 
WHERE  1 = 1 
/** and s.stud_id IN [UserSearch] 
    and (c.cpnt_typ_id,c.cpnt_id,c.rev_dte) IN [ItemSearch]  */ 
ORDER  BY lname, 
          fname, 
          mi, 
          c.cpnt_typ_id, 
          c.cpnt_id, 
          c.rev_dte 

 

 

 

Link: http://wiki.scn.sap.com/wiki/x/IYHyFw