I am trying to schedule a job which contains several reports that we run manually each month. I would like to know how do I hard code the current and previous month into the reports so that they can be scheduled verses manually running them each month.
Are you using a cube or a relationnal datasource ?
relational
The only way i see of doing this, is by using where clause that filter your data based of the current_date.
Functions like first of month can be helpful if you want to split values in 2 field (current month and last month)