Grouping on calc field

rbuser

Hi,

Is it possible to group on a calc field? I have created a calc field but it
does not appear in the grouping area.

Regards

Alex

nicocizik

Hi Al,

Unfortunately, grouping by a calculated field in ReportBuilder is not
supported. This is due to the fact that grouping by the value of a
calcuated expression is not supported by SQL itself.

--

rbuser

Oh OK, is that a specific SQL standard? DBISAM appears to support it

Regards

Alex

nicocizik

Hi Al,

Yes, this is a SQL standard. Although some databases support extra
features, to ensure the best compatablility over multiple database systems,
ReportBuilder generally stays within the SQL standards.

--