transposing columns and rows

4 posts, 0 answers
  1. Naresh
    Naresh avatar
    1 posts
    Member since:
    Jan 2012

    Posted 30 Jan 2012 Link to this post

    We have a requirement of building an editable grid that looks something like below. Can you tell us if this is possible with minimal work using any of your controls.. including pivot control if possible. We are looking at purchasing around 8-10 developer licenses. Remember the control must support 2-way binding such that if a user changes any data in the grid, then it must correctly update the field of the correct element in the object collection:

     

    Date

    1/1/2012

    1/2/2012

    1/3/2012

    1/4/2012

    Customer

    Cust 1

    Cust 2

    Cust 3

    Cust 4

    Bill Amount

    100

    200

    120

    50

     

    As you can see it is basically a transposed list and the data format is per row/cell and not per column. Will really appreciate if someone can point me to the control that would fit this need with some directions/links etc. Also the no. of columns will be dynamic, so the grid needs to generate the appropriate no. of columns at runtime.

  2. Pavel Pavlov
    Admin
    Pavel Pavlov avatar
    2039 posts

    Posted 31 Jan 2012 Link to this post

    Hi Naresh ,

    With the current version of our dlls you can use the approach demonstrated in this blog post. We are also at the late stages of development of an out-of-the box pivot grid , which will be available in one of our next major releases.

    Regards,
    Pavel Pavlov
    the Telerik team

    Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

  3. Brad
    Brad avatar
    1 posts
    Member since:
    Jul 2014

    Posted 22 Jul 2014 in reply to Pavel Pavlov Link to this post

    1) I don't think that blog post does a good job of what Naresh asked for.  I think what he was looking for (and I know it's what I'm looking for) is the ability to have different data types in each row.  So, in row 1 we'd need a date picker, in row 2 we'd need a textbox, and in row 3 we'd need a control that accepts only ints (or floats or whatever).
    2) I've looked through the demos for the pivot grid and I see nothing there that would address this need.

    Any help on this would be much appreciated!
    Brad.
  4. Dimitrina
    Admin
    Dimitrina avatar
    3769 posts

    Posted 23 Jul 2014 Link to this post

    Hi Brad,

    RadGridView does not suggest such a functionality transposing columns and rows.

    As to your first requirement on having different editors in different rows, you can check the CellTemplateSelector option to return a proper template with right values based on the type of the data populated in a column.

    Regards,
    Didie
    Telerik
     
    Check out Telerik Analytics, the service which allows developers to discover app usage patterns, analyze user data, log exceptions, solve problems and profile application performance at run time. Watch the videos and start improving your app based on facts, not hunches.
     
Back to Top