public void BindData(ReportFilter filter) { try { var arrDepartment = string.IsNullOrEmpty(filter.SelectedDepartment) ? new string[] { } : filter.SelectedDepartment.Split(new[] { "," }, StringSplitOptions.RemoveEmptyEntries); for (var i = 0; i < arrDepartment.Length; i++) { arrDepartment[i] = "'{0}'".FormatWith(arrDepartment[i]); } var control = new ReportController(); var location = control.GetCityName(filter.SessionDepartment); lblReportDate.Text = string.Format(lblReportDate.Text, location, DateTime.Now.Day, DateTime.Now.Month, DateTime.Now.Year); var table = SQLHelper.ExecuteTable( SQLManagementAdapter.GetStore_ReportListEmployeeReceivesGift8_3( string.Join(",", arrDepartment))); DataSource = table; xrTableCellEmployeeCode.DataBindings.Add("Text", DataSource, "EmployeeCode"); xrTableCellFullName.DataBindings.Add("Text", DataSource, "FullName"); xrTableCellDateBirth.DataBindings.Add("Text", DataSource, "BirthDate", "{0:dd/MM/yyyy}"); xrTableCellSex.DataBindings.Add("Text", DataSource, "Sex"); xrTableCellIDNumber.DataBindings.Add("Text", DataSource, "IDNumber"); xrTableCellDepartmentName.DataBindings.Add("Text", DataSource, "DepartmentName"); xrTableCellDescription.DataBindings.Add("Text", DataSource, "Description"); GroupHeader2.GroupFields.AddRange(new[] { new GroupField("ConstructionId", XRColumnSortOrder.Ascending) }); xrGroupConstruction.DataBindings.Add("Text", DataSource, "ConstructionName"); } catch { } }