private void Frm_RuralPowerFeeRep_Load(object sender, EventArgs e)
        {
            string sql = "Select * From TEMP_RAREAPOWER ORDER BY RAreaNo";
            DataTable dt = SQLUtl.Query(sql).Tables["dataSet"];
            RuralPowerFeeRep ruralPowerFeeRep = new RuralPowerFeeRep();
            ruralPowerFeeRep.SetDataSource(dt);
            crystalReportViewer1.ReportSource = ruralPowerFeeRep;
            TextObject txtMonth = (TextObject)ruralPowerFeeRep.ReportDefinition.ReportObjects["txtMonth"];
            txtMonth.Text = month;
            TextObject txtPeople = (TextObject)ruralPowerFeeRep.ReportDefinition.ReportObjects["txtPeople"];
            txtPeople.Text = Constant.LoginUser.UserName;

            sql = "Select * From TEMP_RAREAPOWERSUM";
            dt = SQLUtl.Query(sql).Tables["dataSet"];

            TextObject txtOfferPowerY = (TextObject)ruralPowerFeeRep.ReportDefinition.ReportObjects["txtOfferPowerY"];
            txtOfferPowerY.Text = String.Format("{0:#,##0}", dt.Rows[0]["OfferPower"]);
            TextObject txtBackPower1Y = (TextObject)ruralPowerFeeRep.ReportDefinition.ReportObjects["txtBackPower1Y"];
            txtBackPower1Y.Text = String.Format("{0:#,##0}", dt.Rows[0]["BackPower1"]);
            TextObject txtBackPower2Y = (TextObject)ruralPowerFeeRep.ReportDefinition.ReportObjects["txtBackPower2Y"];
            txtBackPower2Y.Text = String.Format("{0:#,##0}", dt.Rows[0]["BackPower2"]);
            TextObject txtBackPower3Y = (TextObject)ruralPowerFeeRep.ReportDefinition.ReportObjects["txtBackPower3Y"];
            txtBackPower3Y.Text = String.Format("{0:#,##0}", dt.Rows[0]["BackPower3"]);
            TextObject txtBackPower4Y = (TextObject)ruralPowerFeeRep.ReportDefinition.ReportObjects["txtBackPower4Y"];
            txtBackPower4Y.Text = String.Format("{0:#,##0}", dt.Rows[0]["BackPower4"]);
            TextObject txtBackPower5Y = (TextObject)ruralPowerFeeRep.ReportDefinition.ReportObjects["txtBackPower5Y"];
            txtBackPower5Y.Text = String.Format("{0:#,##0}", dt.Rows[0]["BackPower5"]);
            TextObject txtBackPower6Y = (TextObject)ruralPowerFeeRep.ReportDefinition.ReportObjects["txtBackPower6Y"];
            txtBackPower6Y.Text = String.Format("{0:#,##0}", dt.Rows[0]["BackPower6"]);
            TextObject txtBackPower7Y = (TextObject)ruralPowerFeeRep.ReportDefinition.ReportObjects["txtBackPower7Y"];
            txtBackPower7Y.Text = String.Format("{0:#,##0}", dt.Rows[0]["BackPower7"]);
            TextObject txtBackPower8Y = (TextObject)ruralPowerFeeRep.ReportDefinition.ReportObjects["txtBackPower8Y"];
            txtBackPower8Y.Text = String.Format("{0:#,##0}", dt.Rows[0]["BackPower8"]);
            TextObject txtBackPower9Y = (TextObject)ruralPowerFeeRep.ReportDefinition.ReportObjects["txtBackPower9Y"];
            txtBackPower9Y.Text = String.Format("{0:#,##0}", dt.Rows[0]["BackPower9"]);
            TextObject txtBackPower10Y = (TextObject)ruralPowerFeeRep.ReportDefinition.ReportObjects["txtBackPower10Y"];
            txtBackPower10Y.Text = String.Format("{0:#,##0}", dt.Rows[0]["BackPower10"]);
            TextObject txtBackPower11Y = (TextObject)ruralPowerFeeRep.ReportDefinition.ReportObjects["txtBackPower11Y"];
            txtBackPower11Y.Text = String.Format("{0:#,##0}", dt.Rows[0]["BackPower11"]);
            TextObject txtBackPowerSumY = (TextObject)ruralPowerFeeRep.ReportDefinition.ReportObjects["txtBackPowerSumY"];
            txtBackPowerSumY.Text = String.Format("{0:#,##0}", dt.Rows[0]["SumBackPower"]);
            TextObject txtBackPercentY = (TextObject)ruralPowerFeeRep.ReportDefinition.ReportObjects["txtBackPercentY"];
            txtBackPercentY.Text = String.Format("{0:#,##0.00}", dt.Rows[0]["SumPercent"]);
        }
 public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
 {
     RuralPowerFeeRep rpt = new RuralPowerFeeRep();
     rpt.Site = this.Site;
     return rpt;
 }