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

RadPivot and data shown

3 Answers 47 Views
This is a migrated thread and some comments may be shown as answers.
Top achievements
Rank 1
Ghezzo asked on 14 Jan 2014, 01:04 PM

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

3 Answers, 1 is accepted

Sort by
Antonio Stoilkov
Telerik team
answered on 17 Jan 2014, 07:48 AM

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.
Top achievements
Rank 1
answered on 20 Jan 2014, 12:39 PM
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
Top achievements
Rank 1
answered on 21 Jan 2014, 09:23 AM
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 !!



Asked by
Top achievements
Rank 1
Answers by
Antonio Stoilkov
Telerik team
Top achievements
Rank 1
Share this question