Hello, When I go to the Ad Hoc views and add all the fields, I am getting multiple rows of data. Checking the "View SQL Query", it is using 'select', and I need it to use 'select distinct'. Is there a way to do that? There are about 9 join statement for this so I need a way to select distinct values.