export a report to a file on the client pc

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

I think you'd have to use JavaScript for that since all ASP.NET runs on the server-side.

Would having asp.net create it then issue a download work? Just curious, I don't do asp much.

Ok, how do i produce a "save as" dialog box so the user can specify the location to save the file?

I need to write the report to the CLIENT machine NOT the SERVER!