search order in DBF files

[tedi1]

I have a report that is based on a Dbase file.
The user needs to enter range of dates for the report. The problem is that the report runs form the first DB record to the last and the dates are mainly at the most recent records.
My question is how can I determine the search direction to start from the last record and not from the first one. Another question that I have is: can I set the search to stop at a certain point, so if the search had retrieved all the records then it can stop.

 

[dgillz]

Crystal cannot do what you are asking, it reads the records in the order that they are phyically in the database.

However, if you can change your database and you put an index on the date field in question, I have seen crystal performance increase dramatically.

If you do this, be sure to verify your database in crystal or it will not pickup the database change. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[tedi1]

Thanx for your replay,

I have tried to use index for these file but with no change in the response time. Do you have any other idea to speed up the response?