Hi,
I am exporting crystal report to excel file, I face the following problems.
1.Border of the cells are not visble in the excel sheet.
2.Some columns are getting overlapped.

please provide me the steps to solve this problem.

Below is the part of code am using:

Select Case ExportFormatType
                Case "MS Excel (XLS)"
                    oStream = DirectCast(crReportDocument.ExportToStream(CrystalDecisions.[Shared].ExportFormatType.Excel), MemoryStream)
                    Response.Clear()
                    Response.Buffer = True
                    Response.ContentType = "application/vnd.ms-excel"
                    Response.BinaryWrite(oStream.ToArray())
                    Response.End()
            End Select

Is there any service pack to fix this?
Thanks.

I agree with BrianB.  It can be tricky.  Even if you get it to work well once, it may not work exactly the same if run later with different data.