public void CreateReport()
{
try
{
ReportViewer rvReport = new ReportViewer();
#region Assign DataSet and Report Data Sourse Details
DataSet DS;
clsReports oReport = new clsReports();
DS = oReport.Get_ProgrameValidity_Report(hidUniID.Value, ddlExamEvent.SelectedValue);
if (DS.Tables.Count != 0)
{
DataTable dtExport = new DataTable();
dtExport = DS.Tables[0];
// dtExport = ((System.Data.DataTable)Session["ViewElg_dtData"]).Copy();
ReportDataSource ReportDetailsDS1 = new ReportDataSource("DataSet1", dtExport);
ReportParameter[] p = new ReportParameter[4];
p.SetValue(new ReportParameter("UniName", clsGetSettings.Name), 0);
p.SetValue(new ReportParameter("UniAdd", clsGetSettings.Address), 1);
p.SetValue(new ReportParameter("UserName", ((clsUser)Session["User"]).Name), 2);
p.SetValue(new ReportParameter("Logo", Classes.clsGetSettings.SitePath + @"Images/" + Classes.clsGetSettings.UniversityLogo), 3);
// ReportDataSource MultNomDS = new ReportDataSource("dsDisc_dtMultiNom", MultinomenClature());
#endregion
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.ReportPath = clsGetSettings.PhysicalSitePath + "Eligibility\\Rdlc\\rptStudentProgrameValidity.rdlc";
#region Adding DataSet and Report Data Sourse to ReportViewer DataSources
ReportViewer1.LocalReport.DataSources.Add(ReportDetailsDS1);
// ReportViewer1.LocalReport.DataSources.Add(MultNomDS);
ReportViewer1.LocalReport.SetParameters(p);
#endregion
ReportViewer1.LocalReport.EnableExternalImages = true;
ReportViewer1.LocalReport.Refresh();
}
string sDateTime = DateTime.Now.ToString("ddMMyyyyhhmmsstt");
Warning[] warnings;
string[] streamids;
string mimeType, encoding, filenameExtension;
byte[] bytes = ReportViewer1.LocalReport.Render("PDF", null, out mimeType, out encoding, out filenameExtension, out streamids, out warnings);
Response.Buffer = true;
Response.Clear();
Response.ContentType = mimeType;
Response.AddHeader("content-disposition", "attachment; filename=ProgrameValidityReport_" + sDateTime + ".pdf");
Response.BinaryWrite(bytes);
}
catch (Exception Ex)
{
Exception e = new Exception(Ex.Message, Ex);
}
}
public void CreateReport()
{
try
{
#region Assign DataSet and Report Data Sourse Details
DataTable dtExport = new DataTable();
dtExport = ((System.Data.DataTable)Session["dtData"]).Copy();
ReportDataSource ReportDetailsDS1 = new ReportDataSource("dsDistrictWise_dtDistrictWise", dtExport);
ReportParameter[] p = new ReportParameter[5];
p.SetValue(new ReportParameter("AcYr", hid_fk_AcademicYr_ID.Value), 0);
p.SetValue(new ReportParameter("UniName", clsGetSettings.Name), 1);
p.SetValue(new ReportParameter("UniAdd", clsGetSettings.Address), 2);
p.SetValue(new ReportParameter("UserName", ((clsUser)Session["User"]).Name), 3);
p.SetValue(new ReportParameter("Logo", Classes.clsGetSettings.SitePath + "Images/" + clsGetSettings.Logo, true
), 4);
ReportDataSource MultNomDS = new ReportDataSource("dsDisc_dtMultiNom", MultinomenClature());
#endregion
ReportViewer1.LocalReport.DataSources.Clear();
if (Classes.clsGetSettings.OpenUniversity.Equals("Yes"))
{
ReportViewer1.LocalReport.ReportPath = clsGetSettings.PhysicalSitePath + "Eligibility\\Rdlc\\DistrictWiseUplStudCount.rdlc";
}
else
{
ReportViewer1.LocalReport.ReportPath = clsGetSettings.PhysicalSitePath + "Eligibility\\Rdlc\\DistrictWiseUplStudCountWithOutRCcode.rdlc";
}
#region Adding DataSet and Report Data Sourse to ReportViewer DataSources
ReportViewer1.LocalReport.DataSources.Add(ReportDetailsDS1);
ReportViewer1.LocalReport.DataSources.Add(MultNomDS);
ReportViewer1.LocalReport.SetParameters(p);
#endregion
ReportViewer1.LocalReport.EnableExternalImages = true;
ReportViewer1.LocalReport.Refresh();
}
catch (Exception Ex)
{
Exception e = new Exception(Ex.Message, Ex);
}
}
public void CreateReport()
{
try
{
#region Assign DataSet and Report Data Sourse Details
DataTable dtExport = new DataTable();
dtExport = ((System.Data.DataTable)Session["dtCollWisePpExmRpt"]).Copy();
ReportDataSource ReportDetailsDS1 = new ReportDataSource("dsCollegewisePaperExemption_dtCollegewisePaperExemption", dtExport);
ReportParameter[] p = new ReportParameter[4];
p.SetValue(new ReportParameter("UniName", clsGetSettings.Name), 0);
p.SetValue(new ReportParameter("UniAdd", clsGetSettings.Address), 1);
p.SetValue(new ReportParameter("UserName", ((clsUser)Session["User"]).Name), 2);
p.SetValue(new ReportParameter("Logo", Classes.clsGetSettings.SitePath + @"/Images/" + Classes.clsGetSettings.UniversityLogo), 3);
ReportDataSource MultNomDS = new ReportDataSource("dsDisc_dtMultiNom", MultinomenClature());
#endregion
ReportViewer1.LocalReport.DataSources.Clear();
if (clsGetSettings.OpenUniversity.Equals("Yes"))
{
ReportViewer1.LocalReport.ReportPath = clsGetSettings.PhysicalSitePath + "Eligibility\\Rdlc\\CollwisePpExem.rdlc";
}
else
{
ReportViewer1.LocalReport.ReportPath = clsGetSettings.PhysicalSitePath + "Eligibility\\Rdlc\\CollwisePpExemWithOutRCcode.rdlc";
}
#region Adding DataSet and Report Data Sourse to ReportViewer DataSources
ReportViewer1.LocalReport.DataSources.Add(ReportDetailsDS1);
ReportViewer1.LocalReport.DataSources.Add(MultNomDS);
ReportViewer1.LocalReport.SetParameters(p);
#endregion
ReportViewer1.LocalReport.EnableExternalImages = true;
ReportViewer1.LocalReport.Refresh();
}
catch (Exception Ex)
{
Exception e = new Exception(Ex.Message, Ex);
}
}
protected void btnGenOrderAnnOrder_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
rptReport.Visible = true;
strRptPath = "ReportFile7";
rptReport.ServerReport.ReportPath = (string)ConfigurationManager.AppSettings["ReportPath"] + (string)ConfigurationManager.AppSettings[strRptPath];
ReportParameter[] p = new ReportParameter[2];
p.SetValue(new ReportParameter("Start_date", txtStartDate_AnnOrder.Text), 0);
p.SetValue(new ReportParameter("End_date", txtEndDate_AnnOrder.Text), 1);
rptReport.ServerReport.SetParameters(p);
rptReport.ServerReport.Refresh();
}
else
{
rptReport.Visible = false;
}
}
public void CreateReport()
{
try
{
#region Assign DataSet and Report Data Sourse Details
DataTable dtExport = new DataTable();
dtExport = ((System.Data.DataTable)Session["StudentDetailsWithPprChange"]).Copy();
ReportDataSource ReportDetailsDS1;
if (user.UserTypeCode == "2")
{
ReportDetailsDS1 = new ReportDataSource("dsViewElgStatus_dtStudentDetailsWithPPrChangeForCollege", dtExport);
}
else
{
ReportDetailsDS1 = new ReportDataSource("dsViewElgStatus_dtStudentDetailsWithPPrChange", dtExport);
}
ReportParameter[] p = new ReportParameter[7];
p.SetValue(new ReportParameter("UniName", clsGetSettings.Name), 0);
p.SetValue(new ReportParameter("UniAdd", clsGetSettings.Address), 1);
p.SetValue(new ReportParameter("UserName", ((clsUser)Session["User"]).Name), 2);
p.SetValue(new ReportParameter("Logo", Classes.clsGetSettings.SitePath + @"/Images/" + Classes.clsGetSettings.UniversityLogo), 3);
p.SetValue(new ReportParameter("SubHead", lblAcaYear.Text), 4);
bool b = string.IsNullOrEmpty(hidInstID.Value.Trim()) ? false : true;
p.SetValue(new ReportParameter("ColumnCollegeVisibility", b.ToString()), 5);
p.SetValue(new ReportParameter("Culture", CultureInfo.CurrentCulture.Name), 6);
ReportDataSource MultNomDS = new ReportDataSource("dsDisc_dtMultiNom", MultinomenClature());
#endregion
ReportViewer1.LocalReport.DataSources.Clear();
if (user.UserTypeCode == "2")
{
ReportViewer1.LocalReport.ReportPath = Server.MapPath(@"~\Eligibility\Rdlc\rptStudentDetailwithPaperChangeForCollege.rdlc");
}
else
{
ReportViewer1.LocalReport.ReportPath = Server.MapPath(@"~\Eligibility\Rdlc\rptStudentDetailwithPaperChange.rdlc");
}
#region Adding DataSet and Report Data Sourse to ReportViewer DataSources
ReportViewer1.LocalReport.DataSources.Add(ReportDetailsDS1);
ReportViewer1.LocalReport.DataSources.Add(MultNomDS);
ReportViewer1.LocalReport.SetParameters(p);
#endregion
ReportViewer1.LocalReport.EnableExternalImages = true;
ReportViewer1.LocalReport.Refresh();
}
catch (Exception Ex)
{
Exception e = new Exception(Ex.Message, Ex);
}
}
public void CreateReport()
{
try
{
#region Assign DataSet and Report Data Sourse Details
DataTable dtExport = new DataTable();
dtExport = ((System.Data.DataTable)Session["ViewElg_dtData"]).Copy();
ReportDataSource ReportDetailsDS1 = new ReportDataSource("dsViewElgStatus_dtViewElgStatus", dtExport);
ReportParameter[] p = new ReportParameter[5];
p.SetValue(new ReportParameter("SubHead", lblAcaYear.Text), 0);
p.SetValue(new ReportParameter("UniName", clsGetSettings.Name), 1);
p.SetValue(new ReportParameter("UniAdd", clsGetSettings.Address), 2);
p.SetValue(new ReportParameter("UserName", ((clsUser)Session["User"]).Name), 3);
p.SetValue(new ReportParameter("Logo", Classes.clsGetSettings.SitePath + @"Images/" + Classes.clsGetSettings.UniversityLogo
), 4);
ReportDataSource MultNomDS = new ReportDataSource("dsDisc_dtMultiNom", MultinomenClature());
#endregion
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.ReportPath = clsGetSettings.PhysicalSitePath + "Eligibility\\Rdlc\\ViewElgStatus.rdlc";
#region Adding DataSet and Report Data Sourse to ReportViewer DataSources
ReportViewer1.LocalReport.DataSources.Add(ReportDetailsDS1);
ReportViewer1.LocalReport.DataSources.Add(MultNomDS);
ReportViewer1.LocalReport.SetParameters(p);
#endregion
ReportViewer1.LocalReport.EnableExternalImages = true;
ReportViewer1.LocalReport.Refresh();
}
catch (Exception Ex)
{
Exception e = new Exception(Ex.Message, Ex);
}
}
public void CreateReport()
{
try
{
#region Assign DataSet and Report Data Source Details
DataTable dtExport = new DataTable();
dtExport = ((System.Data.DataTable)Session["DTStudent"]).Copy();
ReportDataSource ReportDetailsDS1 = new ReportDataSource("dsCollegewisePaperExemption__1_dtStudentList", dtExport);
ReportParameter[] p = new ReportParameter[5];
p.SetValue(new ReportParameter("UniName", clsGetSettings.Name), 0);
p.SetValue(new ReportParameter("UniAdd", clsGetSettings.Address), 1);
p.SetValue(new ReportParameter("UserName", ((clsUser)Session["User"]).Name), 2);
p.SetValue(new ReportParameter("Logo", Classes.clsGetSettings.SitePath + @"/Images/" + Classes.clsGetSettings.UniversityLogo), 3);
p.SetValue(new ReportParameter("Heading", hidCollCourseDetails.Value.ToString() + Ppname), 4);
ReportDataSource MultNomDS = new ReportDataSource("dsDisc_dtMultiNom", MultinomenClature());
#endregion
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.ReportPath = Server.MapPath(@"~\Eligibility\Rdlc\CollwisePpExemStud.rdlc");
#region Adding DataSet and Report Data Source to ReportViewer DataSources
ReportViewer1.LocalReport.DataSources.Add(ReportDetailsDS1);
ReportViewer1.LocalReport.DataSources.Add(MultNomDS);
ReportViewer1.LocalReport.SetParameters(p);
#endregion
ReportViewer1.LocalReport.EnableExternalImages = true;
ReportViewer1.LocalReport.Refresh();
}
catch (Exception Ex)
{
Exception e = new Exception(Ex.Message, Ex);
}
}
public void CreateReport()
{
try
{
#region Assign DataSet and Report Data Sourse Details
DataTable dtExport = new DataTable();
dtExport = (DataTable)GVStudent.DataSource;
ReportDataSource ReportDetailsDS1 = new ReportDataSource("dsDiscStudents_dtDiscStudents", dtExport);
ReportParameter[] p = new ReportParameter[5];
p.SetValue(new ReportParameter("SubHead", lblTitle.Text), 0);
p.SetValue(new ReportParameter("UserName", ((clsUser)Session["User"]).Name), 1);
p.SetValue(new ReportParameter("UniName", clsGetSettings.Name), 2);
p.SetValue(new ReportParameter("UniAdd", clsGetSettings.Address), 3);
p.SetValue(new ReportParameter("Logo", Classes.clsGetSettings.SitePath + @"/Images/" + Classes.clsGetSettings.UniversityLogo
), 4);
ReportDataSource MultNomDS = new ReportDataSource("dsDisc_dtMultiNom", MultinomenClature());
#endregion
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.ReportPath = Server.MapPath(@"~\Eligibility\Rdlc\DiscStudents.rdlc");
#region Adding DataSet and Report Data Source to ReportViewer DataSources
ReportViewer1.LocalReport.DataSources.Add(ReportDetailsDS1);
ReportViewer1.LocalReport.DataSources.Add(MultNomDS);
ReportViewer1.LocalReport.SetParameters(p);
#endregion
ReportViewer1.LocalReport.EnableExternalImages = true;
ReportViewer1.LocalReport.Refresh();
}
catch (Exception Ex)
{
Exception e = new Exception(Ex.Message, Ex);
}
}
protected void btnGenMonthDis_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
rptReport.Visible = true;
strRptPath = "ReportFile1";
rptReport.ServerReport.ReportPath = (string)ConfigurationManager.AppSettings["ReportPath"] + (string)ConfigurationManager.AppSettings[strRptPath];
ReportParameter[] p = new ReportParameter[1];
p.SetValue(new ReportParameter("ReportMonth", ddlMonth.SelectedItem.ToString() + " " + ddlYear.SelectedValue), 0);
rptReport.ServerReport.SetParameters(p);
rptReport.ServerReport.Refresh();
}
else
{
rptReport.Visible = false;
}
}
public void CreateReport()
{
try
{
#region Assign DataSet and Report Data Sourse Details
DataTable dtExport = new DataTable();
dtExport = ((System.Data.DataTable)Session["DdtData"]).Copy();
ReportDataSource ReportDetailsDS1 = new ReportDataSource("dsDisc_dtDisc", dtExport);
ReportParameter[] p = new ReportParameter[8];
string term1, term2 = string.Empty;
string[] terms = YCMOU.hidCrPrChIds.Value.Split(',');
if (int.Parse(terms[0]) > int.Parse(terms[1]))
{
term1 = YCMOU.hidCrPrChNames.Value.Split(',')[1];
term2 = YCMOU.hidCrPrChNames.Value.Split(',')[0];
}
else
{
term1 = YCMOU.hidCrPrChNames.Value.Split(',')[0];
term2 = YCMOU.hidCrPrChNames.Value.Split(',')[1];
}
p.SetValue(new ReportParameter("Term1", term1), 0);
p.SetValue(new ReportParameter("Term2", term2), 1);
p.SetValue(new ReportParameter("SubHead", ((DropDownList)YCMOU.FindControl("ddlFaculty")).SelectedItem.Text + " - " + ((DropDownList)YCMOU.FindControl("ddlCourse")).SelectedItem.Text + " - " + ((DropDownList)YCMOU.FindControl("ddlBranch")).SelectedItem.Text + " - " + ((DropDownList)YCMOU.FindControl("ddlPart")).SelectedItem.Text + " [Academic Year " + ((DropDownList)YCMOU.FindControl("ddlAcadYear")).SelectedItem.Text + "]"), 2);
p.SetValue(new ReportParameter("UserName", ((clsUser)Session["User"]).Name), 3);
p.SetValue(new ReportParameter("UniName", clsGetSettings.Name), 4);
p.SetValue(new ReportParameter("UniAdd", clsGetSettings.Address), 5);
p.SetValue(new ReportParameter("Logo", Classes.clsGetSettings.SitePath + @"/Images/" + Classes.clsGetSettings.UniversityLogo
), 6);
string RegCentre = string.Empty;
bool isDisplayRCCodeInReport = false;
if (YCMOU.IsCollegeLogin.Equals(false))
{
if (YCMOU.IsRegionalCenterVisible.Equals(true))
{
isDisplayRCCodeInReport = true;
if (((DropDownList)YCMOU.FindControl("ddlRegionalCenter")).SelectedIndex != 0)
{
RegCentre = " for " + ((DropDownList)YCMOU.FindControl("ddlRegionalCenter")).SelectedItem.Text;
}
else
{
RegCentre = " for all Regional Centres";
}
}
}
else
{
RegCentre = " for " + user.Name;
}
p.SetValue(new ReportParameter("RegCentre", RegCentre), 7);
ReportDataSource MultNomDS = new ReportDataSource("dsDisc_dtMultiNom", MultinomenClature());
#endregion
ReportViewer1.LocalReport.DataSources.Clear();
if (isDisplayRCCodeInReport)
{
ReportViewer1.LocalReport.ReportPath = clsGetSettings.PhysicalSitePath + "Eligibility\\Rdlc\\CrPrTermWiseDisc.rdlc";
}
else
{
ReportViewer1.LocalReport.ReportPath = clsGetSettings.PhysicalSitePath + "Eligibility\\Rdlc\\CrPrTermWiseDiscWithOutRCcode.rdlc";
}
#region Adding DataSet and Report Data Source to ReportViewer DataSources
ReportViewer1.LocalReport.DataSources.Add(ReportDetailsDS1);
ReportViewer1.LocalReport.DataSources.Add(MultNomDS);
ReportViewer1.LocalReport.SetParameters(p);
#endregion
ReportViewer1.LocalReport.EnableExternalImages = true;
ReportViewer1.LocalReport.Refresh();
}
catch (Exception Ex)
{
Exception e = new Exception(Ex.Message, Ex);
}
}
public void CreateReport()
{
try
{
#region Assign DataSet and Report Data Sourse Details
DataTable dtExport = new DataTable();
dtExport = ((System.Data.DataTable)Session["MISdtData"]).Copy();
ReportDataSource ReportDetailsDS1 = new ReportDataSource("dsMIS_dtMIS", dtExport);
ReportParameter[] p = new ReportParameter[6];
if (Request.QueryString["LandingPgStats"] != null)
{
p.SetValue(new ReportParameter("AcYr", Request.QueryString["LandingPgStats"].ToString().Split('|')[1].ToString()), 0);
}
else
{
p.SetValue(new ReportParameter("AcYr", hid_AcademicYear.Value), 0);
}
p.SetValue(new ReportParameter("UniName", clsGetSettings.Name), 1);
p.SetValue(new ReportParameter("UniAdd", clsGetSettings.Address), 2);
p.SetValue(new ReportParameter("UserName", ((clsUser)Session["User"]).Name), 3);
p.SetValue(new ReportParameter("Logo", Classes.clsGetSettings.SitePath + "Images/" + clsGetSettings.Logo, true
), 4);
string RegCentre = string.Empty;
bool isDisplayRCCodeInReport = false;
if (YCMOU.IsRegionalCenterVisible.Equals(true))
{
isDisplayRCCodeInReport = true;
if (((DropDownList)YCMOU.FindControl("ddlRegionalCenter")).SelectedIndex != 0)
{
RegCentre = " for " + ((DropDownList)YCMOU.FindControl("ddlRegionalCenter")).SelectedItem.Text;
}
else
{
RegCentre = " for all Regional Centres";
}
}
p.SetValue(new ReportParameter("RegCentre", RegCentre), 5);
ReportDataSource MultNomDS = new ReportDataSource("dsDisc_dtMultiNom", MultinomenClature());
#endregion
ReportViewer1.LocalReport.DataSources.Clear();
if (isDisplayRCCodeInReport)
{
ReportViewer1.LocalReport.ReportPath = clsGetSettings.PhysicalSitePath + "Eligibility\\Rdlc\\MIS.rdlc";
}
else
{
ReportViewer1.LocalReport.ReportPath = clsGetSettings.PhysicalSitePath + "Eligibility\\Rdlc\\MISWithOutRCcode.rdlc";
}
#region Adding DataSet and Report Data Sourse to ReportViewer DataSources
ReportViewer1.LocalReport.DataSources.Add(ReportDetailsDS1);
ReportViewer1.LocalReport.DataSources.Add(MultNomDS);
ReportViewer1.LocalReport.SetParameters(p);
#endregion
ReportViewer1.LocalReport.EnableExternalImages = true;
ReportViewer1.LocalReport.Refresh();
}
catch (Exception Ex)
{
Exception e = new Exception(Ex.Message, Ex);
}
}
public void CreateReport()
{
try
{
MemorizeInSession();
#region Assign DataSet and Report Data Sourse Details
if (user.UserTypeCode != "2")
{
hidInstID.Value = string.Empty;
hidCollName.Value = string.Empty;
}
if (!string.IsNullOrEmpty(txtFrom.Text))
{
hidFromDate.Value = txtFrom.Text;
hidToDate.Value = txtTo.Text;
}
if (hidInstID.Value.Equals(string.Empty))
{
if (ddlCollegeName.SelectedIndex != 0 || Collcode.Text != string.Empty)
{
hidInstID.Value = ddlCollegeName.SelectedValue.Split('|')[0];
hidCollName.Value = ddlCollegeName.SelectedItem.Text;
}
}
DataSet DS;
DS = clsEligibilityDBAccess.GenerateRegistrationReceiptStudentsList(hidUniID.Value, hidInstID.Value, hidFacID.Value, hidCrID.Value, hidMoLrnID.Value, hidPtrnID.Value, Convert.ToString(Session["ElgBranchID"]), Convert.ToString(Session["Elgpk_CrPr_Details_ID"]), Convert.ToString(Session["Elgpk_CrPrCh_ID"]), hid_fk_AcademicYr_ID.Value, hidSortOption.Value, hidCriteria.Value, hidCriteriaNull.Value, hidCriteriaEligibilityRequired.Value, hidFromDate.Value, hidToDate.Value);
if (DS != null && DS.Tables.Count > 0 && DS.Tables[0] != null && DS.Tables[0].Rows.Count > 0)
{
ReportDataSource ReportDetailsDS1 = new ReportDataSource("DataSet1", DS.Tables[0]);
ReportParameter[] p = new ReportParameter[1];
p.SetValue(new ReportParameter("Logo", Classes.clsGetSettings.SitePath + @"Images/" + Classes.clsGetSettings.UniversityLogo), 0);
ReportDataSource MultNomDS = new ReportDataSource("dsDisc_dtMultiNom", MultinomenClature());
#endregion
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.ReportPath = clsGetSettings.PhysicalSitePath + "Eligibility\\Rdlc\\GenerateRegistrationReceipt.rdlc";
#region Adding DataSet and Report Data Sourse to ReportViewer DataSources
ReportViewer1.LocalReport.DataSources.Add(ReportDetailsDS1);
ReportViewer1.LocalReport.DataSources.Add(MultNomDS);
ReportViewer1.LocalReport.SetParameters(p);
#endregion
ReportViewer1.LocalReport.EnableExternalImages = true;
ReportViewer1.LocalReport.Refresh();
}
else
{
lblnorecordfound.Visible = true;
lblnorecordfound.Text = "No Record found";
}
}
catch (Exception Ex)
{
Exception e = new Exception(Ex.Message, Ex);
}
}
public void CreateReport()
{
try
{
#region Assign DataSet and Report Data Sourse Details
DataTable dtExport = new DataTable();
dtExport = ((System.Data.DataTable)Session["CoursewisedtData"]).Copy();
ReportDataSource ReportDetailsDS1 = new ReportDataSource("dsCoursewisePaperExemption_dtCoursewisePaperExemption", dtExport);
ReportParameter[] p = new ReportParameter[4];
//if (Request.QueryString["LandingPgStats"] != null)
//{
// p.SetValue(new ReportParameter("AcYr", Request.QueryString["LandingPgStats"].ToString().Split('|')[1].ToString()), 0);
//}
//else
//{
// p.SetValue(new ReportParameter("AcYr", hid_AcademicYear.Value), 0);
//}
p.SetValue(new ReportParameter("UniName", clsGetSettings.Name), 0);
p.SetValue(new ReportParameter("UniAdd", clsGetSettings.Address), 1);
p.SetValue(new ReportParameter("UserName", ((clsUser)Session["User"]).Name), 2);
p.SetValue(new ReportParameter("Logo", Classes.clsGetSettings.SitePath + @"/Images/" + Classes.clsGetSettings.UniversityLogo
), 3);
//string RegCentre = string.Empty;
//if (YCMOU.IsRegionalCenterVisible.Equals(true))
//{
// if (((DropDownList)YCMOU.FindControl("ddlRegionalCenter")).SelectedIndex != 0)
// {
// RegCentre = " for " + ((DropDownList)YCMOU.FindControl("ddlRegionalCenter")).SelectedItem.Text;
// }
// else
// {
// RegCentre = " for all Regional Centres";
// }
//}
//p.SetValue(new ReportParameter("RegCentre", RegCentre), 5);
ReportDataSource MultNomDS = new ReportDataSource("dsDisc_dtMultiNom", MultinomenClature());
#endregion
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.ReportPath = clsGetSettings.PhysicalSitePath + "Eligibility\\Rdlc\\CoursewisePaperExemption.rdlc";
#region Adding DataSet and Report Data Sourse to ReportViewer DataSources
ReportViewer1.LocalReport.DataSources.Add(ReportDetailsDS1);
ReportViewer1.LocalReport.DataSources.Add(MultNomDS);
ReportViewer1.LocalReport.SetParameters(p);
#endregion
ReportViewer1.LocalReport.EnableExternalImages = true;
ReportViewer1.LocalReport.Refresh();
}
catch (Exception Ex)
{
Exception e = new Exception(Ex.Message, Ex);
}
}