Breaking up of Budget into quarters
I am trying to build reports.
I have a KF called 0AMOUNT, which has budget data and also carries information about the Fiscal Year/Period in the format like ( 001/2006, 002/2006.. so on till 012/2006)
So 001/2006-003/2006 accounts for Quarter 1 and so on for other quarters.
I am creating a RKF restricting 0AMOUNT to Fiscal Year/ Period and using my own user defined Varible, which prompts the user for the quarter he wants and has default value ( say 001/2007- 003/2007 for Quarter 1 of Year 2007)
So totaly 4 RKF's and 4 Variables.
problem is that, when i execute the report it prompts the user for all the quarters and suppose if he wants to get the breakup for 2008, he has to enter all the quarter's value in the variables again. and then execute.
Not looking good.
I m sure client wont like it.
is there any way out for me!!!
any help would be GREAT