Use a SQL Command object. That way you specify the exact SQL you want to use. Otherwise, to simulate this in CR you would create a group on the fields and the Detail section will just show a single line for each DISTINCT row.