>As long as the data gets exported to an excel file, the customer doesnt care.
>
>I'm not sure what you mean by a view on a report. How would you take a view of the displayed report values.
>
>My field expression looks like this in the report; round(AHD*25.4,2) so only the displayed value is in metric.
Oh I understood customer wanted to dýrectly access to table výa some connectýon lýke OleDb. If that was the case you'd simply create a view of that table where you set your fields to expressions. ie:
create sql view myMetricView as ;
select round(AHD*25.4,2) as AHD, round(otherField*25.4,2) as otherField ... ;
from myTable
Now your case is simplier. You don't even need the view just the sql.
select round(AHD*25.4,2) as AHD, round(otherField*25.4,2) as otherField ... ;
from myTable ;
into cursor crsExport
copy to myExcelExport type CSV
Alternatively still view (or just the SQL) might be of value if you'd create an excel file that refreshes data from live VFP table. To do that you'd create an excel file that adds a query table (QueryTablesAdd).
PS: For QueryTablesAdd sample check Thread #
949002There a disconnected recordset is used. However you could modify the code and it has a live connection directly to your database (hence query from table).
Cetin