Pivot table Report layout to Tabular

Feb 27, 2013 at 3:52 PM
Hi,

Using epplus how to set the Report layout of the Pivot table to Tabular. Currently it is showing in the drill down structure.

Design--Report Layout--Show in Tabular format.

I to set this using code with epplus. Please help me regarding this report layout.

Thanks,
Alluri
Mar 3, 2013 at 1:51 PM
Hi,

For each ExcelPivotTableField, set its Outline property to false.

Something like:
foreach(var field in pivot.Fields)
{
   field.Outline = false;
}
Regards,

Ivan
Mar 4, 2013 at 12:57 PM
Hi,

Thank you so much. This worked perfectly.

I also having one more issue where I am unable to remove the drill down option.
I am using the below code.

pivotTable1.EnableDrill = false;
pivotTable1.ShowDrill = false;

Please suggest.

Regards,
Alluri