public void BindData(ReportFilter filter) { try { ReportController control = new ReportController(); xrTenCoQuanDonVi.Text = control.GetCompanyName(filter.SessionDepartment); var location = new ReportController().GetCityName(filter.SessionDepartment); lblReportDate.Text = string.Format(lblReportDate.Text, location, DateTime.Now.Day, DateTime.Now.Month, DateTime.Now.Year); // get organization var organization = cat_DepartmentServices.GetByDepartments(filter.SessionDepartment); if (organization != null) { var age = 16; var giftLevel = "300.000"; //select form db var arrOrgCode = string.IsNullOrEmpty(filter.SelectedDepartment) ? new string[] { } : filter.SelectedDepartment.Split(new[] { "," }, StringSplitOptions.RemoveEmptyEntries); for (int i = 0; i < arrOrgCode.Length; i++) { arrOrgCode[i] = "'{0}'".FormatWith(arrOrgCode[i]); } var table = SQLHelper.ExecuteTable(SQLManagementAdapter.GetStore_ListEmployeeHaveChildrenReceiveMidAutumnFestivalGift(string.Join(",", arrOrgCode), age)); DataSource = table; xrTableCellGiftLevel.Text = giftLevel; //binding data xrTableCellEmployeeCode.DataBindings.Add("Text", DataSource, "EmployeeCode"); xrTableCellFullName.DataBindings.Add("Text", DataSource, "FullName"); xrTableCellBirthDate.DataBindings.Add("Text", DataSource, "BirthDate", "{0:dd/MM/yyyy}"); xrTableCellSex.DataBindings.Add("Text", DataSource, "Sex"); xrTableCellPosition.DataBindings.Add("Text", DataSource, "Position"); xrTableCellTypeOfContract.DataBindings.Add("Text", DataSource, "TypeOfContract"); xrTableCellNumberOfChildren.DataBindings.Add("Text", DataSource, "NumberOfChildren"); GroupHeader1.GroupFields.AddRange(new GroupField[] { new GroupField("DepartmentId", XRColumnSortOrder.Ascending) }); xrTableCellGroupHead.DataBindings.Add("Text", DataSource, "DepartmentName"); } } catch { } }