how to dynamically schedule a report to run for previous month?
what I have done:
I have created 'Previous Month' as a Prompt in the report. From current_date function, I am calculating Previous Month value.
While scheduling the job, i have selected 'Previous Month' as the promt value.
Issue:
When i run the report ondemand, the report is running for Previous Month (Showing May2013 Data).
But the scheduled report is showing April2013 data. Job is scheduled in May, so it is taking Previous Month of May, and showing April values.
The scheduler is not refresing the value of 'Previous Month' based on the calculation in the report.
How to dynamically schedule the report to run for Previous Month every day?
PS: 'Report View' of the report is scheduled, not the actual report. I have created 5 views of the report to run for previous 5 months. I am in Cognos 10.1