PivotGrid - Text in Cell value

[jung]

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

[Hristo]

Hi Jung,

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

[jung]

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

[jung]

Additionally, i wanted to separate view and Data.
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.

[Hristo]

Hello Jung,

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:

• http://stackoverflow.com/questions/14817061/transpose-a-datatable

I hope this information is useful. Should you have further questions please do not hesitate to write back.

Regards,
Hristo Merdjanov
Telerik by Progress

[John]

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

[Hristo]

Hi John,

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