radpivotgrid with CellTemplate Image

0 Answers 20 Views
PivotGrid
ahmed
Top achievements
Rank 1
ahmed asked on 29 Jun 2021, 12:33 PM

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
commented on 30 Jun 2021, 03:18 PM

can any one help

No answers yet. Maybe you can help?

Tags
PivotGrid
Asked by
ahmed
Top achievements
Rank 1
Share this question
or