public void BindData(ReportFilter filter) { try { ReportController rpCtr = new ReportController(); xrl_TenCongTy.Text = rpCtr.GetCompanyName(filter.SessionDepartment); var arrDepartment = string.IsNullOrEmpty(filter.SelectedDepartment) ? new string[] { } : filter.SelectedDepartment.Split(new[] { "," }, StringSplitOptions.RemoveEmptyEntries); for (int i = 0; i < arrDepartment.Length; i++) { arrDepartment[i] = "'{0}'".FormatWith(arrDepartment[i]); } var control = new ReportController(); var location = control.GetCityName(filter.SessionDepartment); xrt_ReportDate.Text = string.Format(xrt_ReportDate.Text, location, DateTime.Now.Day, DateTime.Now.Month, DateTime.Now.Year); var table = SQLHelper.ExecuteTable( SQLManagementAdapter.GetStore_ReportlistemployeeProbation(String.Join(",", arrDepartment))); DataSource = table; //Binding data xrtEmployeeCode.DataBindings.Add("Text", DataSource, "EmployeeCode"); xrtFullName.DataBindings.Add("Text", DataSource, "FullName"); xrtBirthDate.DataBindings.Add("Text", DataSource, "BirthDate", "{0:dd/MM/yyyy}"); xrtSex.DataBindings.Add("Text", DataSource, "Sex"); xrtAddress.DataBindings.Add("Text", DataSource, "Address"); xrtRecruimentDate.DataBindings.Add("Text", DataSource, "RecruimentDate", "{0:dd/MM/yyyy}"); xrtJobName.DataBindings.Add("Text", DataSource, "JobName"); xrtPositionName.DataBindings.Add("Text", DataSource, "PositionName"); GroupHeader1.GroupFields.AddRange(new[] { new GroupField("DepartmentId", XRColumnSortOrder.Ascending) }); xrlDepartmentName.DataBindings.Add("Text", DataSource, "DepartmentName"); } catch (Exception ex) { Dialog.ShowNotification("Có lỗi xảy ra " + ex.Message); } }