PivotGrid RowGroupDescriptions PropertyGroupDescription

[Müllner]

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

[Rosen Vladimirov]

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

[Müllner]

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

[Rosen Vladimirov]

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

[Müllner]

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

[Kalin]

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