----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: jrkumar Message 3 in Discussion Try This - jr Declare variables and get the export options. Dim exportOpts As New ExportOptions() Dim diskOpts As New DiskFileDestinationOptions() Dim excelFormatOpts As New ExcelFormatOptions() exportOpts = Report.ExportOptions ' Set the excel format options. excelFormatOpts.ExcelTabHasColumnHeadings = true exportOpts.ExportFormatType = ExportFormatType.Excel exportOpts.FormatOptions = excelFormatOpts ' Set the export format. exportOpts.ExportFormatType = ExportFormatType.Excel exportOpts.ExportDestinationType = ExportDestinationType.DiskFile ' Set the disk file options. diskOpts.DiskFileName = fileName exportOpts.DestinationOptions = diskOpts Report.Export() [C#] // Declare variables and get the export options. ExportOptions exportOpts = new ExportOptions(); ExcelFormatOptions excelFormatOpts = new ExcelFormatOptions (); DiskFileDestinationOptions diskOpts = new DiskFileDestinationOptions(); exportOpts = Report.ExportOptions; // Set the excel format options. excelFormatOpts.ExcelUseConstantColumnWidth = true; exportOpts.ExportFormatType = ExportFormatType.Excel; exportOpts.FormatOptions = excelFormatOpts; // Set the disk file options and export. exportOpts.ExportDestinationType = ExportDestinationType.DiskFile; diskOpts.DiskFileName = fileName; exportOpts.DestinationOptions = diskOpts; Report.Export (); [C++] // Declare variables and get the export options. ExportOptions* exportOpts = new ExportOptions(); ExcelFormatOptions* excelFormatOpts = new ExcelFormatOptions (); DiskFileDestinationOptions* diskOpts = new DiskFileDestinationOptions(); exportOpts = Report->ExportOptions; // Set the excel format options. excelFormatOpts->ExcelUseConstantColumnWidth = true; exportOpts->ExportFormatType = ExportFormatType::Excel; exportOpts->FormatOptions = excelFormatOpts; // Set the disk file options and export. exportOpts->ExportDestinationType = ExportDestinationType::DiskFile; diskOpts->DiskFileName = "fileName"; exportOpts->DestinationOptions = diskOpts; Report->Export (); [VJ#] // Declare variables and get the export options. ExportOptions exportOpts = new ExportOptions(); ExcelFormatOptions excelFormatOpts = new ExcelFormatOptions (); DiskFileDestinationOptions diskOpts = new DiskFileDestinationOptions(); exportOpts = Report.get_ExportOptions(); // Set the excel format options. excelFormatOpts.set_ExcelUseConstantColumnWidth(true); exportOpts.set_ExportFormatType(ExportFormatType.Excel); exportOpts.set_FormatOptions(excelFormatOpts); // Set the disk file options and export. exportOpts.set_ExportDestinationType(ExportDestinationType.DiskFile); diskOpts.get_DiskFileName(fileName); exportOpts.set_DestinationOptions(diskOpts); Report.Export (); ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/BDotNet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
