Display report based on category context change
I have a requirement where records will be fetched and shown in report based on category selected from context which will be matched with some date. For example . If I choose Category= Plan then this will be matched with date i.e. 1/8/2015(dd/mm/yyyy).If I choose Category= Forecast1 then Date will be 1/4/2016. Assuming we are in August 2015 and Planning for 2016.
In my report in row axis two dimensions are there Employee and Cost Center and in column axis HR Account, There is two main field in HR Account is START DATE and END DATE. So when ever user select category plan from context only End date starting from August and August onwards will be only shown in report, if user select Forecast1 then report shown from April and April onwards.