You can use COPY TO, of course, but that doesn't really give you much options. You have much more options, for an Excel report, if you use Automation. See my introductory article about Excel Automation.
>hi all,
>
>any way to convert myreport to excel sheet ,
>as
>report form myreport to excel sheet, or replace all created fileds at my report to new temporary table or cursor, and change it to excle sheet via
>
>ex..
>report form myreport to (newtable or cursor)
>**********
>use (newtable or cursore)
>gcDelimName = ALIAS( ) + '.xls'
>gcDelimFile = PUTFILE('excel_file:', gcDelimName, 'xls')
>IF EMPTY(gcDelimFile)
> CANCEL
>ENDIF
>COPY TO (gcDelimFile) XL5
>
>thanks
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)