on ‎2020 Jun 17 2:40 PM
As an HR User I am trying to create a (new) report which will be used for screening/assessment purposes. In this report I would like to include the following columns:
Job Req ID, Job Title, Gender, Present Nationality, Other Nationality, Last Name, First Name, Date Of Birth, Degree/Diploma, Main course of study, From, To, Job title, Name of employer, From, To, Licences/Certificates, Institution, Languages, Level.
I don't know how to group or sort this to get a single entry per applicant - currently I get a chaotic report - e.g. a candidate applied for a specific vacancy and he/she appears 3 times in Excel because he/she entered Master's & Bachelor's degree and a Certificate so I have multiple entries per candidate - the same happens if a candidates indicated various languages.
Basically I would like to create a report which I would run for each closed VA to get the above mentioned data.
Would you be able to help me how to create this kind of reports, which type of Report (Scheduled, Canva, Table) should I use etc. Any help would be great!
Regards,
Sara
Request clarification before answering.
Hi Sara,
I am not sure if this helps but have you tried using "Enable Distinct" button (appears below) while creating a report.
Thanks
Puja
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 3 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 2 | |
| 1 | |
| 1 | |
| 1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.