protected void generateReport(Int32 group, DateTime start, DateTime end) { TimeZone localZone = TimeZone.CurrentTimeZone; end = end.AddDays(1); ReportDS.ReportSurveyAverageDataTable dt = BllProxyReport.GetSurveyAverageReport(localZone, group, start, end); ReportDataSource reportDataSource = new ReportDataSource("ReportSurveyDS", dt.DefaultView); this.repviewIncidentDetails.LocalReport.DataSources.Clear(); this.repviewIncidentDetails.LocalReport.DataSources.Add(reportDataSource); this.repviewIncidentDetails.LocalReport.Refresh(); pnlEmpty.Visible = false; pnlReportViewer.Visible = true; }
public static ReportDS.ReportSurveyAverageDataTable GetSurveyAverageReport(TimeZone localZone, Int32 group, DateTime start, DateTime end) { ReportDS.ReportSurveyAverageDataTable dt = DalReport.GetSurveyAverageReport(start, end); return(processData(dt, localZone, group)); }
private static ReportDS.ReportSurveyAverageDataTable processData(ReportDS.ReportSurveyAverageDataTable dt, TimeZone localZone, Int32 group) { foreach (ReportDS.ReportSurveyAverageRow row in dt.Rows) { row.agent_full_name = Helper.GetFullName(row.agent_first_name, row.agent_last_name); row.contact_full_name = Helper.GetFullName(row.contact_first_name, row.contact_last_name); if ((!row.Isdate_openNull()) && (!row.Isdate_closedNull())) { row.duration = Helper.GetDuration(row.date_open, row.date_closed); } else { row.duration = ""; } if (!row.Isdate_openNull()) { row.date = row.date_open.ToShortDateString(); //row.time = row.date_open.ToShortTimeString(); row.time = row.date_open.ToLocalTime().ToShortTimeString(); } //switch (group) //{ // case 1: // Agent // row.group_field = row.agent_full_name; // break; // case 2: // Group // row.group_field = row.group_name; // break; // case 3: // Facility // row.group_field = row.facility_name; // break; // case 4: // Contact // row.group_field = row.contact_full_name; // break; // case 5: // Status // row.group_field = row.incident_status_name; // break; // case 6: // Date // row.group_field = row.date; // break; //} switch (group) { case 1: // Agent row.group_field = row.agent_full_name; row.group_field_title = row.agent_full_name; break; case 2: // Group row.group_field = row.group_name; row.group_field_title = row.group_name; break; case 3: // Facility row.group_field = row.facility_name; row.group_field_title = row.facility_name; break; case 4: // Contact row.group_field = row.contact_full_name; row.group_field_title = row.contact_full_name; break; case 5: // Status row.group_field = row.incident_status_name; row.group_field_title = row.incident_status_name; break; case 6: // Date //row.group_field = row.date; row.group_field = row.Isdate_openNull() ? "" : row.date_open.ToString("yyyy: MM/dd"); row.group_field_title = row.date; break; } } return(dt); }