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
can any one help