Necesito exportar un crystal report a excel.
He probado de esta forma:
MemoryStream oStream;
oStream = (MemoryStream) report.ExportToStream.CrystalDecisions.Shared.Expo rtFormatType.Excel);
Response.Clear();
Response.Buffer= true;
Response.ContentType="application/vnd.ms-excel";
Response.BinaryWrite(oStream.ToArray());
Response.End();
y de esta otra forma:
ExcelFormatOptions excel = new ExcelFormatOptions();
excel.ExcelUseConstantColumnWidth = false;
excel.ExcelConstantColumnWidth=70;
DiskFileDestinationOptions disk = new DiskFileDestinationOptions();
disk.DiskFileName = "c:\\test.xls";
ExportOptions export = cr.ExportOptions;
export.FormatOptions = excel;
export.ExportFormatType = ExportFormatType.Excel;
export.ExportDestinationType = ExportDestinationType.DiskFile;
export.DestinationOptions = disk;
cr.Export();
El problema es q los campos ocupan varias columnas
COMO REMEDIAR ESTO???
GRACIAS