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

Grouping expression should not contain aggregate functions - Q1 2010

3 Answers 493 Views
General Discussions
This is a migrated thread and some comments may be shown as answers.
Sundar
Top achievements
Rank 1
Sundar asked on 25 Mar 2010, 08:20 AM
Hi,

We have upgraded Telerik reporting version to Q1 2010 from Q2 2009. Report rendering performance is very good. But, one of our report suddenly giving error like "An error has occurred while processing Table 'tblControl': Grouping expression should not contain aggregate functions.".  The same report is working well in Q2 2009 version. We are using 'Table control' in report.

1st Row  - Header
2nd Row - Detail
3rd Row - Footer (here is our Total field we placed  ie. Sum(SalaryField))

What is the cause of this problem?


3 Answers, 1 is accepted

Sort by
0
Steve
Telerik team
answered on 25 Mar 2010, 08:51 AM
Hi BenoitM,

We believe the error message is pretty clear - you should have a datasource field as grouping expression and not aggregate function. For example take a look at our CrossTab demo report which is pretty much as your setup. The grouping expressions contain only fields upon which you group, but the actual textbox expressions in the footer are using aggregate functions (see attached screenshot). More information about grouping is available here: Grouping Data.

Regards,
Steve
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
0
Sundar
Top achievements
Rank 1
answered on 25 Mar 2010, 11:05 AM
Hi,

Thanks for your quick reply. Please see the attachment for more details about the error what we are facing.

Solution:
If we delete the "Group Total" row  (in my case 3rd Row - Footer ),  and if we add the group again in "table control" then it is working fine in Q1 2010.

Thanks

0
Steve
Telerik team
answered on 25 Mar 2010, 06:31 PM
Hi BenoitM,

Please refer to the screenshot from my previous post. You need to make a distinction between the expression placed in a table cell (which can contain an aggregate) and grouping expression that should contain only a data field.

Sincerely yours,
Steve
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Tags
General Discussions
Asked by
Sundar
Top achievements
Rank 1
Answers by
Steve
Telerik team
Sundar
Top achievements
Rank 1
Share this question
or