Hi Cindy,

Your mention of a cursor jogged my mind. I was running my report
from a prg using the dbf with an index. I deleted the index and
it work perfectly. I then scrapped the dbf and used a select
statement with a cursor. Tried with the cursor also creating a
table and everything is working beautiful. Thank you very much
for your patience and help in this matter. Just coming over from
version 2.6 for dos is quite a change.

Tom




>Tom,
>
>Wild ideas:
>
>What's happening in your other groupings?
>2 fields is not as important as the number of records.
>What about rounding errors? (SET commands in your production system different than your VFP5 development system?)
>
>Add a field to your report cursor (in development) and populate it with the value of the formula. Browse the cursor. Show this field on the report. See what it does.
>
>Happy debugging!
>
>
>>>Thomas,
>>>
>>>Assuming that you have one report line per record, group your data on INT((RECNO()-1)/20) for 20 lines per page for example.
>>>
>>>[Copy the expression into the first line of the dialog box found under Reports|Data Grouping. Check the box which says "Start each group on a new page"]
>>>
>>>
>>>>I would like to be able to print a multi page report
>>>>with a set number of lines printed on each page. Would
>>>>appreciate a step by step process for this.
>>>>
>>>>TIA
>>
>>Hi Cindy,
>>
>>Tried the above formula and it works perfectly when working
>>within 5.0 but when I create the exe file and run it outside of
>>foxpro,asking for 5 lines I get 5 on pages 1 & 2. It then
>>alternates on the rest of the pages from 1 to 5 lines. This
>>report contains only 2 fields. Any idea what is happening?
>>
>>Tom