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
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
0
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.
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
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
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.
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.