>Emmanuel
>
>Being a bit new to VFP, can you recommend on how do do this? Also, if all the records are read, how do I limit which ones print.
>
>Pete
>
>
>>>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.

once you got all the records on the cursor, you only have to issue a Report form command and include the records with the "For", "While" clauses you can learn more on this on the report form Help topic. If you need anything else let me know.