Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Removing a selected field that is specified in the Post Reply Post New Topic
Author Message
Mellison
Newbie
Newbie
Avatar

Joined: 20 Nov 2009
Location: India
Online Status: Offline
Posts: 15
Quote Mellison Replybullet Topic: Removing a selected field that is specified in the
    Posted: 20 Feb 2011 at 12:51am

A field that is specified in record selection is getting selected.which i dont want to happen.i tried googling didnt find any possibilities.is there a way to do that?
Example
Record selection:
testDB.testTable.versionID = {?versionID}

SQL Query that is getting generated is as follows

select testDB.testTable.column1,testDB.testTable.versionID from testDB.testTable where testDB.testTable.versionID = {?versionID}

Here i dont want the testDB.testTable.versionID to get selected.since it spoils the distinct record selection.Is there a way to do that?

thanks
Mellison

IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 21 Feb 2011 at 7:54am
There is no way to do this when you select tables in the in the Database Explorer and have Crystal create your query.
 
If Crystal will allow it for your database, you could create a command that has the SQL for the full select statement for your report.  At that point you can control the exact fields that are selected.
 
-Dell
IP 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.031 seconds.