Telerik Forums
UI for ASP.NET AJAX Forum
0 answers
37 views

Hi 

I have created a TelerikPivotGrid which displays a count of record per department and Type.

The data in the cell within the grid is clickable, and when a user clicks on I need to get the name of the column and name of the row for the cell they have clicked on.

Please can anyone advise how to get the values of the grid when a user clicks on the cell within the grid?

Thank you

Rakhee
Top achievements
Rank 1
Iron
Iron
 updated question on 03 Oct 2023
3 answers
105 views

Hi All,

Can any one let me know how to save and retrieve the layout settings from SQL server .

 

Fernando
Top achievements
Rank 2
Iron
 updated answer on 11 Apr 2023
0 answers
72 views

greeting ,,

I want to put image in  CellTemplate as field from database



                                <telerik:RadPivotGrid ID="RadPivotGrid3" runat="server" AllowFiltering="False" AllowPaging="True"
                            AllowSorting="True" ShowColumnHeaderZone="False" ShowDataHeaderZone="False" ShowRowHeaderZone="False"
                            Width="100%" ShowFilterHeaderZone="False" AggregatesLevel="1">
                            <PagerStyle ChangePageSizeButtonToolTip="Change Page Size" PageSizeControlType="RadComboBox" />
                            <Fields>
                                 <telerik:PivotGridRowField DataField="bank_nat_name" UniqueName="bank_nat_name" SortOrder="Ascending">
                                    <CellStyle Width="100" />
                                    <CellTemplate>
                                    <asp:Image ID="flag_logo" runat="server" Visible="true"
                            Width="50px" Height="50px" ImageUrl='<%#"~/Files/Bank_nat_Photo/" + CStr(Eval("bank_logo", "{0}"))%>'/>
                                    </CellTemplate>

                                </telerik:PivotGridRowField>
                                <telerik:PivotGridRowField DataField="bankname" UniqueName="bankname" SortOrder="Ascending">
                                    <CellStyle Width="100" />
                                    <CellTemplate>
                                    <asp:Image ID="bank_logo1" runat="server" Visible="true"
                            Width="50px" Height="50px" ImageUrl='<%# "~/Files/Banks_Photo/" + CStr(Eval("bank_logo", "{0}"))%>'/>
                                    </CellTemplate>

                                </telerik:PivotGridRowField>
                                <telerik:PivotGridColumnField DataField="MONTHT" UniqueName="MONTHT">
                                </telerik:PivotGridColumnField>
                                <telerik:PivotGridAggregateField Aggregate="sum" DataField="TotalOS" UniqueName="TotalOS">
                                    <TotalFormat Level="0" Axis="Rows" TotalFunction="NoCalculation" SortOrder="Ascending">
                                    </TotalFormat>
                                </telerik:PivotGridAggregateField>
                                <telerik:PivotGridAggregateField Aggregate="sum" DataField="TargetAmount" UniqueName="TargetAmount">
                                    <TotalFormat Level="0" Axis="Rows" TotalFunction="NoCalculation" SortOrder="Ascending">
                                    </TotalFormat>
                                </telerik:PivotGridAggregateField>

                            </Fields>
                            <ConfigurationPanelSettings EnableDragDrop="False" EnableOlapTreeViewLoadOnDemand="True" />
                            <ExportSettings IgnorePaging="True" OpenInNewWindow="True" />
                        </telerik:RadPivotGrid>

CodeBehind


   Sub GetSummeryTarget()

        Dim col As String = "bank_nat_name,bank_name,TotalOS,TargetAmount,MONTHT,bank_logo,flag_logo"

        Dim ds As New DataSet : ds = GeneralUtilities.FillSql("select " + col + " from V_TargetDPviot ")


        RadPivotGrid3.DataSource = ds


    End Sub

    Private Sub RadPivotGrid3_NeedDataSource(sender As Object, e As PivotGridNeedDataSourceEventArgs) Handles RadPivotGrid3.NeedDataSource
        GetSummeryTarget()
    End Sub

ahmed
Top achievements
Rank 1
 asked on 29 Jun 2021
7 answers
215 views
Dear All,

Is that a possible way that I can pull the exact function of the "Refresh" as shown in the attachment?

Thank you and Regards.
Prof. Francisco Araújo
Top achievements
Rank 2
Iron
 answered on 22 Apr 2021
1 answer
80 views

Hello,

 

After a user configures their Pivotgrid to show the data the way they like it, I would like to get the resulting data into a data table for other uses like generating a chart off of the the resulting data.   It would be like the excel export function but export to a datatable in code behind.

Attila Antal
Telerik team
 answered on 25 Aug 2020
0 answers
34 views

I'm tring to remove the "(blank)" value from my columns values .

the field  "aircraft" has blank values and I want to ignore the blank column.

I've tried several things from code behind (working with vb.net) and nothing happens.

If I try filtering this field from the webpage, I get an error of :

"cannot convert object of type 'system.string' to type 'telerik.web.ui.pivotgrid.core.nullvalue'

<telerik:RadPivotGrid RenderMode="Lightweight" AllowPaging="true" PageSize="10" Height="500px"
              ID="RadPivotGrid1" runat="server" allowfiltering="true" emptyvalue="0">
              
              <Fields>
  
                  <telerik:PivotGridColumnField DataField="aircraft" showgroupwherenodata="false">
                  </telerik:PivotGridColumnField>
                  <telerik:PivotGridRowField DataField="Category" ZoneIndex="0">
                  </telerik:PivotGridRowField>
                  <telerik:PivotGridRowField DataField="ProductName" ZoneIndex="1">
                  </telerik:PivotGridRowField>
               
                  <telerik:PivotGridAggregateField DataField="emp_num" Aggregate="count" >
                  </telerik:PivotGridAggregateField>
                
              </Fields>
              <totalsettings rowgrandtotalposition="last"      />
          </telerik:RadPivotGrid>

 

DANA
Top achievements
Rank 1
Veteran
 asked on 01 Jun 2020
6 answers
97 views

There seems to be some format issues with the base Filter Window. It either does not show the save buttons without scrolling, and applying filters where the side menu pops out almost always requires scrolling. 

I can set a height or min height and that seems to help with seeing the buttons, but the slide out filter menu even with a min width or width sometimes requires scrolling. And sometimes (but not always) the filter box "blue area" in the screenshot widens to take up the entire window area.

Rumen
Telerik team
 answered on 26 May 2020
8 answers
296 views

Hi

 Im working with the radpivotgrid, i change some column names in the pivot in the CellDataBound event (like Kostadin explains in this example http://www.telerik.com/forums/edit-grandtotalcolumns-in-radpivotgrid) and works fine, the problem is when i try to export to an Excel file, all the data is exported fine, except the column names that i edited, the column names in the exported excel file dont have the changes i maded, and other thing, there is a way to hide the columns of a PivotGridAggregateField and show only the grand total of this same field?

Eyup
Telerik team
 answered on 26 Jul 2019
1 answer
143 views

Hello Team,

As soon as RadPivotGrid's width increase by 100 pixel, i should have horizontal scroll bar. but am not able to enable it. 

Could you let me know what is the property to be used in C# like:

  RadPivotGrid1.ClientSettings.Scrolling.AllowVerticalScroll = true;

 

Thanks,

Mohan Pal

Attila Antal
Telerik team
 answered on 20 May 2019
4 answers
37 views

Hello Team,

 

Am expecting PivotGrid to display value into following order 1, 2, 12 and then 1011 but PivotGrid is displaying them into 1, 1011, 12 and then 2.

How can this be fixed?

 

Thanks,

Mohan

 

Attila Antal
Telerik team
 answered on 15 May 2019
Narrow your results
Selected tags
Tags
+? more
Top users last month
horváth
Top achievements
Rank 2
Iron
Iron
Steve
Top achievements
Rank 2
Iron
Erkki
Top achievements
Rank 1
Iron
Mark
Top achievements
Rank 2
Iron
Iron
Veteran
Jakub
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Top users last month
horváth
Top achievements
Rank 2
Iron
Iron
Steve
Top achievements
Rank 2
Iron
Erkki
Top achievements
Rank 1
Iron
Mark
Top achievements
Rank 2
Iron
Iron
Veteran
Jakub
Top achievements
Rank 1
Iron
Want to show your ninja superpower to fellow developers?
Want to show your ninja superpower to fellow developers?