Represents a cell contained in a StatRow that can display the results of a statistical function. This feature is available only in the Professional Edition

This feature is available only in the Professional Edition

Object Model

Syntax

Visual Basic (Declaration)
Public Class StatCell Inherits Cell Implements INotifyPropertyChanged, ISupportInitialize, IFrameworkInputElement, IInputElement, IAddChild, IHaveResources, IAnimatable, DUCE.IResource

C#
public class StatCell : Cell, INotifyPropertyChanged, ISupportInitialize, IFrameworkInputElement, IInputElement, IAddChild, IHaveResources, IAnimatable, DUCE.IResource

Example

All examples in this topic assume that the grid is bound to the Orders table of the Northwind database, unless stated otherwise.

The following example demonstrates how to display the results of various statistical functions in and outside of a grid.

XAML Copy Code

XAML	Copy Code
<Grid xmlns:xcdg="http://schemas.xceed.com/wpf/xaml/datagrid"> <Grid.Resources> <xcdg:DataGridCollectionViewSource x:Key="cvs_orderdetails" Source="{Binding Source={x:Static Application.Current}, Path=OrderDetails}"> <xcdg:DataGridCollectionViewSource.StatFunctions> <xcdg:CountFunction ResultPropertyName="orderid_count" SourcePropertyName="OrderID"/> <xcdg:SumFunction ResultPropertyName="unitprice_sum" SourcePropertyName="UnitPrice"/> <xcdg:AverageFunction ResultPropertyName="unitprice_average" SourcePropertyName="UnitPrice"/> <xcdg:SumFunction ResultPropertyName="quantity_sum" SourcePropertyName="Quantity"/> </xcdg:DataGridCollectionViewSource.StatFunctions> <xcdg:DataGridCollectionViewSource.GroupDescriptions> <xcdg:DataGridGroupDescription PropertyName="ProductID"/> </xcdg:DataGridCollectionViewSource.GroupDescriptions> </xcdg:DataGridCollectionViewSource> <xcdg:StatResultConverter x:Key="valueConverter"/> </Grid.Resources> <DockPanel> <StackPanel Orientation="Horizontal" DockPanel.Dock="Top"> <TextBlock Text="Total Orders: "/> <TextBlock Text="{Binding ElementName=OrderDetailsGrid, Path=StatContext.orderid_count}"/> </StackPanel> <StackPanel Orientation="Horizontal" DockPanel.Dock="Top"> <TextBlock Text="Average Unit Price: "/> <TextBlock Text="{Binding ElementName=OrderDetailsGrid, Path=StatContext.unitprice_average, Converter={StaticResource valueConverter}, ConverterParameter=f2}"/> </StackPanel> <xcdg:DataGridControl x:Name="OrderDetailsGrid" ItemsSource="{Binding Source={StaticResource cvs_orderdetails}}" DockPanel.Dock="Bottom"> <xcdg:DataGridControl.DefaultGroupConfiguration> <xcdg:GroupConfiguration> <xcdg:GroupConfiguration.Footers> <DataTemplate> <xcdg:StatRow> <xcdg:StatCell FieldName="UnitPrice" ResultPropertyName="unitprice_sum"/> <xcdg:StatCell FieldName="Quantity" ResultPropertyName="quantity_sum"/> <xcdg:StatCell FieldName="OrderID" ResultPropertyName="orderid_count"/> <xcdg:StatCell FieldName="UnitPrice" ResultPropertyName="unitprice_average" ResultConverterParameter="f2"/> </xcdg:StatRow> </DataTemplate> </xcdg:GroupConfiguration.Footers> </xcdg:GroupConfiguration> </xcdg:DataGridControl.DefaultGroupConfiguration> </xcdg:DataGridControl> </DockPanel> </Grid>

<Grid xmlns:xcdg="http://schemas.xceed.com/wpf/xaml/datagrid"> 
  <Grid.Resources> 
    <xcdg:DataGridCollectionViewSource x:Key="cvs_orderdetails" 
                                       Source="{Binding Source={x:Static Application.Current}, 
                                                        Path=OrderDetails}"> 
     <xcdg:DataGridCollectionViewSource.StatFunctions> 
       <xcdg:CountFunction ResultPropertyName="orderid_count" 
                           SourcePropertyName="OrderID"/> 
       <xcdg:SumFunction ResultPropertyName="unitprice_sum" 
                         SourcePropertyName="UnitPrice"/> 
       <xcdg:AverageFunction ResultPropertyName="unitprice_average" 
                             SourcePropertyName="UnitPrice"/> 
       <xcdg:SumFunction ResultPropertyName="quantity_sum" SourcePropertyName="Quantity"/> 
     </xcdg:DataGridCollectionViewSource.StatFunctions> 
     <xcdg:DataGridCollectionViewSource.GroupDescriptions> 
       <xcdg:DataGridGroupDescription PropertyName="ProductID"/>       
 </xcdg:DataGridCollectionViewSource.GroupDescriptions> 
    </xcdg:DataGridCollectionViewSource> 
   <xcdg:StatResultConverter x:Key="valueConverter"/> 
  </Grid.Resources> 
  <DockPanel> 
    <StackPanel Orientation="Horizontal" DockPanel.Dock="Top"> 
      <TextBlock Text="Total Orders: "/> 
      <TextBlock Text="{Binding ElementName=OrderDetailsGrid, 
                 Path=StatContext.orderid_count}"/> 
    </StackPanel> 
     <StackPanel Orientation="Horizontal" DockPanel.Dock="Top"> 
       <TextBlock Text="Average Unit Price: "/> 
     <TextBlock Text="{Binding ElementName=OrderDetailsGrid, 
                        Path=StatContext.unitprice_average, 
                        Converter={StaticResource valueConverter}, 
                        ConverterParameter=f2}"/> 
    </StackPanel> 
    <xcdg:DataGridControl x:Name="OrderDetailsGrid" 
                          ItemsSource="{Binding Source={StaticResource cvs_orderdetails}}" 
                          DockPanel.Dock="Bottom"> 
      <xcdg:DataGridControl.DefaultGroupConfiguration> 
        <xcdg:GroupConfiguration>  
        <xcdg:GroupConfiguration.Footers> 
           <DataTemplate> 
               <xcdg:StatRow> 
               <xcdg:StatCell FieldName="UnitPrice" 
                                   ResultPropertyName="unitprice_sum"/> 
               <xcdg:StatCell FieldName="Quantity" ResultPropertyName="quantity_sum"/> 
               <xcdg:StatCell FieldName="OrderID" ResultPropertyName="orderid_count"/> 
               <xcdg:StatCell FieldName="UnitPrice" 
                              ResultPropertyName="unitprice_average" 
                              ResultConverterParameter="f2"/> 
             </xcdg:StatRow> 
           </DataTemplate> 
         </xcdg:GroupConfiguration.Footers> 
        </xcdg:GroupConfiguration> 
      </xcdg:DataGridControl.DefaultGroupConfiguration>     
    </xcdg:DataGridControl> 
  </DockPanel> 
</Grid>

Remarks

To display the results of a statistical function it is suggested to set the ResultPropertyName of the StatCell rather than binding the content.

Although the result of a statistical function can be displayed in other elements (e.g., TextBlock), using a StatRow allows the results of statistical functions to be arranged in a similar fashion as the other cells in a grid.

Inheritance Hierarchy

System.Object
   System.Windows.Threading.DispatcherObject
      System.Windows.DependencyObject
         System.Windows.Media.Visual
            System.Windows.UIElement
               System.Windows.FrameworkElement
                  System.Windows.Controls.Control
                     System.Windows.Controls.ContentControl
                        Xceed.Wpf.DataGrid.Cell
                           Xceed.Wpf.DataGrid.StatCell

Requirements

Supported Operating Systems: Windows Server 2003 Service Pack 1; Windows Vista; Windows XP Service Pack 2

Object Model

Syntax

Example

Remarks

Inheritance Hierarchy

Requirements

See Also

Reference

Basic Concepts