private void btnSavetoExcel_Click(object sender, EventArgs e)
{
RPT.RPT_ALL_Donations RPT_ALL_Donations = new RPT.RPT_ALL_Donations();
ExportOptions export = new ExportOptions();
DiskFileDestinationOptions diskFileDestination = new DiskFileDestinationOptions();
//To save it to execel
ExcelFormatOptions excelFormat = new ExcelFormatOptions();
diskFileDestination.DiskFileName = @"E:\text.xls";
export = RPT_ALL_Donations.ExportOptions;
export.ExportDestinationType = ExportDestinationType.DiskFile;
export.ExportFormatType = ExportFormatType.Excel;
export.ExportFormatOptions = excelFormat;
export.ExportDestinationOptions = diskFileDestination;
//end of save excel type
//To save it to PDF
/*PdfFormatOptions pdfFormat = new PdfFormatOptions();
* diskFileDestination.DiskFileName = @"E:\DonationsList.PDF";
* export = RPT_ALL_Donations.ExportOptions;
* export.ExportDestinationType = ExportDestinationType.DiskFile;
* export.ExportFormatType = ExportFormatType.PortableDocFormat;
* export.ExportFormatOptions = pdfFormat;
* export.ExportDestinationOptions = diskFileDestination;
*/
RPT_ALL_Donations.Export();
//end save it to PDF
MessageBox.Show("Done!..");
}