>>>>>>>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>
>>
>>It's a bit like that at first glance. Have sent you another E with an example of the results, so your brain not too much hurt um.
>
>No, I'm just making fun of your error message in the code. The one that you sent that might not be yours, now that I've read your other post?

Aye, there aren't any error messages in the code - it must be someone else's. Mine is the one that's from Terry McDonnell, you know!!!!