public void ShowCostingReport(List <Int32> transactionId)
{
var reportDocument = new ReportDocument();
reportDocument.Load(ResolveReportPath(ReportConstants.Costingchartreport));
var dataSet = _dataSetService.GetCostingChartDataSet(transactionId);
reportDocument.SetDataSource(dataSet);
var fileName = Application.StartupPath + @"/ExcelFiles/" + "CostingChart_" + DateTime.Now.ToString("MMddyyyy_HHmmss") + ".xls";
var crDiskFileDestinationOptions = new DiskFileDestinationOptions();
var crFormatTypeOptions = new ExcelFormatOptions();
crDiskFileDestinationOptions.DiskFileName = fileName;
var crExportOptions = reportDocument.ExportOptions;
crExportOptions.ExportDestinationType = ExportDestinationType.DiskFile;
crExportOptions.ExportFormatType = ExportFormatType.ExcelRecord;
crExportOptions.DestinationOptions = crDiskFileDestinationOptions;
crExportOptions.FormatOptions = crFormatTypeOptions;
reportDocument.Export();
if (!File.Exists(fileName))
{
return;
}
var excelApp = new Microsoft.Office.Interop.Excel.Application {
Visible = true
};
//Workbooks is a collection of all the workbook objects currently open in Excel
var books = excelApp.Workbooks;
//Workbook sheet is used to access the sheet identified above in mysheet
books.Open(fileName);
}
