private void GuiUserReport_Load(object sender, EventArgs e) { UsersReport classesReport = new UsersReport(); DataTable dataTable = new DataTable(); dataTable = UserDAL.GetUsersReport(); classesReport.SetDataSource(dataTable); crystalReportViewer1.ReportSource = classesReport; }
private void FillReport(bool throwException = true) { string rep_params = vals.Text; ReportGenericRequest req = new ReportGenericRequest(); req.paramString = rep_params; ListResponse <Model.Reports.RT803> resp = _reportsService.ChildGetAll <Model.Reports.RT803>(req); if (!resp.Success) { Common.ReportErrorMessage(resp, GetGlobalResourceObject("Errors", "Error_1").ToString(), GetGlobalResourceObject("Errors", "ErrorLogId").ToString()); } Dictionary <string, string> parameters = Common.FetchReportParameters(texts.Text); UsersReport h = new UsersReport(parameters); List <XMLDictionary> userTypeList = Common.XMLDictionaryList(_systemService, "7"); resp.Items.ForEach(x => x.userTypeName = userTypeList.Where(y => y.key == x.userType).Count() != 0 ? userTypeList.Where(y => y.key == x.userType).First().value : ""); // resp.Items.ForEach(x => x.DateString = x.eventDT.ToString(_systemService.SessionHelper.GetDateformat(), new CultureInfo("en"))); SignInTrail h = new SignInTrail(); h.RightToLeft = _systemService.SessionHelper.CheckIfArabicSession() ? DevExpress.XtraReports.UI.RightToLeft.Yes : DevExpress.XtraReports.UI.RightToLeft.No; h.RightToLeftLayout = _systemService.SessionHelper.CheckIfArabicSession() ? DevExpress.XtraReports.UI.RightToLeftLayout.Yes : DevExpress.XtraReports.UI.RightToLeftLayout.No; h.DataSource = resp.Items; // string from = DateTime.Parse(req.Parameters["_fromDate"]).ToString(_systemService.SessionHelper.GetDateformat()); // string to = DateTime.Parse(req.Parameters["_toDate"]).ToString(_systemService.SessionHelper.GetDateformat()); string user = _systemService.SessionHelper.GetCurrentUser(); // h.Parameters["From"].Value = from; // h.Parameters["To"].Value = to; h.Parameters["User"].Value = user; // h.Parameters["Filters"].Value = texts.Text; //if (resp.Items.Count > 0) //{ // //if (req.Parameters["_userId"] != "0") // // h.Parameters["UserId"].Value = resp.Items[0].userName; // else // h.Parameters["UserId"].Value = GetGlobalResourceObject("Common", "All"); //} h.CreateDocument(); ASPxWebDocumentViewer1.OpenReport(h); ASPxWebDocumentViewer1.DataBind(); }