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