hello
I would like to express a Text in cell value.
but An error occurs.
so,
I would like to know whether there are any add-ons after this post
- Similar post in 2012' (last update 2014' , ASP)
http://www.telerik.com/forums/will-pivot-grid-show-the-string-values
and,
Please let me know if i don't know the case using pivotgrid.
Programming Language : C#
OS : Windows7 x86
.NET4
Telerik : R2 2016 SP1
6 Answers, 1 is accepted
Thank you for writing.
RadPivotGrid represents aggregated data which can be grouped by rows and columns. The text displayed in a particular cell is a result of the applied groups or aggregates. Could you please specify in details what is your requirement?
In case you do not need grouped rows, perhaps RadGridView could fit your local setup: http://docs.telerik.com/devtools/winforms/gridview/overview.
I hope this information is useful. Looking forward to your reply.
Regards,
Hristo Merdjanov
Telerik by Progress
Thank you very much
I was just trying to rotate the table.
It's possible, but i had been looking for a solution being provided more efficient
and Data=DataSet, view=gridview
so i made Data=normaly (horizen) , View=rotate(vertical)
naturally process of rotating was slow
i was dizzy what did i.
finally i just use gridview and using GridViewDataColumn decided to add vertical without separating view and data.
if other solution is exist, tell me us.
Thank you for writing back.
If I understand correctly you are now using RadGridView which fits your requirement. In case you are having a data table and you would like to transpose it before binding the grid you can check the following forum thread:
I hope this information is useful. Should you have further questions please do not hesitate to write back.
Regards,
Hristo Merdjanov
Telerik by Progress
From a similar thread in Asp.Net. http://www.telerik.com/forums/will-pivot-grid-show-the-string-values
You can use min/max on a numeric value and then replace the text in the CellFormatting Event
Private Sub RadPivotGrid1_CellFormatting(sender As Object, e As Telerik.WinControls.UI.PivotCellEventArgs) Handles RadPivotGrid1.CellFormatting
Dim sResNum As String = CInt(Val(e.CellElement.Text))
If sResNum.Length > 5 Then
Dim dr As DataRow = myEverythingTable.Rows.Find(sResNum)
If dr IsNot Nothing Then
'e.CellElement.Text = IIf(IsDBNull(dr("result")), "", dr("Result"))
If IsDBNull(dr("result")) Then
e.CellElement.Text = ""
Else
e.CellElement.Text = dr("result")
End If
End If
End If
End Sub
Thank you for writing.
Indeed handling the CellFormatting event is a valid approach for changing the text displayed in the cells. Additional information is available here: Formatting Appearance. RadPivotGrid is virtualized so please also make sure that you reset all the properties you set in a formatting event.
I hope this helps. Should you have further questions please do not hesitate to write back.
Regards,
Hristo
Telerik by Progress