Pivot grid Row Field Width

[Syed]

Hi,
In my Pivot table i want to set the width for each column of row Filed.

I set the column width like this.

                        <telerik:PivotGridRowField DataField="Maintype"  Caption="" CellStyle-Width="60px"     >
                </telerik:PivotGridRowField>
                   <telerik:PivotGridRowField DataField="subtype"  Caption="" CellStyle-Width="60px"  >
                </telerik:PivotGridRowField>
                <telerik:PivotGridRowField DataField="Listtype"  Caption="" CellStyle-Width="110px"  >
                </telerik:PivotGridRowField>

but i found some stange result as the width for each column is in irregular form.
means first column width set to second column and last column with is not changing
Please check the attached image for details.

I dont want to use the RowHeaderCellStyle widh ,because this will set the same width for all the row field column.

I want to set the Individual column width of rowfield.

[Venelin]

Hello Syed,

I am afraid that based on the provided information the issue is not replicating on my side. I created a sample project where the CellStyle-Width property is working as expected. Could you please examine it and tell what should be changed in order to reproduce the problem?

ASPX:

<telerik:RadPivotGrid ID="RadPivotGrid2" runat="server" Width="1200px"
    AllowPaging="true" OnNeedDataSource="RadPivotGrid_NeedDataSource">
    <Fields>
        <telerik:PivotGridRowField DataField="TransportType" CellStyle-Width="150px" CellStyle-ForeColor="blue">
        </telerik:PivotGridRowField >
        <telerik:PivotGridRowField DataField="Company" CellStyle-Width="250px"  CellStyle-ForeColor="Green">
        </telerik:PivotGridRowField>
        <telerik:PivotGridColumnField DataField="Country">
        </telerik:PivotGridColumnField>
        <telerik:PivotGridColumnField DataField="City">
        </telerik:PivotGridColumnField>
        <telerik:PivotGridAggregateField DataField="Profit" Aggregate="Sum" DataFormatString="{0:C}">
        </telerik:PivotGridAggregateField>
    </Fields>
</telerik:RadPivotGrid>

C#:

public DataTable GetDataTable(string query)
{
    String ConnString = ConfigurationManager.ConnectionStrings["TelerikConnectionString"].ConnectionString;
    SqlConnection conn = new SqlConnection(ConnString);
    SqlDataAdapter adapter = new SqlDataAdapter();
    adapter.SelectCommand = new SqlCommand(query, conn);

    DataTable myDataTable = new DataTable();

    conn.Open();
    try
    {
        adapter.Fill(myDataTable);
    }
    finally
    {
        conn.Close();
    }

    return myDataTable;
}

protected void RadPivotGrid_NeedDataSource(object sender, PivotGridNeedDataSourceEventArgs e)
{

Regards,
Venelin
Telerik

[Barbaros Saglamtimur]

I have same problem and solved as giving width at run-time like;

RadPivotGrid1.Fields.GetFieldByUniqueName("CustomerNameCell").CellStyle.Width = Unit.Pixel(175);

[Syed]

Hi ,
I find the cause for not setting the width for each column of row field
.if we use the Scrolling-AllowVerticalScroll="true" the Column width is miss matching.
Find the attached image for more details

If i not used the Allow Scroll : The Row Field width Works fine Check the attached image PivotGridBeforeusingScroll
<telerik:RadPivotGrid ID="RadPivotGrid2" runat="server" Width="100%" Height="500px" CellPadding="2"  Skin="Office2010Blue"
           CellSpacing="2" Culture="ko-KR" GridLines="None"  HorizontalAlign="Center"  ShowFilterHeaderZone="false"
   AllowPaging="false" OnNeedDataSource="RadPivotGrid_NeedDataSource" AllowFiltering="false" ShowDataHeaderZone="false" ShowRowHeaderZone="true" 
        ShowColumnHeaderZone="false" 
            oncelldatabound="RadPivotGrid2_CellDataBound">
             <TotalsSettings RowsSubTotalsPosition="None" RowGrandTotalsPosition="None"
        ColumnsSubTotalsPosition="None" ColumnGrandTotalsPosition="None" />
            <Fields>
    <telerik:PivotGridRowField DataField="TransportType" CellStyle-Width="30px" CellStyle-ForeColor="blue" Caption="Row">
    </telerik:PivotGridRowField >
    <telerik:PivotGridRowField DataField="Company" CellStyle-Width="250px"  CellStyle-ForeColor="Green">
    </telerik:PivotGridRowField>
    <telerik:PivotGridColumnField DataField="Country">
    </telerik:PivotGridColumnField>
    <telerik:PivotGridColumnField DataField="City">
    </telerik:PivotGridColumnField>
    <telerik:PivotGridAggregateField DataField="Profit" Aggregate="Sum" CellStyle-Width="30px" DataFormatString="{0:C}">
    </telerik:PivotGridAggregateField>
   </Fields>
  </telerik:RadPivotGrid>

If i not used the Allow Scroll : The Row Field width Works fine Check the attached image PivotGridAfterusingScroll2

<telerik:RadPivotGrid ID="RadPivotGrid2" runat="server" Width="100%" Height="500px" CellPadding="2"  Skin="Office2010Blue"
           CellSpacing="2" Culture="ko-KR" GridLines="None"  HorizontalAlign="Center"  ShowFilterHeaderZone="false"
   AllowPaging="false" OnNeedDataSource="RadPivotGrid_NeedDataSource" AllowFiltering="false" ShowDataHeaderZone="false" ShowRowHeaderZone="true" 
        ShowColumnHeaderZone="false" 
            oncelldatabound="RadPivotGrid2_CellDataBound">
             <TotalsSettings RowsSubTotalsPosition="None" RowGrandTotalsPosition="None"
        ColumnsSubTotalsPosition="None" ColumnGrandTotalsPosition="None" />
         <ClientSettings Scrolling-AllowVerticalScroll="true"  Scrolling-SaveScrollPosition="true" > </ClientSettings>
   <Fields>
    <telerik:PivotGridRowField DataField="TransportType" CellStyle-Width="30px" CellStyle-ForeColor="blue" Caption="Row">
    </telerik:PivotGridRowField >
    <telerik:PivotGridRowField DataField="Company" CellStyle-Width="250px"  CellStyle-ForeColor="Green">
    </telerik:PivotGridRowField>
    <telerik:PivotGridColumnField DataField="Country">
    </telerik:PivotGridColumnField>
    <telerik:PivotGridColumnField DataField="City">
    </telerik:PivotGridColumnField>
    <telerik:PivotGridAggregateField DataField="Profit" Aggregate="Sum" CellStyle-Width="30px" DataFormatString="{0:C}">
    </telerik:PivotGridAggregateField>
   </Fields>
  </telerik:RadPivotGrid>

how to solve this ?

[Konstantin Dikov]

Hi Syed,

As we have discussed in your Support Ticker regarding the same issue, this seems to be a bug with the RadPivotGrid when vertical scrolling is enabled.

I have opened a new item in our Ideas & Feedback portal, where you could keep track of its progress and see the available temporary workaround.

Once again, please excuse us for any inconvenience caused by this.


Regards,
Konstantin Dikov
Telerik

[J2K]

As of releases through 2015, still no fix for the problem Syed cites, as I experienced exactly what he describes, with both 2014 and 2015 releases.  Setting Scrolling-AllowVerticalScroll ="false" seems to be the only hope of ending up with column widths that make any sense given the actual data displayed.

 

 

[Konstantin Dikov]

Hi,

The fix was introduced in Q1 2016, so upgrading to that version should resolve the issue. Can you please upgrade to Q1 2016 and let us know if everything works correctly on your side? 

Looking forward to your reply.


Regards,
Konstantin Dikov
Telerik

[J2K]

Thanks, but no, won't be changing to 2016 version of Telerik ASP NET controls as I didn't renew the subscription, while I appreciate the many good features of the controls, this kind of odd display behavior of RadControls I've learned over the years is simply endemic with the controls.  And way too often, the response from support was "I can't replicate" or "will be fixed in the next version" After many hours of futzing, the solution here was to wrap the pivot grid in a div with the div's overflow set to auto, and set the pivotgrid's height to a level that would result in the div's scrollbar displayed as needed.  This allowed setting the pivotgridrowfield to a reasonable width so it's value wasn't wrapped 2, 3, and in a few cases, 4 lines deep, and stlll being able to reach all the rows.  The other oddity is setting the pivotgridcolumn field width, setting it to anything caused unpredictable results, most often the total and/or grand totals are not displayed or chopped in half.  The only solution was not setting the desired header width and/or  column widths.

 

[Konstantin Dikov]

Hello Mark,

Let me start by saying that we are constantly trying to improve our product and to fix all reported issues, but in some cases, without a sample project that replicates the bug it is impossible to pinpoint the root of the issue and provide a fix for it.

I want to assure you that our goal is to always improve the controls and cover as many scenarios as possible.

If you have encounter another issue with the width that is replicated with our latest version (you can download the trial version for testing) you can open a new "Bug report" thread with a RadPivotGrid configuration that replicates the problem.


Best Regards,
Konstantin Dikov
Telerik