My report requirements are as follows-
I have a select option screen with the fields 0calyear , 0calmonth2 and 0calday.
The user wants to display on varaince between 2 years if he enters current year in the field 0calyear.
Eg : 0calyear : 2007, then report layout is
plant 2006 2007 variance
a xxx xxx xx
b xxx xxx xx
c xxx xxx xx
if he enters the year and month info he wants to display the monthly info for that year ony.
eg : 0calyear 2007 0calmont 7 then report is
is it possible in the same report.Please explain.