Crystal Reports Purpose of enforce From n enforce to

Message


     Yes there is a difference and I think Lockwelle explained it pretty well. I assume you are asking because your "query" is still not working. However I am confused as to where you are using this query. Since you are seeing the enforce to / from options it means you added the two tables to the report and joined them in the table expert. BY doing that Crystal writes it's own SQL expression that would be similar to what you are trying to write. Given this why are you trying to use a query at all? Are you trying to write a select statement in crystal? 
The Select expert in crystal is used to filter down the data not recreate your SQL statement. With the select statement you do not redefined the tables, joins and fields you want to include in the report, you just limit that data down (e.g. you only want the department of "ABC" in the report you put {dep.depname}="ABC" in the select statement).
Am I missing something here? 


Edited by DBlank - 25 May 2009 at 8:25am