Do More Than Manage
Gord Schmidt's Ideas for Doing More with Microsoft Project Server
Summary Task

Pivot Table Width on Cube View Admin page

There are a few things in the Project Web Access interface that initially bothered me that have faded with time, but the width of the Pivot table on the View design page continues to irk me.

The monitor I use is wider than average, but the page for creating or modifying Data Analysis views only provides a Pivot table that is not even half of the page width. An equal amount is allocated to instructions that do not come close to filling the space.

Picture of the pivot table taking less than 50% of the page width

Today, I decided to hack it. And it is a hack. There is nothing elegant or clean or supportable about this. But if you are producing lots of Data Analysis views, perhaps you will want to do this too. But if you do, heed the following warnings:

Start on your server and navigate to the following file:

c:\Program Files\Common Files\Microsoft Shared\web server extensions\12\Template\Layouts\CubeAdmin\CubeViewAdmin.aspx

Next, find the following code:

<!-- OWC section -->
<div id="idPivotTableDiv" style="display:block;" >
   <asp:label ID="lbldivPivotTableLBL" text="<%$Resrouces:PWA,CUBEADMIN_CUBEVIEWADMIN_PIVOTTABLE_LABEL%>" runat="server" />
   <div style="width:100%; height:300px; overflow:auto; border: 1px Solid Black;">
      <object classid="clsid:0002E55A-0000-0000-C000-000000000046" id="idPivot"></object>

Do you see the width and height definitions for the DIV section? That's where we should make changes, but only after you backup this file.

Perhaps try setting the width to 1000 pixels and the height to 500 pixels as below. You will have to base this on your screen size (remembering that this change is at the server level so every other user of the page will be impacted as well.

   <div style="width:1000px; height:500px; overflow:auto; border: 1px Solid Black;">

This results in something I find much more usable.

Pivot table at more than fifty percent of the page width

Posted by Gord Schmidt on Friday, March 20, 2009 | Permalink | Resolve | Extend