Pivotgrid celldatabound and underlying data

2 posts, 0 answers
  1. Erik
    Erik avatar
    3 posts
    Member since:
    Sep 2015

    Posted 16 Feb 2016 Link to this post

    I am trying to format a cell based on the value of another field in the underlying recordset. How do I access those values?
  2. Eyup
    Eyup avatar
    4079 posts

    Posted 19 Feb 2016 Link to this post


    RadPivotGrid is specifically designed to visualize calculated data and present the users with logically grouped information:

    You can examine its capabilities through our live samples:

    The ItemDataBound event is not available with RadPivotGrid because it is not per record control, but rather it is a summarization control in its essence. It uses information from all the records to apply calculations in its core engine and only displays the results in its grid structure. In this sense, you cannot access the items individually and manipulate their data on a singleton basis as with RadGrid.

    You can also check the Custom Data Calculations article, which may be exactly what you are looking for:

    Maybe you are looking for a RadGrid with a Hierarchy structure integrated with custom aggregate calculations or group footers with Totals:

    For conclusion, it is not possible to implement item-based logic with RadPivotGrid  as you can achieve with other data visualization controls. RadGrid and RadListView for example provide ItemDataBound and ItemCreated events where you can examine the details of every record. RadPivotGrid is specifically designed for calculating large amount of numeric values and it displays only the result from these summaries.

    I hope the clarification was helpful.


    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
Back to Top