i have a report were end users selects "months starting" from and "months Ending" as prompts and year as another prompts.I need to show the report containing data between the user selected month prompts.I have the revenue values seperate for january ,feb,march, till..dec
Ex: if the user gives the months prompts as Months Starting =3 , Months Ending =8 and year=2012.I need to get the data for year 2012 between march and august.
i.e. march+April+May+June+July + August.
2.if the user selects the prompts as Months Starting =9 and Months Ending =12 .I need to get the data between sep and dec.
please let me know how to achieve this in deski report