RadPivotFieldList DataProvider

4 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 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
  2. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 10 Dec 2013 Link to this post

    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 >>
  3. DevCraft banner
  4. Müllner
    Müllner avatar
    6 posts
    Member since:
    Jan 2013

    Posted 10 Dec 2013 Link to this post

    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
  5. Rosen Vladimirov
    Admin
    Rosen Vladimirov avatar
    640 posts

    Posted 13 Dec 2013 Link to this post

    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 >>
Back to Top