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

Aggregate Result Display

29 Answers 501 Views

GridView

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

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

29 Answers, 1 is accepted

Accepted

answered on 03 Dec 2010, 04:06 PM

Hello Matthew Calhoun,

You may use the ShowHeaderAggregates Property and set it to "False". You may either set it as an implicit style targeting all grids:

<Grid.Resources>

<Style TargetType="telerik:GridViewGroupRow">

<Setter Property="ShowHeaderAggregates" Value="False"/>

</Style>

</Grid.Resources>

Or define it explicitly using the GroupRowStyle property of the grid:

<Grid.Resources>

<Style x:Key="MyGroupRowStyle" TargetType="telerik:GridViewGroupRow">

<Setter Property="ShowHeaderAggregates" Value="False"/>

</Style>

</Grid.Resources>

<telerik:RadGridView GroupRowStyle="{StaticResource MyCustomGroupRowStyle}">

All the best,
Maya
the Telerik team

Browse the videos here>> to help you get started with RadControls for Silverlight

answered on 03 Dec 2010, 04:38 PM

Thanks Maya!

Just for curiosity, is there a way to align the aggregrates to the proper columns?

So, when grouped by year and summing Cost and Price, instead of:

Year                                                    Cost        Price
Year 1 $100 $200

I would want:

Year                                                    Cost            Price
Year 1                                                 $100            $200

Thanks,
Matt

Accepted

answered on 03 Dec 2010, 04:58 PM

groupfooteringroupheader.zip

Hi Matthew Calhoun,

For the time being there is no straight forward way for achieving it. In order to get the desired view with aligned aggregates, you need to predefine the GridViewGroupRowStyle a bit. I am sending you a sample project illustrating the proposed solution.
However, we do have plans on introducing this feature as a native one, but I cannot specify any time frame for that.

Regards,
Maya
the Telerik team

Browse the videos here>> to help you get started with RadControls for Silverlight

answered on 12 Mar 2011, 05:20 AM

Hi,
nice workaround while waiting for a native version.

By changing slightly as follow we can even have the aggregates function aligned in the Group row even when expanded.
Just thought some might prefer this version as I do.

<Storyboard>

<ObjectAnimationUsingKeyFrames Storyboard.TargetProperty="(UIElement.Visibility)" Storyboard.TargetName="aggregateResultsList">

<DiscreteObjectKeyFrame KeyTime="0">

<DiscreteObjectKeyFrame.Value>

<Visibility>Collapsed</Visibility>

</DiscreteObjectKeyFrame.Value>

</DiscreteObjectKeyFrame>

</ObjectAnimationUsingKeyFrames>

<ObjectAnimationUsingKeyFrames Storyboard.TargetProperty="(UIElement.Visibility)" Storyboard.TargetName="toggleButton">

<DiscreteObjectKeyFrame KeyTime="0">

<DiscreteObjectKeyFrame.Value>

<Visibility>Visible</Visibility>

</DiscreteObjectKeyFrame.Value>

</DiscreteObjectKeyFrame>

</ObjectAnimationUsingKeyFrames>

<ObjectAnimationUsingKeyFrames Storyboard.TargetProperty="(UIElement.Visibility)" Storyboard.TargetName="PART_GridViewVirtualizingPanel">

<DiscreteObjectKeyFrame KeyTime="0">

<DiscreteObjectKeyFrame.Value>

<Visibility>Visible</Visibility>

</DiscreteObjectKeyFrame.Value>

</DiscreteObjectKeyFrame>

</ObjectAnimationUsingKeyFrames>

<ObjectAnimationUsingKeyFrames Storyboard.TargetProperty="(UIElement.Visibility)" Storyboard.TargetName="Footer">

<DiscreteObjectKeyFrame KeyTime="0">

<DiscreteObjectKeyFrame.Value>

<Visibility>Visible</Visibility>

</DiscreteObjectKeyFrame.Value>

</DiscreteObjectKeyFrame>

</ObjectAnimationUsingKeyFrames>

<DoubleAnimation Duration="0" To="-1" Storyboard.TargetProperty="(UIElement.RenderTransform).(CompositeTransform.ScaleY)" Storyboard.TargetName="ExpanderButton" d:IsOptimized="True"/>

</Storyboard>

Regards
Jean-Marc

answered on 21 Sep 2011, 07:16 AM

SilverlightApplication9.zip

Hi Fabien,

I have tried to reproduce the issue, but still without any success. Would you take a look at the sample attached to verify whether you can get the same behavior on it ?

Regards,
Maya
the Telerik team

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

answered on 21 Sep 2011, 02:39 PM

Hi Maya,

I don't see in your sample the "align the aggregrates to the proper columns" feature.
I use the code you provide in December, 2010 in this thread (attached file groupfooteringroupheader.zip) in my project to provide this feature.
In my project i have

StyleManager.ApplicationTheme = new Windows7Theme();
in the MainPage constructor. With that line, groupped rows doesn't expand anymore.
If i delete this line this works fine.
It seems that the GridViewGroupRowStyle you provide is theme-specific, so can you give me this style that works with window7theme ?
I'd be happy to do it if i had understood how you generate it (using blend ?)
Thx,

Fabien

answered on 22 Sep 2011, 04:47 PM

expectedResult.png

Hi,

Yes i have tried your sample. I thought you misunderstood my issue since your sample is not revelant because there is only one aggregate column and its the first. So it's hard to say if aggregates value in group headers are aligned with column header.
But i putted your code in my project and it's working fine now with window7 theme (All aggregates value appears under their column). Thanks.
But a issue remains : if i group by a column that contains text and doesn't have an aggregate function, this text doesn't appear in the group header. Any idea ?

You can check attached file for expected result. With your sample, nothing appear on first column.

I know that if you group by third Column (Phones), phone numbers in group headers will appear under "Name" Column, but i think it's better than not knowing the grouped value.

Thank you for your patience,

Fabien

answered on 23 Sep 2011, 12:20 PM

Hello Fabien,

If you take a look at the modified version of your project you may see a single ContentPresenter which Visibility is set to Collapsed. Once you remove this setting from the ContentPresenter's definition you would be able to see the Group keys as well:

<ToggleButton Grid.Column="1"

grid:SelectiveScrollingGrid.SelectiveScrollingOrientation="Vertical"

Background="Transparent" BorderThickness="0" BorderBrush="{x:Null}"

Style="{StaticResource GridViewGroupToggleButtonStyle}"

IsChecked="{Binding IsExpanded, Mode=TwoWay, RelativeSource={RelativeSource TemplatedParent}}" IsTabStop="{TemplateBinding IsTabStop}">

<ContentPresenter x:Name="contentPresenter" Grid.Column="1" Content="{TemplateBinding GroupViewModel}" ContentTemplate="{TemplateBinding GroupHeaderTemplate}"/>

</ToggleButton>

You may arrange this header in the way you need.
Hope this helps!

Kind regards,
Vanya Pavlova
the Telerik team

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

answered on 04 Oct 2011, 01:38 PM

groupedcolumn.jpg

Fabien -
One last question: If requested, were you able to resize the group column?
e.g., in the screen shot, resize the name column so it isn't 'on top' of the Company aggregate.
Almost there... :)
-M

answered on 05 Oct 2011, 10:43 AM

FYI - added this code to expand column so that grouped name is visible
The border lines are still in the way, especially if more than one group is added, but it works for now.

private void MyGridView_Grouping(object sender, GridViewGroupingEventArgs e)

{

//placing group or removing a group when there is more than one group already

if (e.Action == GroupingEventAction.Place || CurrentGridView.GroupCount > 1)

{

CurrentGridView.Columns[0].Width = 200;

}

else

{

CurrentGridView.Columns[0].Width = 25;

}

-M