Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Export Crystal report in asp.net 2003

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:

[CODE]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[/CODE]

Is there any service pack to fix this?

Thanks.

Not what you were looking for? View more on this topic or Ask a question