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

newbie question

3 Answers 23 Views
Grid
This is a migrated thread and some comments may be shown as answers.
tomas
Top achievements
Rank 1
tomas asked on 29 Nov 2008, 06:56 PM
Hello. I am trying to use group by feature of your grid. My database has a millions of rows so I want to let the SQL server to count the grouping. Thus my sql should looks like that:

select something from something GROUP BY something. (group by expression is included directly in a sql query)

I dont want to let your grid to count the groups aggregates.

Is it possible?
All your examples I have found are about "select columns from table" and group by expressions are declared elsewhere.

Thank you very much.

Tomas

3 Answers, 1 is accepted

Sort by
0
Yavor
Telerik team
answered on 02 Dec 2008, 08:31 AM
Hello tomas,

When using the built-in grouping functionality of the grid control, it will automatically group the data coming from the database, rather than relying on the database to perform any calculations, or pass the data in a special way. Any additional calculations can be performed either through code, or by using the column aggregates which will then be reflected in the group footers.

Best wishes,
Yavor
the Telerik team

Check out Telerik Trainer, the state of the art learning tool for Telerik products.
0
tomas
Top achievements
Rank 1
answered on 02 Dec 2008, 12:11 PM

Hello Yavor
Thank you for your reply.

Is it possible to let the database perform these aggregate calculations and use your RADGRID for the visualization only?

Thank you very much.

Tom

0
Yavor
Telerik team
answered on 03 Dec 2008, 01:03 PM
Hello tomas,

Basically, the control need to be databound to handle grouping. You cannot allow grouping and pass portions of data, or use the control simply for representational purposes.
Another option which you may consider is using a hierarchy, which allows for more flexibility to pass customized data to inner levels, for example in the DetailTableDataBind handler.

Kind regards,
Yavor
the Telerik team

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