Geeks With Blogs!

using System;
 using System.Collections;
 using System.Configuration;
 using System.Data;
 using System.Linq;
 using System.Web;
 using System.Web.Security;
 using System.Web.UI;
 using System.Web.UI.HtmlControls;
 using System.Web.UI.WebControls;
 using System.Web.UI.WebControls.WebParts;
 using System.Xml.Linq;
 using Microsoft.Reporting.WebForms;
 using Rpt = SchoolDistrict.Registration.Reports;
 public partial class Reports_RegistrationReport : System.Web.UI.Page
 {
     protected void Page_Load(object sender, EventArgs e)
     {
         //Workaround to allow the horizontal scroll bar to show.
         //http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2803199&SiteID=1
         ReportViewer1.Style.Add("margin-bottom", "26px");
     }
     /// 
     /// Event handler for the btnGenerateReport_Click event     /// 

     /// 

     /// 

     protected void btnGenerateReport_Click(object sender, EventArgs e)
     {
         SetSchoolAndClassSessionKeys();
         this.ReportViewer1.LocalReport.SubreportProcessing += new SubreportProcessingEventHandler(LocalReport_SubreportProcessing);
         ReportViewer1.LocalReport.Refresh();
     }
 void LocalReport_SubreportProcessing(object sender, SubreportProcessingEventArgs e) 
{
     int schoolID;
     string schoolName;
     int classID;
     string className;
     //Converts SessionKeys to appropriate values to pass to methods     GetSchoolAndClassSessionKeys(out schoolID, out schoolName, out classID, out className);
     //Determines which SubReport is being processed
     int reportPath = GetSubReportPathCase(e);
     switch (reportPath)
     {
         case 1:
             e.DataSources.Add(new ReportDataSource("Registration", new Rpt.ReportManager().GetRegistrationRecordPctBySchool(                 schoolID, schoolName, classID, className)));
             break;
         case 2:
             e.DataSources.Add(new ReportDataSource("Registration", new Rpt.ReportManager().GetRegistrationRecordPctBySchoolDistrict(                 schoolID, schoolName, classID, className)));
             break;
         case 3:
             e.DataSources.Add(new ReportDataSource("Registration", new Rpt.ReportManager().GetRegistrationRecordComments(                 schoolID, schoolName, classID, className)));
             break;
         default:
             break;
     }
     ////Guru's code
     //e.DataSources.Add(new ReportDataSource("Registration", new Rpt.ReportManager().GetRegistrationRecord(
     //    int.Parse(Session["SchoolNameKey"].ToString()),
     //    Session["SchoolName"] as string, int.Parse(Session["ClassNameKey"].ToString()),
     //    Session["ClassName"] as string)));
      //throw new NotImplementedException();
     //ReportViewer1.LocalReport.Render("PDF",
 }

 /// <summary>
 /// Determines which SubReport is being processed
 /// </summary>
 /// <param name="e"></param>
 /// <returns></returns>
 private static int GetSubReportPathCase(SubreportProcessingEventArgs e)
 {
     //Determines which SubReport is being processed
     int reportPath = 0;
     if (e.ReportPath == "PctBySchool")
     {
         reportPath = 1;
     }
     else if (e.ReportPath == "PctBySchoolDistrict")
     {
         reportPath = 2;
     }
     else if (e.ReportPath == "Comments")
     {
         reportPath = 3;
     }
     else
     {
     }
     return reportPath;
 }

 /// <summary>
 /// Converts SessionKeys to appropriate values to pass to methods
 /// </summary>
 /// <param name="schoolID">passed in as 0</param>
 /// <param name="schoolName">passed in as empty string</param>
 /// <param name="classID">passed in as 0</param>
 /// <param name="className">passed in as empty string</param>
 private void GetSchoolAndClassSessionKeys(out int schoolID, out string schoolName, out int classID, out string className)
 {
     //Converts SessionKeys to appropriate values to pass to methods
     int badValue;
     if (int.TryParse(Session["SchoolNameKey"].ToString(), out badValue))
     {
         schoolID = int.Parse(Session["SchoolNameKey"].ToString());
     }
     else
     {
         schoolID = 0;
     }
     schoolName = Session["SchoolName"].ToString();
     if (int.TryParse(Session["ClassNameKey"].ToString(), out badValue))
     {
         classID = int.Parse(Session["ClassNameKey"].ToString());
     }
     else
     {
         classID = 0;
     }
     className = Session["ClassName"].ToString();
 }

 /// <summary>
 /// Method to Set or Reset the Session Keys for the School/Class based on the values in two
 /// Ajax Cascading Drop-Down Lists.
 /// </summary>
 private void SetSchoolAndClassSessionKeys()
 {
     if (!((string.IsNullOrEmpty(ddlSchoolName.SelectedValue)) || (string.IsNullOrEmpty(ddlClassName.SelectedValue))))
     {
         Session[ReportKeys.SchoolNameID] = ddlSchoolName.SelectedValue;
         Session[ReportKeys.SchoolName] = ddlSchoolName.SelectedItem.ToString();
         Session[ReportKeys.ClassNameID] = ddlClassName.SelectedValue;
         Session[ReportKeys.ClassName] = ddlClassName.SelectedItem.ToString();
     }
     else
     {
         Session[ReportKeys.SchoolNameID] = string.Empty;
         Session[ReportKeys.SchoolName] = string.Empty;
         Session[ReportKeys.ClassNameID] = string.Empty;
         Session[ReportKeys.ClassName] = string.Empty;

         //ReportViewer1.LocalReport.Refresh();
     }
 }

 /// <summary>
 /// Event Handler for the ReportViewer1 Refresh Button
 /// </summary>
 /// <param name="sender"></param>
 /// <param name="e"></param>
 protected void ReportViewer1_ReportRefresh(object sender, System.ComponentModel.CancelEventArgs e)
 {
     btnGenerateReport_Click(sender, e);
 }
}

And Voila!  Problem Solved!

Posted On Friday, October 9, 2009 12:46 AM