Open Position Report and Job Openings Dashboard

Open Position Report and Job Openings Dashboard

1. The open position report that I run always creates duplicate jobs.  I have tried to filter to just one record but am not able.  I attached a report with duplicates. 

2.  For Job Openings Dashboard.  Is there a way we can track which positions have candidates in "Associated" status.  For us candidates in "Associated" status means they have not been reviewed and/or dispositioned.  That is the status they are in when they come in from job boards tool.