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

Column with Numeric alias, error when setting aggregate function

3 Answers 155 Views
Grid
This is a migrated thread and some comments may be shown as answers.
Sebastian
Top achievements
Rank 1
Sebastian asked on 09 Sep 2008, 10:10 PM
I have a simple radgrid bound to a simple datasource that return a single row.
In this row, I have many columns with numbers in its captions.
When I wanna set the aggregate funtion to Sum (for example), I get this error:
"Syntax error in aggregate argument: Expecting a single column argument with possible 'Child' qualifier."

What can I do?
I'm using radcontrol for ajax asp.net 2008.1.415.20, with C# in VS 2005.
Thanks in advance.
Image of the grid without aggregate functions

3 Answers, 1 is accepted

Sort by
0
Sebastian
Telerik team
answered on 12 Sep 2008, 10:40 AM
Hello Sebastian,

Is it possible that you have spaces in the DataField/UniqueName of some of the columns for which you calculate aggregate values? We have similar report for such case before and the problem should be addressed in the latest release 2008.2.826 of RadControls for ASP.NET AJAX. Please migrate to it (following the steps from this KB article) and let us know how it goes.

Alternatively, remove the spaces if present to see whether this helps.

Best regards,
Stephen
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
0
Sebastian
Top achievements
Rank 1
answered on 12 Sep 2008, 01:44 PM
Hi Stephen,
I have only Number en the Datafield name. I can't update to the lastest version for now. Any other solution?

Thanks.
0
Sebastian
Telerik team
answered on 15 Sep 2008, 02:24 PM
Hi Sebastian,

I suggest you debug your code to see whether you have left some spaces accidentally in the DataField value of the column. If this does not help, to address the issue you will need to consider migrating to the latest release 2008.2.826 of RadControls for ASP.NET AJAX.

Best regards,
Stephen
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
Tags
Grid
Asked by
Sebastian
Top achievements
Rank 1
Answers by
Sebastian
Telerik team
Sebastian
Top achievements
Rank 1
Share this question
or