cancel
Showing results for 
Search instead for 
Did you mean: 

"Select Distinct Records" Option Not Available

Former Member
0 Kudos

Hello Experts.

I am working on a new report in CR XI, and noticed that I had many duplicate records. I went to the File; Report Options; and expected to click on "Select Distinct Records", but that choice was grayed-out. What would have caused me to lose this option, and how do I fix it?

Thanks in advance for your help.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Not sure if this covers it or not, but....

The Select Distinct Records command is only available for ODBC, OLE DB, and SQL native drivers; it is not available for Stored Procedures. Note also that your server may automatically sort returned values if no sort is specified in Crystal Reports.

Former Member
0 Kudos

That suggestion worked. I updated my connection, and viola! Problem solved. Thanks so much. Points awarded!

Answers (0)