Date matrix

[radhak]

I would like to find out how how could get a report doing the following:____File which contains the issue date and expiry date____I need a report which reads through this file for a given date range and prints out:____All records falling within the date range in date order.____data:____Card number Issue date Expiry date__1111 03/23/04 03/22/05__1232 03/22/04 03/21/05__9987 04/25/03 04/24/04______If I give date range of 03/20/04 and 03/25/04____I should be able to get a report like the following____03/20/04 9987__03/21/04 9987__03/22/04 1232__ 9987____03/23/04 1111__ 9987__ 1232____03/24/04 1111__ 9987__ 1232______03/25/04 1111__ 9987__ 1232__If some one could let me know how this could be achieved I would greatly appreciate it.____Thanks and Regards__Radha

[kfleming]

I think that you would need to build a DBF that would have one record for each date that you want to use in the report.____Kathleen__R&R Support