Hello all,

I have a web application that creates reports.

I need to export a report to .xls file and save the file to the client computer.


at the moment the file gets saved onto the server...



code:--------------------------------------------------------------------------------
Fname = "C:\Reports\Excel\Report.xls"
crDiskFileDestinationOptions.DiskFileName = Fname
With myReport.ExportOptions
.DestinationOptions = crDiskFileDestinationOptions
.ExportDestinationType = ExportDestinationType.DiskFile
.ExportFormatType = ExportFormatType.RichText
End With
myReport.Export()
--------------------------------------------------------------------------------

how would i change my code to solve my problem?

thanx,
Tom