private void ReportMembersAttendanceLoad() { DataSet ds = new DataSet(); DataTable dt = new DataTable("MembersAttendances"); dt.Columns.Add("member_id"); dt.Columns.Add("first_name"); dt.Columns.Add("last_name"); dt.Columns.Add("check_in_time"); ds.Tables.Add(dt); List <MemberAttendanceDTO> membersAttendance = AttendanceDAO.getMembersAttendanceInDateRange(dateFrom, dateTo); foreach (var memberAttendance in membersAttendance) { DataRow dr = ds.Tables[0].NewRow(); dr["member_id"] = memberAttendance.member_id; dr["first_name"] = memberAttendance.first_name; dr["last_name"] = memberAttendance.last_name; dr["check_in_time"] = memberAttendance.check_in_time.ToString("dd.MM.yyyy. hh:mm:ss"); ds.Tables[0].Rows.Add(dr); } rptMembersAttendance1.SetDataSource(ds); rptMembersAttendance1.SetParameterValue("pDateFrom", dateFrom.ToString("dd.MM.yyyy.")); rptMembersAttendance1.SetParameterValue("pDateTo", dateTo.ToString("dd.MM.yyyy.")); rptMembersAttendance1.SetParameterValue("pDatum", DateTime.Now.ToString("dd.MM.yyyy.")); crystalReportViewer.ReportSource = rptMembersAttendance1; crystalReportViewer.Refresh(); }