Dynamically change report parameter (Period Name) value on a scheduled FSG report in Report Manager
We have a request to dynamically reset the value of a scheduled FSG report (Income Statement) parameter: Period. We want to change it to prior month based on the report running date/time and repeat every month. e.g. we want to use JUN-18 for Period parameter when we schedule to run it on July 1, we want to automatically change it to JUL-18 on next month scheduled run on August 1 etc.. A screen shot of the report parameters and scheduling options is shown below.
Please help on how to do this dynamic parameter value reset ?
Thanks a lot