I'd like to know if it is possible to use Crystal Parameters in a SQL Command... for example...
I want the user setup a complex SQL statement
SELECT * FROM APPROVED_TRADES
WHERE trade_dt in {?Start Date} to {?End Date}
UNION
SELECT * FROM VOID_TRADES
WHERE trade_dt < {?Start Date} and
void_dt in {?Start Date} to {?End Date}
is that possible?
I want the user setup a complex SQL statement
SELECT * FROM APPROVED_TRADES
WHERE trade_dt in {?Start Date} to {?End Date}
UNION
SELECT * FROM VOID_TRADES
WHERE trade_dt < {?Start Date} and
void_dt in {?Start Date} to {?End Date}
is that possible?