public function pageRender()
{
//Log("Page Render");
if (isset($_GET['x_PLAN_FY']))
$_SESSION['fy_ctb'] = $_GET['x_PLAN_FY'];
else
$_SESSION['fy_ctb'] = NULL;
$fy_start = substr($_SESSION['fy_ctb'], 2, 2);
$fy_end = substr($_SESSION['fy_ctb'], -2);
for($i = 1; $i <= $this->ColumnCount; $i++) {
$Column = $this->Columns[$i];
if ($Column->Caption != "") {
if ($Column->Caption == "1")
$Column->Caption = "Apr-".$fy_start;
else if ($Column->Caption == "2")
$Column->Caption = "May-".$fy_start;
else if ($Column->Caption == "3")
$Column->Caption = "Jun-".$fy_start;
else if ($Column->Caption == "4")
$Column->Caption = "Jul-".$fy_start;
else if ($Column->Caption == "5")
$Column->Caption = "Aug-".$fy_start;
else if ($Column->Caption == "6")
$Column->Caption = "Sep-".$fy_start;
else if ($Column->Caption == "7")
$Column->Caption = "Oct-".$fy_start;
else if ($Column->Caption == "8")
$Column->Caption = "Nov-".$fy_start;
else if ($Column->Caption == "9")
$Column->Caption = "Dec-".$fy_start;
else if ($Column->Caption == "10")
$Column->Caption = "Jan-".$fy_end;
else if ($Column->Caption == "11")
$Column->Caption = "Feb-".$fy_end;
else if ($Column->Caption == "12")
$Column->Caption = "Mar-".$fy_end;
else {}
}
}
}
Above code is working fine in view page but exporting in excel value is showing only month (like Apr, Mar…etc) financial year value is not exporting. Please give solution.