Hi Mark,

> group by &cGroupBy ;
> order by &cOrderBy ;

Just an addition, I would add the "GROUP BY" to the variable, otherwise, if its dynamic it may be empty, and may couse an error.

lcGroupBy = iif(empty(cGroupBy), '', 'group by ' + cGroupBy)