>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?
I strongly suggest you read all the data and send it to a cursor. Later, you only have to execute your report and display the fields on the cursor.
I'm a mixture of Albert Einstein and Arnold Schwarzenegger. The only trouble is that I got Einstein's body and Schwarzenegger's brain