private void RenderPerformanceReport(DateTime startdt, DateTime endingdt) { try { ReportViewerDisplay.Reset(); SqlConnection con = HomeController.GetConnection(); con.Open(); string sqlQuery = "sp_EDW_User_Reports"; System.Data.DataTable dt = new System.Data.DataTable(); SqlDataAdapter da = new SqlDataAdapter(sqlQuery, con); da.SelectCommand.CommandType = CommandType.StoredProcedure; da.SelectCommand.Parameters.AddWithValue("@StartDate", startdt); da.SelectCommand.Parameters.AddWithValue("@EndDate", endingdt); da.Fill(dt); ReportViewerDisplay.LocalReport.DataSources.Clear(); Microsoft.Reporting.WebForms.ReportDataSource rpdc = new Microsoft.Reporting.WebForms.ReportDataSource("DataSetEDWReporting", dt); ReportViewerDisplay.LocalReport.DataSources.Add(rpdc); ReportViewerDisplay.LocalReport.EnableExternalImages = true; ReportViewerDisplay.LocalReport.ReportPath = Server.MapPath("~/Reports/ReportEdwWorkersProductivity.rdlc"); ReportViewerDisplay.LocalReport.Refresh(); } catch (Exception) { } }
private void RenderEdWEntryReport(Dictionary <string, string> dictRes) { try { ReportViewerDisplay.Reset(); string sqlQuery = "sp_EDW_Reports_TEST"; SqlConnection con = HomeController.GetConnection(); con.Open(); System.Data.DataTable dt = new System.Data.DataTable(); SqlDataAdapter da = new SqlDataAdapter(sqlQuery, con); da.SelectCommand.CommandType = CommandType.StoredProcedure; //ADD PARAMETERS FOR LISTING REPORT DateTime defaultStartDateTime = dictRes.ContainsKey("dates") ? DateTime.ParseExact(dictRes["dates"].Split(',')[0], "yyyy-MM-dd", null) : DateTime.Now.AddYears(-1); DateTime defaultEndDateTime = dictRes.ContainsKey("dates") ? DateTime.ParseExact(dictRes["dates"].Split(',')[1], "yyyy-MM-dd", null) : DateTime.Now; da.SelectCommand.Parameters.AddWithValue("@cnstncy_nbr", dictRes["const"]); da.SelectCommand.Parameters.AddWithValue("@app_type", dictRes["appType"]); da.SelectCommand.Parameters.AddWithValue("@worker_type", dictRes["workerType"]); da.SelectCommand.Parameters.AddWithValue("@status", dictRes["status"]); da.SelectCommand.Parameters.AddWithValue("@StartDate", defaultStartDateTime); da.SelectCommand.Parameters.AddWithValue("@EndDate", defaultEndDateTime); da.Fill(dt); ReportViewerDisplay.LocalReport.DataSources.Clear(); Microsoft.Reporting.WebForms.ReportDataSource rpdc = new Microsoft.Reporting.WebForms.ReportDataSource("DataSet1", dt); ReportViewerDisplay.LocalReport.DataSources.Add(rpdc); ReportViewerDisplay.LocalReport.EnableExternalImages = true; ReportViewerDisplay.LocalReport.ReportPath = Server.MapPath("~/Reports/ReportEdwListing.rdlc"); //ReportViewerDisplay.LocalReport.SetParameters(new Microsoft.Reporting.WebForms.ReportParameter("Dates", new string[] { defaultStartDateTime.ToString(), defaultEndDateTime.ToString() }, true)); ReportParameter stDate = new ReportParameter("stDate", defaultStartDateTime.ToString()); ReportParameter eDate = new ReportParameter("eDate", defaultEndDateTime.ToString()); ReportViewerDisplay.LocalReport.SetParameters(new ReportParameter[] { stDate, eDate }); ReportViewerDisplay.LocalReport.Refresh(); } catch (Exception) { } }