That's what I did. I had two different problems with formatting and used the cursor to solve both of them. I also used it to break up long fields into pieces (by copying them into a memo cursor and using MLINE()) and printing the pieces opposite different child records, solving the problem I described in my other thread.
The report writer is so inflexible I sometimes wonder if I should use it at all. Maybe I should just start using OLE Automation and run all my output into Word.
>If I am understanding your question correctly it seems you will have to use a whole new approach. First of all the report variable is calculated AS the detail is being printed. This means that by the time you get the value the page is already printed. So you will have to use something other than a report variable.
>My suggestion would be to write a routine which creates the cursor used by the report. This way you will only insert the records into the cursor that you want printed, therefore skipping all pages you do not want to print. I hope this helps.
>
>GeneS
>
>
>
>>I have a report which has a report variable holding the highest value on one of the fields, printing at the bottom of the page, and resetting at the bottom of the page. I would like the report to print only those pages that have a certain value printing at the bottom. It amounts to PRINT WHEN varname = myvalue for the page. What is the best way to make it happen?