Hi,
I'd like to do something like this in Crystal Reports in my command object:

declare RecDisplay INT:= {?RecordDisplay};

IF RecDisplay= 1 THEN
..code to run rpt with columns having aggregrates
ELSE
..code to run rpt with columns (very same columns) without aggregates
END IF

Is it possible to do that?

Edited by wdelaney - 06 Jun 2011 at 5:28pm

ok, here's what worked: I used two SELECTS in the one command object, one with the GROUP BY and one without, and did the parameter differently  in the WHERE for each, so that only one of the SELECT's actually produces any rows. 
For the SELECT with the GROUP BY, I added {?RecordDisplay} = 1 to the WHERE.  For the other SELECT, I added {?RecordDisplay} <> 1 to the WHERE.
I used UNION between the two SELECTs and rows returned for whichever SELECT's WHERE clause happened to meet the criteria for the parameter input.

Edited by wdelaney - 07 Jun 2011 at 5:31pm