Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Distinct Record Only Post Reply Post New Topic
Author Message
lorimack
Groupie
Groupie


Joined: 03 Nov 2009
Online Status: Offline
Posts: 48
Quote lorimack Replybullet Topic: Distinct Record Only
     Posted: 15 Sep 2010 at 4:53am
Hi there,
 
I  have a report that is showing duplicated lines for each row of data, its only showing them once.
 
I tried using the select distinct records option but get the error "Failed to retrieve from Database 42000 Text data type cannot be selected as DISTINCT because it is not comparable"
 
Any ideas on how to fix?
IP IP Logged
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum