Hide a column in Pivot Table

[Vaishali Patel]

Hi,
I am using a Pivot table in my .Net web application. I donot want to show
all columns that get bound to the pivot table. What is the best way I can
write Client-side code to hide a specific Column.

Regards,
Vaishali Patel

 

[Alvin Bruney [ASP.NET MVP]]

Have a look at the pivotaxis object

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99

 

[Joe Sampino]

try this:

ActiveView.Totals("XXX").AutoFit = false
ActiveView.Totals("XXX").Width = 0

it should also hide the total column for the measure if there would be one.

--Joe

Have a look at the pivotaxis object

--

Regards,
Alvin Bruney [MVP ASP.NET]

[Shameless Author plug]
The O.W.C. Black Book, 2nd Edition
Exclusively on www.lulu.com/owc $19.99
-------------------------------------------------------

Hi,
I am using a Pivot table in my .Net web application. I donot want to show
all columns that get bound to the pivot table. What is the best way I can
write Client-side code to hide a specific Column.

Regards,
Vaishali Patel