Joined: 01 Nov 2011
Location: United States
Online Status: Offline
Posts: 1
Topic: SQL Command and Record Selection Posted: 01 Nov 2011 at 11:12am
Does anyone know if it's possible to have an SQL command with a where clause to filter your data and then also have additional filters in Crystal select expert. If so, in what order will the statements be executed? Doesn't make much sense to me to have both but I found a co-workers report build this way.
Joined: 19 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 150
Posted: 02 Nov 2011 at 3:54am
I've done this when the record selection is based on a complicated sequence of input parameter dates. The sql works first, and that is the data the report is working on overall. Then it is further restricted by the record selection.
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
IP Logged
