Welcome to the Xceed Community | Help
Community Search  
More Search Options

Displaying statistical functions

Sort Posts: Previous Next
  •  10-08-2008, 4:07 PM Post no. 28140

    Displaying statistical functions

    The following example demonstrates how to display the results of various statistical functions in and outside of a 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: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:StatRow>
               </DataTemplate>
             </xcdg:GroupConfiguration.Footers>
            </xcdg:GroupConfiguration>
          </xcdg:DataGridControl.DefaultGroupConfiguration>   
        </xcdg:DataGridControl>
      </DockPanel>
    </Grid>

View as RSS news feed in XML
Contact | Site Map | Reviews | Legal Terms of Use | Trademarks | Privacy Statement Copyright 2011 Xceed Software Inc.