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

RadGridView aggregate results in group header show wrong values after group expansion and scrolling

12 Answers 260 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.

Messir asked on 30 Jul 2012, 06:49 AM

I use RadGridView in my Silverlight application. I have data grouped and aggregate function results for each group displayed in group headers. When I expand any group and then contract it back, aggregate results are displayed correctly. However, if I expand a group and then SCROLL down, the aggregate results in the groups below the expanded one get shuffled and show values for the other groups.Here's my binding of the TextBox elements in the group header to the aggregate function results:

 <telerik:RadGridView.GroupHeaderTemplate>
                        <DataTemplate>
                            <StackPanel Orientation="Horizontal" 
                                        VerticalAlignment="Center">      
                                   ................................
                                 
 
                                <TextBlock Name="groupTotal" Text="{Binding AggregateResults[0].Value, BindsDirectlyToSource=True,
                                                          StringFormat=Total: \{0:c\}}"   
                                           FontSize="12"
                                           Foreground="DarkViolet"/>
 
                                <TextBlock Name="txtSpacer9"
                                           Text="   "
                                           VerticalAlignment="Center"/>
 
 
                                <TextBlock Name =" groupApproved" Text="{Binding AggregateResults[1].Value, BindsDirectlyToSource=True,
                                                          StringFormat=Approved: \{0:c\}}" 
                                                  FontSize="12"
                                                  Foreground="Green"/>
                            </StackPanel>
                        </DataTemplate>
                    </telerik:RadGridView.GroupHeaderTemplate>

I create aggregate functions in this method:
 private void AddAggregateFunctions()
        {
            var aggregateFunction = new AggregateFunction<EmployeeExpenseReimbursementObject, double>{};
 
            Func<EmployeeExpenseReimbursementObject, bool> argument = 
                obj => obj.CorpApprovalStatusID == 5 || obj.CorpApprovalStatusID == 8;
 
            ////////////////////Miles///////////////////////////////////////////////////////////////////////////
            aggregateFunction = new AggregateFunction<EmployeeExpenseReimbursementObject, double>
            {
                 AggregationExpression = approvedItems => 
                     approvedItems.Where(argument).Sum(c => c.Miles.ExpenseSubmittedTotal.Value),
                 Caption = "Approved: ",
                 ResultFormatString = "{0:c}"
            };
            gvExpenses.Columns["MilesExpense"].AggregateFunctions.Add(aggregateFunction);    
        }

and then call it in the window constructor:

         AddGgregateFunctions();

Please help me understand what's wrong! I urgently need this working properly!

12 Answers, 1 is accepted

answered on 08 Aug 2012, 04:44 PM

Hi Messir,

We are going to fix this for our further versions . However you said you are using an older version so you can not benefit from a fix:

Here is a small workaround I have tested and found working for your case:
Instead of binding to the AggregateResults in the context , you can fetch them from the parent group :

Such as :

<telerik:RadGridView.GroupHeaderTemplate>

<DataTemplate>

<StackPanel Orientation="Horizontal" >

<TextBlock Text="{Binding AggregateResults[0].Value, RelativeSource={RelativeSource AncestorType=telerik:GridViewGroupRow}}"

FontSize="12"

Foreground="DarkViolet"/>

</StackPanel>

</DataTemplate>

</telerik:RadGridView.GroupHeaderTemplate>

Kind regards,
Pavel Pavlov
the Telerik team

Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

answered on 28 Nov 2012, 09:46 AM

Step1.jpg

Step-4.jpg

Hi,

I just upgraded to the trial version of Q3 2012 and it seems like the problem is gone. However, I observe another funny behavior that intereferes with my attempts to finalize the application.

Now, I load the RadGridView, where the group headers have a TextBlock with a name and four checkboxes. Depending on the value of the field in the row business object, chekboxes may be checked or unchecked. If L1 checkbox is checked, the name textbox is green (see attached step 1.jpg, name's Donellan, Paul).

When I expand a group above (Patterson, Barbara), the grid extends down and becomes scrollable. If I scroll down to see Donellan group rows, the group header still has checkboxes correctly checked and the text is green. However, if I collapse the group for Patterson, the Donellan group is no longer green and checkboxes are unchecked, and the group header down below for Bell, Tracy has green text and checked checkboxes, which is wrong. If I reload the page, it is normal again.

So, somehow, when I scroll the grid while a group is extended, the text name and checkbox values travel to another group header. This is similar to previously seen problem with aggregate values, but now group header row controls are involved. Please help me ASAP, as I urgently need to complete this app and I'm considering buying the Q3 2012 version.

Here's the code that colors the name text block and checks the checkboxes in the group header:

 private void txtGroupKey_Loaded(object sender, RoutedEventArgs e)
        {
            TextBlock txtGroupKey = sender as TextBlock;
            GridViewGroupRow row = txtGroupKey.GetVisualParent<GridViewGroupRow>();
 
            if (row != null && row.Group.ItemCount > 0)
            {
                foreach (AdminExpenseListObject obj in row.Group.Items)
                {
                    if (obj.L1ApprovalStatusID == 5)
                    {
                        SolidColorBrush brush = new SolidColorBrush(Colors.Green);  
                        FontWeight weight = FontWeights.Bold;
 
                        txtGroupKey.Foreground = brush;
                        txtGroupKey.FontWeight = weight;
                        break;                        
                    }
                }
            }
 
        }

   private void chkL1All_Loaded(object sender, RoutedEventArgs e)
        {
            CheckBox chk = sender as CheckBox;
            GridViewGroupRow row = chk.GetVisualParent<GridViewGroupRow>();
 
            chk.IsChecked = true;
 
            chk.BorderThickness = new Thickness(2.0);
 
            //Prevent using if not L1 
            if (!WebContext.Current.User.Roles.Contains("Level 1 Supervisor"))
            {
                chk.IsEnabled = false;
            }
           
            ToolTipService.SetToolTip(chk, "Withdraw L1 approval for ALL expenses");
 
            if (row != null && row.Group.ItemCount > 0)
            {
                foreach (AdminExpenseListObject obj in row.Group.Items)
                {
                    //Prevent approval of a non-submitted report
                    if (obj.EmployeeExpenseProcessingStatusID < 3)
                    {
                        chk.IsChecked = false;
                        chk.IsEnabled = false;
                        ToolTipService.SetToolTip(chk, "This expense report has not been submitted. Approval cannot be done.");
                        break;
                    }
                    else if (obj.L1ApprovalStatusID == 4)
                    {
                        chk.IsChecked = false;
                        ToolTipService.SetToolTip(chk, "Approve ALL expenses");
                        break;
                    }
                    else if (obj.L1ApprovalStatusID == 9)
                    {
                        chk.IsChecked = false;
                        ToolTipService.SetToolTip(chk, "Approval not required");
                        chk.IsEnabled = false;
                        break;
                    }                    
                }               
            }
        }




Thanks a lot