RadPivot and DataSource..no data shown

4 posts, 0 answers
  1. maurizio brusini
    maurizio brusini avatar
    21 posts
    Member since:
    Oct 2009

    Posted 14 Jan 2014 Link to this post

    Hi, i have Telerik version  Q3 2012 , Oracle DB 10, VS 2005.

    I try in all the way to bind data to RadPivot but no way, nothing happens. I tried with ObjectDataSource and with Advanced Data...but i failed.

    Do i need a specific DDL ? or another version of Telerik ?

    Anyway give a look to what i produce and tell me please where is the mistake.

    <telerik:RadPivotGrid runat="server" ID="RadPivotGrid1" AllowFiltering="true"

    AllowPaging = "true"

    Width="800px" Height="400px"



    OnNeedDataSource="RadPivotGrid1_NeedDataSource" >

    <ClientSettings EnableFieldsDragDrop="true">

    <Scrolling AllowVerticalScroll="true"></Scrolling>



    <telerik:PivotGridRowField DataField="attivita">


    <telerik:PivotGridColumnField DataField="liv_auto">


    <telerik:PivotGridAggregateField DataField="q_ta" Aggregate="Sum">




    In vb file :

    Protected Sub RadPivotGrid1_NeedDataSource(ByVal sender As Object, ByVal e As Telerik.Web.UI.PivotGridNeedDataSourceEventArgs) Handles RadPivotGrid1.NeedDataSource


    TryCast(sender, RadPivotGrid).DataSource = GetDataTable("SELECT * FROM lbrms_libretto_vw where matri=17720")

    End Sub

    Public Function GetDataTable(ByVal query As String) As DataTable

    Dim ConnString As [String] = ConfigurationManager.ConnectionStrings("ConnectionString").ConnectionString

    Dim conn As New OracleConnection(ConnString)

    Dim adapter As New OracleDataAdapter()

    adapter.SelectCommand = New OracleCommand(query, conn)

    Dim myDataTable As New DataTable()






    End Try

    Return myDataTable

    End Function

    NeedDataSource fires and the DataTable contains data. But  Pivot show  no data.

    I guess maybe the structure of my Oracle Table is not good for Pivot ?

    ID     Activity    Level_Activity  Quantity

    --      ---------     ------------------- -----------

    1       A             High                  20

    2       A             Low                   10

    3       B             High                   12

    and so on.....

    SomeOne can help me  ?

    Thanks Maurizio

  2. Antonio Stoilkov
    Antonio Stoilkov avatar
    530 posts

    Posted 17 Jan 2014 Link to this post


    I have examined the provided code and everything looks correct. You could ensure that the DataField values for the PivotGridField's are correct because you have one DataField's set in the markup and another shown in the example table below the markup.

    If your issue still persists I would suggest downloading our latest release and trying with it in order to observe if the RadPivotGrid will bind correctly.

    Antonio Stoilkov
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.
  3. maurizio brusini
    maurizio brusini avatar
    21 posts
    Member since:
    Oct 2009

    Posted 20 Jan 2014 Link to this post

    Hi Antonio and thanks for your responce,
    About yuor question the responce is YES tha datafield are the same, Just wrote in italian in first case and in english in the table description.
    The problem still persist so i will follow your advice and i will downloading the lastest version.
    Best regards
  4. maurizio brusini
    maurizio brusini avatar
    21 posts
    Member since:
    Oct 2009

    Posted 21 Jan 2014 Link to this post

    Hi i resolve It  !!

    problem was  datafield name in Lowercase while in my Oracle DB definition colun was in UpperCase.
    In the moment i write datafiled name in Uppercase all work !!



Back to Top