This is a migrated thread and some comments may be shown as answers.
Multiple Grid Groupings and Aggregates not working since upgrade (2012.1.411.40)
8 Answers 35 Views
This is a migrated thread and some comments may be shown as answers.
CodeR
Top achievements
Rank 2
CodeR asked on 30 Apr 2012, 01:35 AM
Since upgrading to 2012.1.411.40 I have problem with grids that have multiple group by expressions that have a Header String which aggregates sub totals.

When the grid displays the First Header Grouping of every group level in the Grid does not display correctly. Instead of building up a dynamic string header it instead displays a non dynamic header such as 'Total Charged: {0:c2}'. Subsequent sub-grouping though work.

Here is an example of the type of Group By Expressions used;

<GroupByExpressions>
                        <telerik:GridGroupByExpression>
                            <SelectFields>
                                <telerik:GridGroupByField HeaderValueSeparator=": " FieldAlias="Client" FieldName="ClientName" />
                                <telerik:GridGroupByField HeaderValueSeparator=": " HeaderText="Hrs Spent" FieldAlias="HrsSpent"
                                    FieldName="TimeSpent" FormatString="{0:N1}" Aggregate="Sum" />
                                <telerik:GridGroupByField HeaderValueSeparator=": " HeaderText="Total Charged" FieldAlias="TotalCharged"
                                    FieldName="WorksheetAmount" FormatString="{0:c2}" Aggregate="Sum" />
                                <telerik:GridGroupByField HeaderValueSeparator=" " HeaderText=" " FieldAlias="ClientID"
                                    FieldName="ClientID" FormatString=" " />
                            </SelectFields>
                            <GroupByFields>
                                <telerik:GridGroupByField FieldName="ClientName" SortOrder="Ascending" />
                            </GroupByFields>
                        </telerik:GridGroupByExpression>
                        <telerik:GridGroupByExpression>
                            <SelectFields>
                                <telerik:GridGroupByField HeaderValueSeparator=": " FieldAlias="Project" FieldName="ProjectTitle" />
                                <telerik:GridGroupByField HeaderValueSeparator=": " HeaderText="Hrs Spent" FieldAlias="HrsSpent"
                                    FieldName="TimeSpent" FormatString="{0:N1}" Aggregate="Sum" />
                                <telerik:GridGroupByField HeaderValueSeparator=": " HeaderText="Total Charged" FieldAlias="TotalCharged"
                                    FieldName="WorksheetAmount" FormatString="{0:c2}" Aggregate="Sum" />
                                <telerik:GridGroupByField HeaderValueSeparator=" " HeaderText=" " FieldAlias="ProjectID"
                                    FieldName="ProjectID" FormatString=" " />
                            </SelectFields>
                            <GroupByFields>
                                <telerik:GridGroupByField FieldName="ProjectTitle" SortOrder="Ascending" />
                            </GroupByFields>
                        </telerik:GridGroupByExpression>
                        <telerik:GridGroupByExpression>
                            <SelectFields>
                                <telerik:GridGroupByField HeaderValueSeparator=": " FieldAlias="Office" FieldName="OfficeName" />
                                <telerik:GridGroupByField HeaderValueSeparator=": " HeaderText="Hrs Spent" FieldAlias="HrsSpent"
                                    FieldName="TimeSpent" FormatString="{0:N1}" Aggregate="Sum" />
                                <telerik:GridGroupByField HeaderValueSeparator=": " HeaderText="Total Charged" FieldAlias="TotalCharged"
                                    FieldName="WorksheetAmount" FormatString="{0:c2}" Aggregate="Sum" />
                                <telerik:GridGroupByField HeaderValueSeparator=" " HeaderText=" " FieldAlias="OfficeID"
                                    FieldName="OfficeID" FormatString=" " />
                            </SelectFields>
                            <GroupByFields>
                                <telerik:GridGroupByField FieldName="OfficeName" SortOrder="Ascending" />
                            </GroupByFields>
                        </telerik:GridGroupByExpression>
                        <telerik:GridGroupByExpression>
                            <SelectFields>
                                <telerik:GridGroupByField HeaderValueSeparator=": " FieldAlias="Job" FieldName="JobTitle" />
                                <telerik:GridGroupByField HeaderValueSeparator=": " HeaderText="Hrs Spent" FieldAlias="HrsSpent"
                                    FieldName="TimeSpent" FormatString="{0:N1}" Aggregate="Sum" />
                                <telerik:GridGroupByField HeaderValueSeparator=": " HeaderText="Total Charged" FieldAlias="TotalCharged"
                                    FieldName="WorksheetAmount" FormatString="{0:c2}" Aggregate="Sum" />
                                <telerik:GridGroupByField HeaderValueSeparator=" " HeaderText=" " FieldAlias="ProjectID"
                                    FieldName="ProjectID" FormatString=" " />
                                <telerik:GridGroupByField HeaderValueSeparator=" " HeaderText=" " FieldAlias="JobID"
                                    FieldName="JobID" FormatString=" " />
                            </SelectFields>
                            <GroupByFields>
                                <telerik:GridGroupByField FieldName="JobTitle" SortOrder="Ascending" />
                            </GroupByFields>
                        </telerik:GridGroupByExpression>
                    </GroupByExpressions>

See screenshot of issue attached.

This exact same code worked perfectly in 2011 Q3 Dll's.
Has anything changed between versions?

Cheers,

Damien.




8 Answers, 1 is accepted

Sort by
0
Martin
Telerik team
answered on 01 May 2012, 01:45 PM
Hello Damien,

I was able to reproduce the issue locally and confirm that the grid does not behave as expected in this scenario. It looks like the problem is related to the aggregate function of the inner groups. I have forwarded your report to our developers for further investigation. Unfortunately, I can not provide you with exact estimate about when the problem will be fixed. However, you can follow the status of the issue in our public issue tracking system.

Please excuse us for the inconvenience.

Kind regards,
Martin
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
0
CodeR
Top achievements
Rank 2
answered on 08 May 2012, 01:00 AM
I have rolled back my version of the Telerik Web UI DLL.
This issue first cropped up in version '2011.3.115'.

The last working version was '2011.2.915' - Sept 2011.

This is becoming a major hurdle for upgrading to any of the latest versions of the Telerik Controls.


Any haste you can put to ensure this is addresses is much appreciated.

Regards,

Damien.
0
Martin
Telerik team
answered on 08 May 2012, 04:29 PM
Hello Damien,

Indeed this issue was not introduced in the latest version of RadControls. Since Q3 2011 our developers implemented many improvements to the grid grouping feature that resulted in much faster data manipulation. Those results were achieved by using LINQ which became the default grid grouping implementation. However, you can easily switch back to the previous grouping functionality by setting EnableLinqGrouping="false" of the MasterTableView. This way you should be able to use the latest version of the controls without observing this problem.

I have raised the priority of the issue and hope that it will be fixed in the official Q2 2012 release.

All the best,
Martin
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
0
Eva
Top achievements
Rank 1
answered on 30 May 2018, 09:14 AM

Hello,

I'd like to signal that this issue still hasn't been fixed in latest version 2018.2.516.45.

Can you please fix this bug in a future version ?

Thanks and regards.

Eva

0
Vessy
Telerik team
answered on 01 Jun 2018, 02:07 PM
Hi Eva,

I checked our bug backlog and the problem discussed in this thread was resolved 6 years ago for our 2012 Q3 release. Can you, please, share the configuration you are reproducing the problem with so I can examine it and log it again if needed?

Meanwhile, please, check if downgrading the jQuery version of the project will make a difference in case the issue is related with the jQuery 3.3.1 version embedded in our latest release. You can see how to do so here:
https://www.telerik.com/forums/known-issues-and-important-changes#KKI7NGE4P0K-jwQGL525dA


Regards,
Vessy
Progress Telerik
Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
0
Eva
Top achievements
Rank 1
answered on 01 Jun 2018, 02:39 PM

Hi,

My case is I have a RadGrid with multiple GroupBy expressions and a "Count" aggregate option on the lowest one.

As I can't provide you a sample of my code, here is an example :

<telerik:RadGrid ID="grdItems" runat="server" ShowGroupPanel="True">
    <MasterTableView DataKeyNames="Id">
        <GroupByExpressions>
            <telerik:GridGroupByExpression>
                <SelectFields>
                    <telerik:GridGroupByField FieldName="Domain" />
                </SelectFields>
                <GroupByFields>
                    <telerik:GridGroupByField FieldName="Domain" />
                </GroupByFields>
            </telerik:GridGroupByExpression>
            <telerik:GridGroupByExpression>
                <SelectFields>
                    <telerik:GridGroupByField FieldName="Category" />
                </SelectFields>
                <GroupByFields>
                    <telerik:GridGroupByField FieldName="Category" />
                </GroupByFields>
            </telerik:GridGroupByExpression>
            <telerik:GridGroupByExpression>
                <SelectFields>
                    <telerik:GridGroupByField FieldName="Type" />
                    <telerik:GridGroupByField FieldName="Type" Aggregate="Count" />
                </SelectFields>
                <GroupByFields>
                    <telerik:GridGroupByField FieldName="Type" />
                </GroupByFields>
            </telerik:GridGroupByExpression>
        </GroupByExpressions>
    </MasterTableView>
</telerik:RadGrid>

 

Description of the bug :

When there are several items having the same subgroup (i.g. "Type") but different higher-level group (i.g. "Category" or "Domain"), then the subgroup (i.g. "Type") header of those particular items aren't displayed properly :

  • SelectFields value is displayed as empty
  • SelectFields aggregated value (i.g. count of items) isn't displayed properly and show "{0}" instead

Note : the workaround (adding option  EnableLinqGrouping="False" on the MasterTableView) worked.

 

I'm using the latest version (2018.2.516.45) and I don't think the issue is related to the jQuery version.

 

Regards,

Eva

0
Eva
Top achievements
Rank 1
answered on 01 Jun 2018, 02:58 PM
PS : here is a screenshot of the bug.
0
Vessy
Telerik team
answered on 06 Jun 2018, 02:33 PM
Hi Eva,

I tested the provided markup but was not able to replicate the behavior from the attached screenshot. I am attaching my test page to this reply - can you, please, test it at your end and see if it is working for you as well? If so, can you modify it up to a point where the problem occurs and send it back for a further investigation?

Regards,
Vessy
Progress Telerik
Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Tags
Grid
Asked by
CodeR
Top achievements
Rank 2
Answers by
Martin
Telerik team
CodeR
Top achievements
Rank 2
Eva
Top achievements
Rank 1
Vessy
Telerik team
Share this question
or