Reading a Table

[nvtjellis]

My table (MS/ACCESS) is in accending date order. I need to create a report accessing the latest data(current date). The read begin at the start of the table. There are 76k records before the data to report on is selected.
I spoke the vendor who creates the Access table and explained that their canned crystal report sequencially reads this table, thus causing a long time to create the report requiring the current date data.

Question: Is there a "Set" statement that would position the read at the location of the key you supplied. For example:

?begin_here = 02/03/2005.

Set Read ?begin_here;

This read would begin at the first location of the parm.

How would this be done?
Internal bubble sort?
Use the high/low and divid to find where the value is located.
Or something.....

 

[synapsevampire]

A rather complicated description of the problm if I understand it correctly.

To limit rows to today in Crystal (this is version dependent, posting basic information will result in more accurate information):

Open Report->Edit Selection Formula->Record and palce something like:

{table.date} = currentdate

If you want to base it on a parameter, create the parameter (Insert->Field Object->Parameter, again, version dependent), make sure it is type Date, and then in the record selection formula for record use:

{table.date}={?MyDateParameter}

When the report is run it will prompt for a date and return only those rows.

Again the version of Crystal and the type of connectivity used can change this a bit, so please remember to post technical information.

-k