Thanks for your respond, yes Im using the same formula to supress in details section and group header the formula is like this:
if Month({Command.LN_desired_recv_date}) > 3 or year({Command.LN_desired_recv_date}) <> CCur({?Year}) then
true
else IF NOT ISNULL({Command.LN_desired_recv_date}) AND NOT ISNULL({Command.ACTUAL_RECV_DATE}) and {Command.LN_desired_recv_date} <= CurrentDate and Month({Command.LN_desired_recv_date}) <=3 and Year({Command.LN_desired_recv_date}) = CCur({?Year}) THEN
{Command.ACTUAL_RECV_DATE} <= {Command.LN_desired_recv_date}
ELSE IF NOT ISNULL({Command.LN_desired_recv_date}) AND ISNULL({Command.ACTUAL_RECV_DATE}) and {Command.LN_desired_recv_date} <= CurrentDate and Month({Command.LN_desired_recv_date}) <=3 and Year({Command.LN_desired_recv_date}) = CCur({?Year}) THEN
Month ({Command.LN_desired_recv_date}) > 3 and Year({Command.LN_desired_recv_date}) = CCur ({?Year})
ELSE IF ISNULL({Command.LN_desired_recv_date}) AND NOT ISNULL({Command.ACTUAL_RECV_DATE}) THEN
{Command.ACTUAL_RECV_DATE} <= {Command.LN_desired_recv_date}
ELSE IF NOT ISNULL({Command.LN_desired_recv_date}) AND ({Command.LN_desired_recv_date} > CurrentDate or Month({Command.LN_desired_recv_date}) > 3)then
true
i have a select case 1: because this is by quarter, quarter 1 = January, February and March
IP Logged
