Distinct Records in List Of Values

[Former Member]

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

[Former Member · Accepted solution]

Create a Data Foundation using the SQL command as the data source.

HTH,

Carl