private void DisplayRevenueExpenseSummaryReport()
        {
            ProjectionPercentages percentages = new ProjectionPercentages();

            percentages = (ProjectionPercentages)ViewState["percentages"];

            if (percentages == null)
            {
               percentages = CalculatePercentage();
            }

            String fiscalYear = (String)Session["MostRecentFY"];

            String year = fiscalYear.GetLast(4);

            String fiscalYear1 = "FY" + (int.Parse(year) + 1);
            String fiscalYear2 = "FY" + (int.Parse(year) + 2);
            String fiscalYear3 = "FY" + (int.Parse(year) + 3);
            String fiscalYear4 = "FY" + (int.Parse(year) + 4);

            StoredProcedures sp = new StoredProcedures();

            DataTable tbl = sp.DisplayProjections(fiscalYear);

            ProjectionsLabel.Text = "Projections " + fiscalYear;

            tbl.Columns.Add("Year1", typeof(System.Double));
            tbl.Columns.Add("Year2", typeof(System.Double));
            tbl.Columns.Add("Year3", typeof(System.Double));
            tbl.Columns.Add("Year4", typeof(System.Double));
            tbl.Columns.Add("Percentage", typeof(System.Double));

            tbl.Rows[0]["Year1"] = (Double.Parse(tbl.Rows[0][1].ToString()) * percentages.grossCHG) + Double.Parse(tbl.Rows[0][1].ToString());
            tbl.Rows[0]["Year2"] = (Double.Parse(tbl.Rows[0][3].ToString()) * percentages.grossCHG) + Double.Parse(tbl.Rows[0][3].ToString());
            tbl.Rows[0]["Year3"] = (Double.Parse(tbl.Rows[0][4].ToString()) * percentages.grossCHG) + Double.Parse(tbl.Rows[0][4].ToString());
            tbl.Rows[0]["Year4"] = (Double.Parse(tbl.Rows[0][5].ToString()) * percentages.grossCHG) + Double.Parse(tbl.Rows[0][5].ToString());
            tbl.Rows[0]["Percentage"] = percentages.grossCHG;

            tbl.Rows[1]["Year1"] = (Double.Parse(tbl.Rows[1][1].ToString()) * percentages.exportedCHG) + Double.Parse(tbl.Rows[1][1].ToString());
            tbl.Rows[1]["Year2"] = (Double.Parse(tbl.Rows[1][3].ToString()) * percentages.exportedCHG) + Double.Parse(tbl.Rows[1][3].ToString());
            tbl.Rows[1]["Year3"] = (Double.Parse(tbl.Rows[1][4].ToString()) * percentages.exportedCHG) + Double.Parse(tbl.Rows[1][4].ToString());
            tbl.Rows[1]["Year4"] = (Double.Parse(tbl.Rows[1][5].ToString()) * percentages.exportedCHG) + Double.Parse(tbl.Rows[1][5].ToString());
            tbl.Rows[1]["Percentage"] = percentages.exportedCHG;

            tbl.Rows[2]["Year1"] = (Double.Parse(tbl.Rows[2][1].ToString()) * percentages.netCHG) + Double.Parse(tbl.Rows[2][1].ToString());
            tbl.Rows[2]["Year2"] = (Double.Parse(tbl.Rows[2][3].ToString()) * percentages.netCHG) + Double.Parse(tbl.Rows[2][3].ToString());
            tbl.Rows[2]["Year3"] = (Double.Parse(tbl.Rows[2][4].ToString()) * percentages.netCHG) + Double.Parse(tbl.Rows[2][4].ToString());
            tbl.Rows[2]["Year4"] = (Double.Parse(tbl.Rows[2][5].ToString()) * percentages.netCHG) + Double.Parse(tbl.Rows[2][5].ToString());
            tbl.Rows[2]["Percentage"] = percentages.netCHG;

            tbl.Rows[3]["Year1"] = (Double.Parse(tbl.Rows[3][1].ToString()) * percentages.grossRevenue) + Double.Parse(tbl.Rows[3][1].ToString());
            tbl.Rows[3]["Year2"] = (Double.Parse(tbl.Rows[3][3].ToString()) * percentages.grossRevenue) + Double.Parse(tbl.Rows[3][3].ToString());
            tbl.Rows[3]["Year3"] = (Double.Parse(tbl.Rows[3][4].ToString()) * percentages.grossRevenue) + Double.Parse(tbl.Rows[3][4].ToString());
            tbl.Rows[3]["Year4"] = (Double.Parse(tbl.Rows[3][5].ToString()) * percentages.grossRevenue) + Double.Parse(tbl.Rows[3][5].ToString());
            tbl.Rows[3]["Percentage"] = percentages.grossRevenue;

            tbl.Rows[4]["Year1"] = (Double.Parse(tbl.Rows[4][1].ToString()) * percentages.exportedRevenue) + Double.Parse(tbl.Rows[4][1].ToString());
            tbl.Rows[4]["Year2"] = (Double.Parse(tbl.Rows[4][3].ToString()) * percentages.exportedRevenue) + Double.Parse(tbl.Rows[4][3].ToString());
            tbl.Rows[4]["Year3"] = (Double.Parse(tbl.Rows[4][4].ToString()) * percentages.exportedRevenue) + Double.Parse(tbl.Rows[4][4].ToString());
            tbl.Rows[4]["Year4"] = (Double.Parse(tbl.Rows[4][5].ToString()) * percentages.exportedRevenue) + Double.Parse(tbl.Rows[4][5].ToString());
            tbl.Rows[4]["Percentage"] = percentages.exportedRevenue;

            tbl.Rows[5]["Year1"] = (Double.Parse(tbl.Rows[5][1].ToString()) * percentages.netRevenue) + Double.Parse(tbl.Rows[5][1].ToString());
            tbl.Rows[5]["Year2"] = (Double.Parse(tbl.Rows[5][3].ToString()) * percentages.netRevenue) + Double.Parse(tbl.Rows[5][3].ToString());
            tbl.Rows[5]["Year3"] = (Double.Parse(tbl.Rows[5][4].ToString()) * percentages.netRevenue) + Double.Parse(tbl.Rows[5][4].ToString());
            tbl.Rows[5]["Year4"] = (Double.Parse(tbl.Rows[5][5].ToString()) * percentages.netRevenue) + Double.Parse(tbl.Rows[5][5].ToString());
            tbl.Rows[5]["Percentage"] = percentages.netRevenue;

            int columnIndex = 0;

            DataRow row = tbl.Rows[6];

            foreach (DataColumn column in tbl.Columns)
            {
                if (int.Parse(year) == 2015 && columnIndex == 3)
                {
                    row[column] = 3712000;
                }
                else if (int.Parse(year) == 2015 && columnIndex == 4)
                {
                    row[column] = 4800000;
                }
                else if (int.Parse(year) > 2015 && columnIndex >= 3)
                {
                    row[column] = 4800000;
                }
                columnIndex++;
                    //tbl.Rows[6]["Year2"] = (Double.Parse(tbl.Rows[6][3].ToString()) * percentages.differentialRevenue) + Double.Parse(tbl.Rows[6][3].ToString());
                    //tbl.Rows[6]["Year3"] = (Double.Parse(tbl.Rows[6][4].ToString()) * percentages.differentialRevenue) + Double.Parse(tbl.Rows[6][4].ToString());
                    //tbl.Rows[6]["Year4"] = (Double.Parse(tbl.Rows[6][5].ToString()) * percentages.differentialRevenue) + Double.Parse(tbl.Rows[6][5].ToString());
                    //tbl.Rows[6]["Percentage"] = percentages.differentialRevenue;
              }

            tbl.Rows[7]["Year1"] = (Double.Parse(tbl.Rows[7][1].ToString()) * percentages.assessments) + Double.Parse(tbl.Rows[7][1].ToString());
            tbl.Rows[7]["Year2"] = (Double.Parse(tbl.Rows[7][3].ToString()) * percentages.assessments) + Double.Parse(tbl.Rows[7][3].ToString());
            tbl.Rows[7]["Year3"] = (Double.Parse(tbl.Rows[7][4].ToString()) * percentages.assessments) + Double.Parse(tbl.Rows[7][4].ToString());
            tbl.Rows[7]["Year4"] = (Double.Parse(tbl.Rows[7][5].ToString()) * percentages.assessments) + Double.Parse(tbl.Rows[7][5].ToString());
            tbl.Rows[7]["Percentage"] = percentages.assessments;

            tbl.Rows[8]["Year1"] = (Double.Parse(tbl.Rows[8][1].ToString()) * percentages.costDrivers) + Double.Parse(tbl.Rows[8][1].ToString());
            tbl.Rows[8]["Year2"] = (Double.Parse(tbl.Rows[8][3].ToString()) * percentages.costDrivers) + Double.Parse(tbl.Rows[8][3].ToString());
            tbl.Rows[8]["Year3"] = (Double.Parse(tbl.Rows[8][4].ToString()) * percentages.costDrivers) + Double.Parse(tbl.Rows[8][4].ToString());
            tbl.Rows[8]["Year4"] = (Double.Parse(tbl.Rows[8][5].ToString()) * percentages.costDrivers) + Double.Parse(tbl.Rows[8][5].ToString());
            tbl.Rows[8]["Percentage"] = percentages.costDrivers;

            tbl.Rows[9]["Year1"] = (Double.Parse(tbl.Rows[9][1].ToString()) * percentages.expendetures) + Double.Parse(tbl.Rows[9][1].ToString());
            tbl.Rows[9]["Year2"] = (Double.Parse(tbl.Rows[9][3].ToString()) * percentages.expendetures) + Double.Parse(tbl.Rows[9][3].ToString());
            tbl.Rows[9]["Year3"] = (Double.Parse(tbl.Rows[9][4].ToString()) * percentages.expendetures) + Double.Parse(tbl.Rows[9][4].ToString());
            tbl.Rows[9]["Year4"] = (Double.Parse(tbl.Rows[9][5].ToString()) * percentages.expendetures) + Double.Parse(tbl.Rows[9][5].ToString());
            tbl.Rows[9]["Percentage"] = percentages.expendetures;

            tbl.Rows[10]["Year1"] = (Double.Parse(tbl.Rows[10][1].ToString()) * percentages.surplus) + Double.Parse(tbl.Rows[10][1].ToString());
            tbl.Rows[10]["Year2"] = (Double.Parse(tbl.Rows[10][3].ToString()) * percentages.surplus) + Double.Parse(tbl.Rows[10][3].ToString());
            tbl.Rows[10]["Year3"] = (Double.Parse(tbl.Rows[10][4].ToString()) * percentages.surplus) + Double.Parse(tbl.Rows[10][4].ToString());
            tbl.Rows[10]["Year4"] = (Double.Parse(tbl.Rows[10][5].ToString()) * percentages.surplus) + Double.Parse(tbl.Rows[10][5].ToString());
            tbl.Rows[10]["Percentage"] = percentages.surplus;

            ProjectionsGridView.Columns[2].HeaderText = fiscalYear;
            ProjectionsGridView.Columns[3].HeaderText = fiscalYear1;
            ProjectionsGridView.Columns[4].HeaderText = fiscalYear2;
            ProjectionsGridView.Columns[5].HeaderText = fiscalYear3;
            ProjectionsGridView.Columns[6].HeaderText = fiscalYear4;

            ProjectionsPanel.Visible = true;

            ProjectionsGridView.DataSource = tbl;
            ProjectionsGridView.DataBind();
        }