Hi, If you want to open it in a new window then u need to do this... Just add this line after Response.ContentType = "application/vnd.ms-excel" ' set the content type Response.AddHeader("Content-Disposition", " attachment; filename=urreportname.xls") This will forcibly prompt the user either to open it/save it/cancel. I think this will do. Regarding the blank XL sheet, u better try with dataset first, as I've worked this example using sample DB and then sent it 2 u. Cheers Srinivas