Missing Scrollbars in PivotTable

T

texlnghorn

I am going round and round trying to figure out how to get the scroll bars to
appear in my PivotTable. I placed the PivotTable in a Panel and set the
PivotTables AutoFit to false and reduced the max height and width smaller
than the original size of the Panel. When I display my data, the scroll bars
are not present and I cannont view 75% of my data. I am using OWC11 in
Visual Studio .NET 2003. Anyone have any ideas what is going on?

Thanks,
Mike
 
T

texlnghorn

I think I figured it out. After I read in an XML file and insert my fields
in the RowAxis, ColumnAxis, and DataAxis, I then reset the MaxWidth and
MaxHeight. But what I really want is for the PivotTable to fill the entire
panel and then when the form is resized, the scroll bars should appear and
disappear as needed. I came up with a solution for this also but I think it
should be unnecessary. I set the PivotTable's dock property to fill and set
the panel's anchor to top, left, right, and bottom. I then added an event
handler for the resize event on the form. In the event handler, I change the
MaxWidth and MaxHeight of the PivotTable to the width and height of the
panel. This works.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top