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)
{
}
}
