Hi all

Please can someone give me some pointers on how to design this report?

I have a report that will pull the balance of the savings for the date range that I specify that will be populated from my main report.  The output would look like this in the sub report and my date range is 2007, 05,01 to 2007,12,31:

Tran-date            Sequence number        Balance

2007/05/03                         22                2563.25

2007/06/17                         23                2345.25

2007/08/03                         24                4563.25

2007/11/26                         25                3652.25 

What I would like to do is select the next date and only show that balance.  As you can see, my start date does not equal the first transaction date.  I would like to tell crystal to search for the next date and only show me that balance. I would also like to only see the balance before my last date. E.g.  2007/05/03 - 2563.25 and 2007/11/26 - 3652.25. I would only want to show the first and last balance that is closest to my date range.

Any ideas on how I can accomplish this.