This is a migrated thread and some comments may be shown as answers.

RadPivotFieldList DataProvider

3 Answers 18 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Müllner
Top achievements
Rank 1
Müllner asked on 05 Dec 2013, 08:52 AM
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

3 Answers, 1 is accepted

Sort by
0
Rosen Vladimirov
Telerik team
answered on 10 Dec 2013, 08:51 AM
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
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 >>
0
Müllner
Top achievements
Rank 1
answered on 10 Dec 2013, 01:06 PM
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
0
Rosen Vladimirov
Telerik team
answered on 13 Dec 2013, 08:32 AM
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
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 >>
Tags
PivotGrid
Asked by
Müllner
Top achievements
Rank 1
Answers by
Rosen Vladimirov
Telerik team
Müllner
Top achievements
Rank 1
Share this question
or