GroupFootersVisibility Property

Visual Basic (Declaration)
Visual Basic (Usage)
C#
C++/CLI

<CategoryAttribute("Layout")>
Public Property GroupFootersVisibility As Visibility

Dim instance As UXGridView
Dim value As Visibility
 
instance.GroupFootersVisibility = value
 
value = instance.GroupFootersVisibility

[CategoryAttribute("Layout")]
public Visibility GroupFootersVisibility {get; set;}

[CategoryAttribute("Layout")]
public:
property Visibility GroupFootersVisibility {
   Visibility get();
   void set (    Visibility value);
}

UXGridView supports data aggregate in both the column and group level. To display aggregate values of a UXGridViewBoundColumn at group level, you set the GroupFootersVisibility property to Visible and specify the Aggregate property to one of the predefined value. You can also specify the string format to apply to the aggregate value by setting the GroupFooterFormatString property. If not specified, the aggregate value will be formatted using the value specified in the FooterFormatString property.

XAML	Copy Code
<Intersoft:UXGridView GroupFooterVisibility="Visible" GroupByBoxVisibility="Visible" CanUserGroupColumns="True" ItemsSource="{Binding Products}" > <Intersoft:UXGridView.Columns> <Intersoft:UXGridViewTextColumn Header="Category ID" Binding="{Binding CategoryID}"/> <Intersoft:UXGridViewTextColumn Header="Product ID" Binding="{Binding ProductID}" Aggregate="Count" FooterFormatString="Count = {0}"/> <Intersoft:UXGridViewTextColumn Header="Product Name" Binding="{Binding ProductName}"/> <Intersoft:UXGridViewTextColumn Header="Units In Stock" Binding="{Binding UnitsInStock}" Aggregate="Max" FooterFormatString="Max = {0}"/> <Intersoft:UXGridViewTextColumn Header="Unit Price" Binding="{Binding UnitPrice}" Aggregate="Avg" FooterFormatString="Avg = {0:n2}"/> <Intersoft:UXGridViewTextColumn Header="Units On Order" Binding="{Binding UnitsOnOrder}" Aggregate="Min" FooterFormatString="Min = {0}"/> <Intersoft:UXGridViewTextColumn Header="Quantity Per Unit" Binding="{Binding QuantityPerUnit}"/> </Intersoft:UXGridView.Columns> </Intersoft:UXGridView>

XAML

Copy Code

<Intersoft:UXGridView GroupFooterVisibility="Visible" GroupByBoxVisibility="Visible" CanUserGroupColumns="True" ItemsSource="{Binding Products}" >
    <Intersoft:UXGridView.Columns>
        <Intersoft:UXGridViewTextColumn Header="Category ID" Binding="{Binding CategoryID}"/>
        <Intersoft:UXGridViewTextColumn Header="Product ID" Binding="{Binding ProductID}" Aggregate="Count" FooterFormatString="Count = {0}"/>
        <Intersoft:UXGridViewTextColumn Header="Product Name" Binding="{Binding ProductName}"/>
        <Intersoft:UXGridViewTextColumn Header="Units In Stock" Binding="{Binding UnitsInStock}" Aggregate="Max" FooterFormatString="Max = {0}"/>
        <Intersoft:UXGridViewTextColumn Header="Unit Price" Binding="{Binding UnitPrice}" Aggregate="Avg" FooterFormatString="Avg = {0:n2}"/>
        <Intersoft:UXGridViewTextColumn Header="Units On Order" Binding="{Binding UnitsOnOrder}" Aggregate="Min" FooterFormatString="Min = {0}"/>
        <Intersoft:UXGridViewTextColumn Header="Quantity Per Unit" Binding="{Binding QuantityPerUnit}"/>
    </Intersoft:UXGridView.Columns>
</Intersoft:UXGridView>

You can also set multiple values on the Aggregate property such as shown in the following example.

XAML	Copy Code
<Intersoft:UXGridViewTextColumn Header="Unit Price" Binding="{Binding UnitPrice}" Aggregate="Avg,Max,Min" FooterFormatString="Avg = {0} \| Max = {0} \| Min = {0}"/>

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

Reference

UXGridView Class
UXGridView Members