## How do I sort records on a QuickReport obtained by using SQL functions

2005-12-20 03:04:42 PM

cppbuilder52
Hello!

I have a querry in which I obtain a recordset by SELECTing from various tables and using SQL FUNCTIONS such as SUM(Col1*Col2)

and GROUP BY Col3.

I am wondering how to sort i.e ORDER BY the result of SUM(Col1*Col2).

I wish to display the Recordset using a QuickReport sorted using the result of SUM(Col1*Col2).

Your help will be highly appreciated.