Hi,

after creating the columns and the DataGridCollectionView, I add a simple SumFunction to the StatFunctions:

 

Xceed.Wpf.DataGrid.Stats.SumFunction sf = new Xceed.Wpf.DataGrid.Stats.SumFunction("AfterTaxSum", "AfterTax");

_dataGridCollectionView.StatFunctions.Add(sf);

 

My XAML contains a TextBox

 

<TextBox x:Name="txtSum1" />

 

How do I bind the TextProperty of txtSum1 to the AfterTaxSum-function?

 

I do not have/want a StatRow/StatCell in the grid.

 

Looking at the examples in the documentation I tried

 

Text="{Binding Path=StatContext.AfterTaxSum,ElementName=myGrid}"

 

That does not work.

Also, I tried to do the binding in code

 

NewBinding = new Binding("StatContext.AfterTaxSum");

NewBinding.Mode = BindingMode.OneWay;

NewBinding.Source = myGrid;

txtSum1.SetBinding(TextBox.TextProperty, NewBinding);

 

That doesn't work either.

 

Last idea I have is using the static method GetStatContext, but I do not know which

element to provicde to the parameter of this function.

 

Any hints on how to get this working?

 

Michael.

 

What exactly is not working? Is it possible that you have binding errors in your output window? StatContext is a readonly attached property, hence the GetStatContext method.

---

Technical Writer - Xceed Software

Of all the things I've lost, I miss my mind the most. - Mark Twain

Hi Jenny,

 

yes I do get binding errors in the output window.

I would like to know how to properly use the GetStatContext-Method.

Do you have an example?

 

Greetings,

Michael.

 

The Stat Functions topic in the documentation provides examples of how to use the StatContext attached property.

---

Technical Writer - Xceed Software

Of all the things I've lost, I miss my mind the most. - Mark Twain

And which example do you mean?

There should be 4 examples, but only 2 and 4 actually contain any code.

Examples 1 and 3 are empty.

 

Michael.

 

Example 3 clearly demonstrates how to use the StatContext attached property. Here is the example (I will fix the documentation) 

<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>
  <xcdg:DataGridControl x:Name="OrderDetailsGrid"
                        ItemsSource="{Binding Source={StaticResource cvs_orderdetails}}">
    <xcdg:DataGridControl.DefaultGroupConfiguration>
      <xcdg:GroupConfiguration>
        <xcdg:GroupConfiguration.Footers>
          <xcdg:GroupHeaderFooterItemTemplate VisibleWhenCollapsed="True">
            <DataTemplate>
              <Border Background="#999999"
                      BorderBrush="LightBlue"
                      BorderThickness="3"
                      Margin="5" >
                <Grid>
                  <Grid.ColumnDefinitions>
                    <ColumnDefinition/>
                    <ColumnDefinition/>
                  </Grid.ColumnDefinitions>
                  <Grid.RowDefinitions>
                    <RowDefinition/>
                    <RowDefinition/>
                    <RowDefinition/>
                    <RowDefinition/>
                  </Grid.RowDefinitions>
                  <TextBlock Text="Total Orders: " Grid.Row="0" Grid.Column="0"/>
                   <TextBlock Text="{Binding RelativeSource={RelativeSource Self},
                                             Path=(xcdg:DataGridControl.StatContext).orderid_count}"
                              Grid.Row="0" Grid.Column="1"/>                   
                    <TextBlock Text="Total Quantity Sold: " Grid.Row="1" Grid.Column="0"/>
                   <TextBlock Text="{Binding RelativeSource={RelativeSource Self},
                                   Path=(xcdg:DataGridControl.StatContext).quantity_sum}"
                                   Grid.Row="1" Grid.Column="1"/> 
                    <TextBlock Text="Total Sales: " Grid.Row="2" Grid.Column="0"/>
                   <TextBlock Text="{Binding RelativeSource={RelativeSource Self},
                                             Path=(xcdg:DataGridControl.StatContext).unitprice_sum}"
                              Grid.Row="2" Grid.Column="1"/> 
                    <TextBlock Text="Average Unit Price: " Grid.Row="3" Grid.Column="0"/>
                   <TextBlock Text="{Binding RelativeSource={RelativeSource Self},
                                             Path=(xcdg:DataGridControl.StatContext).unitprice_average,
                                             Converter={StaticResource valueConverter},
                                             ConverterParameter=f2}"
                              Grid.Row="3" Grid.Column="1"/>        
                  </Grid>
                </Border>
              </DataTemplate> 
            </xcdg:GroupHeaderFooterItemTemplate>
          </xcdg:GroupConfiguration.Footers>
        </xcdg:GroupConfiguration>
      </xcdg:DataGridControl.DefaultGroupConfiguration>
    </xcdg:DataGridControl>
  </Grid>

---

Technical Writer - Xceed Software

Of all the things I've lost, I miss my mind the most. - Mark Twain