I need to create a report based off information in a file I call LOG. This is an accumlative file being that it has data (mostly amounts) that start with an initial starting balance record and progress.

I need to have the user select the starting and ending dates for the report. The report needs to read all records PRIOR to the starting date to get a starting balance and only print records from the starting date through the ending date.

The balances depend on the various records record type... some add to certain fields, some subtract, some just printout.

The concept seems relatively straight forward except I only have written reports that list ALL the data in the file and doesn't do the selected printing, selected reading and mathematics based on a field type.

How do you accomplish something like this with the report writer? Suggestions?