>>>>What would be the most straightforward way to get an Excel spreadsheet from a report? Can it be done directly from the REPORT FORM, or should it be done from the data prior to the report running? Any relevant ideas welcome. Thanks!
>>>
>>>I did this last year. Problem is that your report may be doing group and/or grand totals, with, say, report variables. When you export to the XLS then IT doesn't know where and/or why to do the cell summing. That's unless your report cursor has all the sums already in it and is just printed as-is.
>>>
>>>In short, I suspect you have to put some excel automation in the process too, esp. when just a bog-standard report cursor/flat file.
>>>
>>>Boris is the bees knees at this but I have some code that may be useful to you.
>>>
>>>In my case I created the rpt cursor with SQL only to have to go and do much of it in procedural code to get a format suitable for excel,
>>>
>>>X
>>
>>Thanks Terry! I would be very interested in seeing your code.
>
>OK CL, I've sent some snippets to your E.
>
>Terry

"There be dragons here. Continue?"

<vbg>