[Solved] RadPivotFieldList DataProvider

[Müllner]

Hi.

I have following class which I want to bind on PivotFieldList.
Is it possible to have the class "Sachkonto" on an own Level like DateTime?

Because I always only get it like in my Picture included.
Thanks
Regards

Public Interface ISaldenMetadatenSK
   ReadOnly Property Sachkonto As ISachkonto

   ReadOnly Property Datum As DateTime
   ReadOnly Property LfdSaldo As Decimal
   ReadOnly Property LfdSaldoSoll As Decimal? 'kein Datamember
   ReadOnly Property LfdSaldoHaben As Decimal? 'kein Datamember
   ReadOnly Property EBSaldo As Decimal
   ReadOnly Property EBSaldoSoll As Decimal? 'kein Datamember
   ReadOnly Property EBSaldoHaben As Decimal? 'kein Datamember

   ReadOnly Property GesamtSaldoMitEB As Decimal?
   ReadOnly Property GesamtSaldoMitEBSoll As Decimal? 'kein Datamember
   ReadOnly Property GesamtSaldoMitEBHaben As Decimal? 'kein Datamember

End Interface

Public Interface ISachkonto
   ReadOnly Property Nummer As Integer
   ReadOnly Property Bezeichnung As String
   ReadOnly Property Gliederung As String
   ReadOnly Property Kontenklasse As String
End Interface

[Rosen Vladimirov]

Hello,

In order to achieve this you can use LocalDataSourceFieldDescriptionsProvider's AddingContainerNode event and modify the field tree based on your needs. You can check this article for more information.

I've prepared a sample project based on your description. Please give it a try and inform us in case you have any problems or concerns.

Regards,
Rosen Vladimirov
Telerik

[Müllner]

That means it is not possible that the class Sachkonto have more propertys and it is shown in a folder?
Like the same in as in my interface??


I have also another question:
I attached a file. Is this possible to have a second Total Row where I can calculate something?

Regards

[Rosen Vladimirov]

Hello Müllner,

Your property is of type Sachkonto and RadPivotGrid extracts its value, not its properties. There's no way to extract the properties of the class in this situation. You can change your ISaldenMetadatenSK class to implements ISachkonto interface and this way you will get all properties inside RadPivotFieldList.

As for the second question - you are not able to add data below GrandTotals, but there's another way to achieve your goal:
1) Hide the GrandTotals by setting RowGrandTotalsPosition="None".
2) Add CalculatedItem that will show calculate all values.
3) Add CalculatedItem that will calculate your value.

More information about CalculatedItems is available in our online help. You can download sample project from our SDK Repository.

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

Regards,
Rosen Vladimirov
Telerik