report export -> not listening to exportable

PHPMaker General Discussion (PHPMaker)
1

trying to exclude a few fields from a report export to excel using the reports page_load() event

func Page_Load() {
    $this->category->Exportable = false;
    $this->account_status->Exportable = false;
    $this->account_type->Exportable = false;
    $this->contact_id->Exportable = false;       
}

Doesn’t seem to exclude the fields… is this correct behavior in a report

2

You may try the Visible property and check if export is enabled before setting the property to FALSE.

3

thanks visible property worked…function Page_Load() {
if ($this->isExport()){
$this->category->Visible = false;
$this->account_status->Visible = false;
$this->account_type->Visible = false;
$this->contact_id->Visible = false;
}
}