How to set Excel Options using crystal reports 2008

[Former Member]

Hi,

I am trying to figure out CR 8.5 (Crystal report control) Equivalents in Crystal reports 2008 using crystal report viewer in .Net but not able to find the exact replacments.

Properties used in CR 8.5

CRAXDRT.ExportOptions.ExcelUseWorksheetFunctions=True

CRAXDRT.ExportOptions.ExcelUseTabularFormat =True

CRAXDRT.ExportOptions.SetLogOnInfo(1,3,4,5)

Please let me know the replacements for the above mentioned properties in .Net using crystal report viewer (CR 2008)

Thanks in Advance

Regards,

Ramnath

[former_member188030 · Accepted solution]

Hello,

The code that has been provided is of Report Designer Component.

RDC has been deprecated in Crystal Reports 2008.

Use the 'ExcelFormatOptions' class. It provides many options regarding exporting in an excel format.

ExcelFormatOptions myExportFormatOptions = new ExcelFormatOptions();

Try exploring the Developer guide for Crystal Reports .NET SDK [here|http://www.sdn.sap.com/irj/boc/sdklibrary#section7]..