>So the view cannot be modified.
>
>I'm not too keen on changing the tables for the sake of a report, is there a way I can get around that, and just change the fields on the cursor?
>
>Kev

I think you misunderstood. I create a table that's not used by anything except the report. Then I create the view based on that and move any data needed for the report into the view. If you don't want to use a dedicated table for the report, your best bet is to just create a temporary cursor and make it R/W. When you do your initial select from your tables, include the extra fields needed later.

Eg.

SELECT field1, field2, field3, ;
   0.000 AS numfield, ;
   SPACE(20) as charfield ;
   FROM mytable ;
   INTO CURSOR myTemp

USE DBF("myTemp") AGAIN IN 0 ALIAS reportcursor