My requirement is that, when the report runs it has to run for current year and current month, also year and month prompts are cascaded. i am having Biennium year values as 2013-2015,2011-2013, 2009-2011,2007-2009; and fiscal months values are 01,02,03,04.........21,22,23,24; so by default the report has to run for 2013-2015 (i.e. 2013-2014 first biennium year and 2014-2015 is second biennium year and Fiscal month should run for July).July is my first fiscal month..i.e 01
I have only two prompts namely Biennium year and Fiscal month as single select value prompts in the report page(no prompt page).
Please help me out as i tried many of things but no luck.......