Restricting the report output for a particular number of periods!
I am working on a report which has a selection field like "Period/ Year" where the user enters Period and the fiscal Year. I have to add one more field which will be "Number of Periods".
Now, the requirement is like:
Suppose the user enters: 08/2007 in the field "Period/Year" and suppose he enters 3 in the parameter "Number of Periods". Now, the user wants that the report should control the number of period and display only 08/2007, 07/2007 and 06/2007( that means only 3 periods prior to 08/2007. including the period which is entered on the selection screen).
This field "Number of Periods" will not be a mandatory field.
Can anyone provide any guidance for this?