private void Page_Load(object sender, System.EventArgs e) { //try //{ ReportViewerControl.LocalReport.ReportPath = _functions.GetValueFromConfig("SQLRS.DefaultPath") + ".rdlc"; if (Request["Report"] != null) { ReportViewerControl.LocalReport.ReportPath = Request["Report"] + ".rdlc"; } ReportViewerControl.LocalReport.EnableExternalImages = true; clsWorkOrders wo = new clsWorkOrders(); if (!string.IsNullOrEmpty(Request["OrgId"])) { wo.iOrgId = Convert.ToInt32(Request["OrgId"]); } if (!string.IsNullOrEmpty(Request["OrderId"])) { wo.iId = Convert.ToInt32(Request["OrderId"]); } if (!string.IsNullOrEmpty(Request["InspectId"])) { wo.iInspectionId = Convert.ToInt32(Request["InspectId"]); } string url = string.Empty; if (!string.IsNullOrEmpty(Request["URL"])) { url = Request["URL"]; } foreach (string dataSource in ReportViewerControl.LocalReport.GetDataSourceNames()) { switch (dataSource) { case "ReportedIssueList": DataSet ds = wo.GetReportedIssueLists(); if (ds != null && ds.Tables.Count > 0) { ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, ds.Tables[0])); } break; case "PMItemList": ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetPMServicesListForWorkOrder())); break; case "InspectionsList": ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetInspectionsListForWorkOrder())); break; case "WorkOrderDetail": ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetDetailsForWorkOrder())); break; case "CreationNotesList": wo.iNoteTypeId = 1; ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetNotesList())); break; case "OperatorNotesList": wo.iNoteTypeId = 2; ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetNotesList())); break; case "PartsList": ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetPartsUsedListForReport())); break; case "ReportedIssuesList": ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetReportedIssues())); break; case "PMItemsList": ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetPMItemsList())); break; case "RepairsList": ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetRepairsListForReport())); break; case "TechNotesList": wo.iNoteTypeId = 3; ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetNotesList())); break; case "CheckOutNotesList": wo.iNoteTypeId = 4; ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetNotesList())); break; case "CheckInDetails": ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.CheckInDetailsForReport(url))); break; case "InstructionList": ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetInstructionByCheckIn())); break; case "InspectionDetail": ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetInspectionDetailForReport())); break; case "InspectionItemsList": ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetInspectionItemsListForReport())); break; case "InspectionList": ReportViewerControl.LocalReport.DataSources.Add(new Microsoft.Reporting.WebForms.ReportDataSource(dataSource, wo.GetInspectionListForReport())); break; } } }