I have an issue with report painter report, which has report layout as 5 columns
1. Cost center description, 2. current month, 3 Inception to date, 4 cummulative balace of previous year, 5 cummulative balance. Column 5 is derived by adding column 3 and 4.
However in the drill down value is mismatching it is showing only previous year balance and it is not adding current year values.
Eg : if I run the report till febraury 2007, in the drill down values are coming upto 2006. Hence values are not matching with front screen.
Selction screen values are flowing to the drill down report.
Please advice me how to restrict selection in the drill down.