Questions on UI for ASP.NET AJAX Forum

0 answers

110 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

PivotGrid

updated question on 03 Oct 2023

3 answers

177 views

How to save and retrieve Radpivotgrid Layout from sql server

Hi All,

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

PivotGrid

updated answer on 11 Apr 2023

0 answers

134 views

radpivotgrid with CellTemplate Image

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

PivotGrid

asked on 29 Jun 2021

7 answers

335 views

How to trigger "Refresh" programmatically?

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.

PivotGrid

answered on 22 Apr 2021

1 answer

123 views

Get Resulting pivotgrid data into a new datatable to feed a chart

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.

PivotGrid

answered on 25 Aug 2020

0 answers

81 views

filtering (blank) from columnfield

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>

PivotGrid

asked on 01 Jun 2020

6 answers

155 views

Filter Window Values Cutoff

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.

PivotGrid

answered on 26 May 2020

8 answers

387 views

Radpivotgrid Export problem

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?

PivotGrid