Hello,

I am using version 10 to query some sales data from a retail database. I don't know what the database is built on, but I am connecting via ODBC protocol.

I am currently only using one table, and only querying one field to make this report as simple as possible before I expand. The selection criteria is sale date and the only field in the report is item number. If I query using 9/13 and later, the results are returned very quickly (over 15,000). If I query with a sale date before that, the report takes a very long time to go through records. It should be relatively the same amount of data, but at the bottom right of Crystal Reports, where is shows the number of records queried, it averages about 50 per minute on dates before the 13.

Is there anything I can try to figure out what the problem is?

I don't know. But I would do Show SQL Query and see if the date filter is being passed to the database or not. You want SQL to do the filtering instead of making CR do it. Also, is there an index on the date field?