Distinct Records in List Of Values

I am using Business View Manager with Crystal Report Server XI.

I am trying to create a List Of Values with a DISTINCT set of records from a SQL Statement.

"SELECT DISTINCT(field_name) FROM table_name" works fine from SQL Plus but I am not sure how to implement it in Business View Manager.

Any help would be appreciated.

Ray