PivotGrid RowGroupDescriptions PropertyGroupDescription

6 posts, 0 answers
  1. Müllner
    Müllner avatar
    6 posts
    Member since:
    Jan 2013

    Posted 05 Dec 2013 Link to this post

    Hi.
    I have a PivotGrid.

    This is my DataProvider:
    <pivot:LocalDataSourceProvider.RowGroupDescriptions>
                <pivot:PropertyGroupDescription PropertyName="FirstName"/>
                <pivot:PropertyGroupDescription PropertyName="LastName"/>
    </pivot:LocalDataSourceProvider.RowGroupDescriptions>

    They getting compared.
    Is it possible that they are in one Level (one row)?
    Regards
  2. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 10 Dec 2013 Link to this post

    Hi Müllner,

    When you create two group descriptions, there's no way to use them on a single row - they are always getting compared. You can use a single group description and add a property in your data item to return the combined value of FirstName and LastName. You can extend this solution by using DataAnnotations to hide FirstName and LastName from RadPivotFieldList as shown in this help topic.
    Public ReadOnly Property Name() As String
        Get
            Return String.Format("{0} {1}", Me.FirstName, Me.LastName)
        End Get
    End Property

    Hope this helps. Feel free to contact us in case you have any other problems or concerns.

    Regards,
    Rosen Vladimirov
    Telerik
    TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for SILVERLIGHT.
    Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
    Sign up for Free application insights >>
  3. DevCraft banner
  4. Müllner
    Müllner avatar
    6 posts
    Member since:
    Jan 2013

    Posted 10 Dec 2013 Link to this post

    Okay.
    That means it is not possible that I have a normal list of adress?
    First Name - Last Name - ZIP - State.

    It is only possible to group them?
    Regards
  5. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 13 Dec 2013 Link to this post

    Hello Müllner,

    I'm not sure I fully understand your problem. If you want to show First Name - Last Name in a single group you have to modify your source as I've shown in my previous post. If you want to show the whole group First Name - Last Name - ZIP - State, just modify the code I've sent you  to use all of the properties you need. If you want to show them as separate properties, just add group descriptions for each of them and they will be shown on different levels.

    Could you clarify what is your issue and what do you want to show in RadPivotGrid? I'm looking forward to hearing from you.

    Regards,
    Rosen Vladimirov
    Telerik
    TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for SILVERLIGHT.
    Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
    Sign up for Free application insights >>
  6. Müllner
    Müllner avatar
    6 posts
    Member since:
    Jan 2013

    Posted 16 Dec 2013 Link to this post

    Hi.

    I want that this is a normal list like Excel.
    That the rows don´t have different levels.
    I hope you understand my question :-)

    Regards
  7. Kalin
    Admin
    Kalin avatar
    1207 posts

    Posted 18 Dec 2013 Link to this post

    Hello Müllner,

    As far I understand the requirements you may need to consider using GridView instead of PivotGrid. With the GridView you will be able to achieve simple Excel look and will be able to click on the column headers in order to sort the values in the columns (as you have asked for that in other post). You can check the GridView online Silverlight demos on this link and its documentation on this link.

    Hope this helps. If you have any further questions let us know.

    Regards,
    Kalin
    Telerik
    TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for SILVERLIGHT.
    Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
    Sign up for Free application insights >>
Back to Top
DevCraft banner