This is a migrated thread and some comments may be shown as answers.

How to get the aggregate colum value

5 Answers 164 Views

General Discussions

This is a migrated thread and some comments may be shown as answers.

This question is locked. New answers and comments are not allowed.

Shirley asked on 29 Dec 2011, 04:40 AM

HI,
I am using RadControls for Silverlight Q1 2011 SP1.I have a problem to get the value of aggregate colum. I want to print the dategrid, but don't know how tho get the value of aggregate colum , i don't want to calculate again manually.
Any Help?
Thanks!
my code is like this:

<CODE style="COLOR: #000">

<Rad:CEnjoyRadDataGrid

AutoGenerateColumns="False" 

ShowGroupPanel="False"

 

x:Name="dgg"

 

Margin="0" 

ScrollMode="RealTime"

 

DataLoadMode="Synchronous"

 

EnableRowVirtualization="True" 

RowIndicatorVisibility="Collapsed" 

EditTriggers="CellClick" 

BorderThickness="1"

 

ShowColumnFooters="True" 

> 

<telerik:RadGridView.Columns> 

<telerik:GridViewDataColumn DataMemberBinding="{Binding

c_sort,Mode=TwoWay}" 

Header="sort" 

Width="40" 

IsReadOnly="True" 

TextWrapping="Wrap"

/> 

<Rad:EnjoyItCombinSelTempelteColumn DataMemberBinding="{Binding

c_gcode,Mode=TwoWay}" 

Header="code" 

IsReadOnly="False" 

SelectType="SLGds" 

EditValue="c_gcode" 

UniqueName="c_gcode" 

Width="100" 

TextWrapping="Wrap" 

FooterTextAlignment="Center"> 

<Rad:EnjoyItCombinSelTempelteColumn.Footer> 

<TextBlock Text="sum:" HorizontalAlignment="Center"

/> 

</Rad:EnjoyItCombinSelTempelteColumn.Footer> 

</Rad:EnjoyItCombinSelTempelteColumn>

<Rad:EnjoyItDataGridTextColumn Header="name"

 

Width="170" 

IsReadOnly="True" 

DataMemberBinding="{Binding

c_name,Mode=OneWay}"> 

</Rad:EnjoyItDataGridTextColumn>

<Rad:EnjoyItDataGridTextColumn Header="barcode"

 

Width="110"

 

IsReadOnly="True" 

DataMemberBinding="{Binding

c_barcode,Mode=TwoWay}"> 

</Rad:EnjoyItDataGridTextColumn> 

<Rad:EnjoyItTextRoomNumColumn Header="num" TextAlignment="Right"

 

Width="80" 

FooterTextAlignment="Right" 

DataMemberBinding="{Binding c_number,Mode=TwoWay,Converter={StaticResource

DecimalConvert}}"> 

<telerik:GridViewDataColumn.AggregateFunctions> 

<telerik:SumFunction Caption="sum:" ResultFormatString="{}{0:#,###.00}"

SourceField="c_number"

/> 

</telerik:GridViewDataColumn.AggregateFunctions> 

<telerik:GridViewDataColumn.Footer> 

<telerik:AggregateResultsList ItemsSource="{Binding}"

VerticalAlignment="Center"

Grid.Column="4"> 

<ItemsControl.ItemTemplate> 

<DataTemplate> 

<TextBlock VerticalAlignment="Center" HorizontalAlignment="Right"

Text="{Binding FormattedValue, StringFormat=n}"

TextAlignment="Right"/><BR>

</DataTemplate> 

</ItemsControl.ItemTemplate> 

</telerik:AggregateResultsList> 

</telerik:GridViewDataColumn.Footer> 

</Rad:EnjoyItTextRoomNumColumn> </telerik:RadGridView.Columns> 

</Rad:CEnjoyRadDataGrid></CODE>

5 Answers, 1 is accepted

Accepted

answered on 29 Dec 2011, 11:03 AM

Hi,

I guess that you are following our online example about printing. You may extend the CreateDocument(RadGridView grid) method to print the aggregates like so:

if (grid.ShowColumnFooters)

{

TableRow footerRow = new TableRow();

for (int j = 0; j < columns.Count(); j++)

{

TableCell cell = new TableCell();

string value = "";

foreach (AggregateFunction f in columns[j].AggregateFunctions)

{

value += grid.AggregateResults[f.FunctionName].Caption + grid.AggregateResults[f.FunctionName].FormattedValue.ToString();

}

AddCellValue(cell, value);

cell.PreferredWidth = newTableWidthUnit((float)columns[j].ActualWidth);

cell.Background = SystemColors.MenuColor;

footerRow.Cells.Add(cell);

}

table.Rows.Add(footerRow);

I believe that this is what you need.

All the best,
Didie
the Telerik team

Explore the entire Telerik portfolio by downloading the Ultimate Collection trial package. Get it now >>

answered on 31 Dec 2011, 06:31 AM

before-scroll-the-horizontal-scroll-bar.jpg

After-scroll-the-horizontal-scroll-bar.jpg

Thanks a lot, it works!
Another Question: when I scroll the horizontal scroll bar, sometime the data in the DataGrid will lost. The lost data just don't display in the DataGrid, it exists in the datasource of the DataGrid.
Can you give me any suggestion?
Thanks in advance.
Shirley