From my crystal report,
I want to be able to change the date from oracle select statement
*(SELECT ADD_MONTHS(sysdate, -10) FROM DUAL)*
select sum(invoice_total), c.com_name,c.com_area from invoice i, customers c
where invoice_date > (SELECT ADD_MONTHS(sysdate, -10) FROM DUAL) and c.tid=i.com_id
group by c.com_name,c.com_area
order by c.com_name ;
is crystal report able to adding two buttons (previous, next month)?