I liked that checkbox in Impromptu... Whats the closest thing to it in Report Studio?
Cognos adds a distinct to the SQL if no query item has an aggregate set. So, if you only fetch identifiers and attributes you should have a distinct set by default. If not, adding a distinct is pretty useless..