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
Hi All,
Can any one let me know how to save and retrieve the layout settings from SQL server .
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
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.
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
>
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.
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?
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
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