public void BindData(ReportFilter filter) { try { var control = new ReportController(); xrTableCellDepartment.Text = control.GetCompanyName(filter.SessionDepartment); //var toDate = new DateTime(filter.Year, filter.StartMonth, DateTime.DaysInMonth(filter.Year, filter.StartMonth)); var toDate = filter.ReportedDate; lblReportDate.Text = string.Format(lblReportDate.Text, toDate.Day, toDate.Month, toDate.Year); var location = new ReportController().GetCityName(filter.SessionDepartment); lblInformationFooter.Text = string.Format(lblInformationFooter.Text, location, DateTime.Now.Day, DateTime.Now.Month, DateTime.Now.Year); // get organization var organization = cat_DepartmentServices.GetByDepartments(filter.SessionDepartment); if (organization == null) { return; } var departments = filter.SelectedDepartment; var arrDepartment = departments.Split(new[] { ',' }, StringSplitOptions.None); for (var i = 0; i < arrDepartment.Length; i++) { arrDepartment[i] = "'{0}'".FormatWith(arrDepartment[i]); } var table = SQLHelper.ExecuteTable( SQLManagementAdapter.GetStore_ListEmployeeHavePersonalTaxCode(string.Join(",", arrDepartment), filter.WhereClause)); DataSource = table; //binding data GroupHeader1.GroupFields.AddRange(new[] { new GroupField("DepartmentId", XRColumnSortOrder.Ascending) }); xrTableCellDepartment.DataBindings.Add("Text", DataSource, "DepartmentName"); xrTableCellEmployeeCode.DataBindings.Add("Text", DataSource, "EmployeeCode"); xrTableCellFullName.DataBindings.Add("Text", DataSource, "FullName"); xrTableCellGender.DataBindings.Add("Text", DataSource, "Gender"); xrTableCellBirthDate.DataBindings.Add("Text", DataSource, "BirthDate", "{0:dd/MM/yyyy}"); xrTableCellPositionName.DataBindings.Add("Text", DataSource, "PositionName"); xrTableCellPersonalTax.DataBindings.Add("Text", DataSource, "PersonalTaxCode"); } catch { } }