Hi
Thanks for you reply. I double check for spaces but there is no extra spaces.Problem is there is one free row before group header and one free row after group header,any thing we need to care while creating reports for avoiding this..
i am using the code
Nameval = System.Configuration.ConfigurationManager.AppSettings
Dim myExportOptions As ExportOptions
Dim myDiskFileDestinationOptions As DiskFileDestinationOptions
Dim myExportFile As String
Dim FileName, ReportTemp As String
ReportTemp = Nameval("ReportTemp").ToString
FileName = Now.Hour & Now.Minute & Now.Second & Now.Millisecond
myExportFile = Trim(ReportTemp) & Trim(FileName) + ".xls"
myDiskFileDestinationOptions = New DiskFileDestinationOptions
myDiskFileDestinationOptions.DiskFileName = myExportFile
myExportOptions = Crd.ExportOptions
myExportOptions.DestinationOptions = myDiskFileDestinationOptions
myExportOptions.ExportDestinationType = ExportDestinationType.DiskFile
myExportOptions.ExportFormatType = ExportFormatType.Excel
Crd.Export()
Response.ClearContent()
Response.ClearHeaders()
Response.AddHeader("Content-Disposition", "inline;filename=" & FileName & ".xls")
Response.ContentType = "application/ms-excel"
Response.WriteFile(myExportFile)
Response.Flush()
Response.Close()
System.IO.File.Delete(myExportFile)
Crd.Close()
Crd.Dispose()
IP Logged
