cancel
Showing results for 
Search instead for 
Did you mean: 

Distinct Records in List Of Values

Former Member
0 Kudos

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

View Entire Topic
Former Member
0 Kudos

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

HTH,

Carl