cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

How to create a report on Applicants Work and Education background without duplication?

Former Member
0 Likes
434

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

Accepted Solutions (0)

Answers (1)

Answers (1)

pujasingh1
Participant
0 Likes

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