Pivot grid Row Field Width

9 posts, 0 answers
  1. Syed
    Syed avatar
    36 posts
    Member since:
    Sep 2013

    Posted 04 Nov 2013 Link to this post

    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.



  2. Venelin
    Admin
    Venelin avatar
    352 posts

    Posted 07 Nov 2013 Link to this post

    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
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. Barbaros Saglamtimur
    Barbaros Saglamtimur avatar
    110 posts
    Member since:
    Jul 2012

    Posted 11 Nov 2013 Link to this post

    I have same problem and solved as giving width at run-time like;
    RadPivotGrid1.Fields.GetFieldByUniqueName("CustomerNameCell").CellStyle.Width = Unit.Pixel(175);
  5. Syed
    Syed avatar
    36 posts
    Member since:
    Sep 2013

    Posted 18 Dec 2013 Link to this post

    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 ?
  6. Konstantin Dikov
    Admin
    Konstantin Dikov avatar
    1803 posts

    Posted 20 Dec 2013 Link to this post

    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
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.
  7. J2K
    J2K avatar
    33 posts
    Member since:
    Sep 2005

    Posted 10 Mar in reply to Konstantin Dikov Link to this post

    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.

     

     

  8. Konstantin Dikov
    Admin
    Konstantin Dikov avatar
    1803 posts

    Posted 11 Mar Link to this post

    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
    Do you need help with upgrading your ASP.NET AJAX, WPF or WinForms projects? Check the Telerik API Analyzer and share your thoughts.
  9. J2K
    J2K avatar
    33 posts
    Member since:
    Sep 2005

    Posted 17 Mar in reply to Konstantin Dikov Link to this post

    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.

     

  10. Konstantin Dikov
    Admin
    Konstantin Dikov avatar
    1803 posts

    Posted 22 Mar Link to this post

    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
    Do you need help with upgrading your ASP.NET AJAX, WPF or WinForms projects? Check the Telerik API Analyzer and share your thoughts.
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017