[Solved] Show Text Field in Place of Numeric

[Neil N]

Example dataset:

Company	Material	Collected
A	Stone	1
A	Wood	0
A	Marble	1
A	Plastic	1
B	Stone	0
B	Wood	0
B	Marble	0
B	Plastic	1
C	Stone	1
C	Wood	1
C	Marble	1
C	Plastic	1

Is it possible to show "Yes" for 1 and "No" for 0 while still retaining aggregate functionality?  Basically, the aggregate should be a sum which is a count of "Yes".

[Daniel]

Hello Neil,

A possible approach is shown below:

<telerik:RadGrid ID="RadGrid1" runat="server" ShowFooter="true">
    <MasterTableView>
        <Columns>
            <telerik:GridTemplateColumn DataField="Bfield" HeaderText="Bfield" UniqueName="Bfield"
                Aggregate="Count">
                <ItemTemplate>
                    <%# ((bool)Eval("Bfield")) ? "Yes" : "No"  %>
                </ItemTemplate>
            </telerik:GridTemplateColumn>
        </Columns>
    </MasterTableView>
</telerik:RadGrid>

Let me know whether this way is suitable for you.

Regards,
Daniel
the Telerik team

[Neil N]

This is the PivotGrid forum. I'm using a PivotGrid.

[Daniel]

Hello Neil,

Excuse me for this omission. Working with RadPivotGrid templates is quite similar to RadGrid and the other databound controls. The only difference is that you don't have to use Eval. Just write Container.DataItem and then cast the result to the underlying type.

<telerik:PivotGridAggregateField DataField="YourDataField">
    <CellTemplate>
        <%# (YourType)Container.DataItem == 0 ? "Yes" : "No"  %>
    </CellTemplate>
</telerik:PivotGridAggregateField>

I doubt however, that the aggregated data will return only 1 and 0 as there are not many cases (for example you can have bit field with min/max aggregate) where this would happen.

Best regards,
Daniel
the Telerik team

[Neil N]

Thanks, adapting your example to VB.NET works great.

<CellTemplate><%# IIf(CBool(Container.DataItem), "Yes", "No")%></CellTemplate>

[Daniel]

Hello Neil,

I'm glad to hear that you have managed to achieve this functionality. You may also want to examine our online resources:
How to Customize Telerik's ASP.NET PivotGrid Cells Using the Built-in Templates blog post
PivotGrid Templates documentation
PivotGrid Templates example

Best regards,
Daniel
the Telerik team