Crystal Reports distinct select

Report Design
Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design

Topic: distinct select

Author	Message
aekelund Newbie Joined: 05 Apr 2007 Online Status: Offline Posts: 20	Topic: distinct select Posted: 07 May 2007 at 11:36am
	I'm having problems with a report that was working fine, now it is giving me a distinct select error. Any body have any ideas about why I am now getting a select distinct statement in my SQL statement? Regards, Andrew
	IP Logged

BrianBischof Admin Group Joined: 09 Nov 2006 Online Status: Offline Posts: 2458	Posted: 07 May 2007 at 12:16pm
	Have you tried viewing the SQL Query to see what CR is sending to the database server (you can do so under the Database menu option).
	Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
	IP Logged

bobsn Newbie Joined: 19 Mar 2007 Online Status: Offline Posts: 27	Posted: 07 May 2007 at 12:42pm
	If you are using XI, I think the admin can change the sql to produce just select. Crystal can be set up to give select distinct in version XI.
	IP Logged

aekelund Newbie Joined: 05 Apr 2007 Online Status: Offline Posts: 20	Posted: 07 May 2007 at 12:45pm
	Ok I found were it allows you to select discinct records.
	IP Logged

Post Reply

Post New Topic

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

This page was generated in 0.033 seconds.