PivotGrid - Text in Cell value

7 posts, 0 answers
  1. jung
    jung avatar
    6 posts
    Member since:
    Jul 2016

    Posted 20 Jul 2016 Link to this post

    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

  2. Hristo
    Admin
    Hristo avatar
    1068 posts

    Posted 21 Jul 2016 Link to this post

    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
    Check out the Windows Forms project converter, which aids the conversion process from standard Windows Forms applications written in C# or VB to Telerik UI for WinForms. For more information check out this blog post and share your thoughts.
  3. jung
    jung avatar
    6 posts
    Member since:
    Jul 2016

    Posted 21 Jul 2016 in reply to Hristo Link to this post

    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

  4. jung
    jung avatar
    6 posts
    Member since:
    Jul 2016

    Posted 21 Jul 2016 in reply to jung Link to this post

    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.
  5. Hristo
    Admin
    Hristo avatar
    1068 posts

    Posted 22 Jul 2016 Link to this post

    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:
    I hope this information is useful. Should you have further questions please do not hesitate to write back.

    Regards,
    Hristo Merdjanov
    Telerik by Progress
    Check out the Windows Forms project converter, which aids the conversion process from standard Windows Forms applications written in C# or VB to Telerik UI for WinForms. For more information check out this blog post and share your thoughts.
  6. John
    John avatar
    23 posts
    Member since:
    Sep 2013

    Posted 21 Apr Link to this post

    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

  7. Hristo
    Admin
    Hristo avatar
    1068 posts

    Posted 24 Apr Link to this post

    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
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top