First, I am relatively new to Crystal and this forum is the best Getting Started guide that I have found. Thank you to all contributors.
Second, this is probably a dumb question, so I apologize in advance.
I am using Crystal Reports 2008 (v 12.0.0.683). I am trying to get my selection criteria (entered in the Selection Expert) into the where clause that is sent to the DB server, but cannot seem to make it work. I.e., my selection criteria is being applied after the all the data in the entire table is returned to CR for filtering, but I want it applied on the server. I am expecting approximately 1,000 records to be returned from the server, but I am getting over 1M records. Obviously, performance is a problem.
I know that this is happening, because Show SQL Query shows no where clause, and I can see in the status bar at the bottom that there are 1M+ records returned.
A co-worker is using Crystal X, and his selection criteria is in the where clause.
Is there a setting that I am missing to force the selection criteria to the server, or do I have to write the query manually via Add Command?
Thanks in advance.
John