expressions inside GROUP BY

rbuser

Is there any way to put expressions inside the 'GROUP BY' clause using
Report Builder's SQL Constructor? ( just like you do it inside the 'WHERE'
clause...)

digitalmetaphors

You cannot add a subselect to the group by clause. What database are you
using and what should this operation perform? If I'mmisunderstanding, then
you can add a group by field as shown in this demo, which shows how to add
search criteria fields, sort fields and group by fields on the TdaSQL
object:

http://www.digital-metaphors.com/tips/ExtractSQLObject.zip


Cheers,

Jim Bennett
Digital Metaphors