OWC - Pivot table size

[mal_k100]

Hi,
I am creating a link to a SQL server OLAP cube in Excel and publishing
to .htm interactively - all works fine.

I have been trying to work out how to (easily) change the
characteristics of the resulting Pivot Table area using something like
MaxHeight.

Is there a way to do this in the class tags ? I have tried a number of
different ways but maybe I am doing it in the wrong place or my syntax
is wrong. I have been referring to the OWC object model for the
properties of the pivot table and even tried some VBscriopt, all to no
avail.

I have the following:

<div id="Book2_3736" align=left xublishsource="Excel">
<object
id="Book2_3736_DSC" codebase="file:msowc.cab"
classid="CLSID:0002E530-0000-0000-C000-000000000046">
<param name=XMLData.......................</object>
<object id="Book2_3736_PivotList" codebase="file:msowc.cab"
classid="CLSID:0002E520-0000-0000-C000-000000000046" >
<param name=XMLData.........................
I even tried using a table but something is auto sizing.

The reason I want to do this is because I have seen this techniqued
used before and it will create a vertical scroll bar (I may try an
horizontal on aswell) on the Pivot area and not for the browser page.
This is much easier for a user as with very long lists they end up at
the moment with 2 vertiocal scrolls and the browser one is much slower
than using a single Pivot area scroll.

Thanks

 

[Antoine Prevot]

I even tried using a table but something is auto sizing.

The reason I want to do this is because I have seen this techniqued
used before and it will create a vertical scroll bar (I may try an
horizontal on aswell) on the Pivot area and not for the browser page.
This is much easier for a user as with very long lists they end up at
the moment with 2 vertiocal scrolls and the browser one is much slower
than using a single Pivot area scroll.

Thanks

Hi,

Try this, assuming your PivotTable ID is "PT" :

PT.ActiveView.AutoLayout()
PT.AutoFit = False
PT.MaxWidth = xxx
PT.MaxHeight = yyy
PT.Width = xxx
PT.Height = yyy

The scrollbars should appear, but you'll have another problem : the
scrollbars are only used for the Data zone, not for the entire object
(including rows/columns dimension members).

Hope this helps,

Tonio