I have a report that has several parameters, including the start and end date. It is a monthly report that I want to produce with a subscription.
It will run on the 3rd of each month and the data it's looking for is always for the previous month.
Best way to have it calculate the start and end dates without user intervention?
Example: Report will run on May 3, 2018. I want the start date to be April 1, 2018 and end date April 30, 2018.
The report will run again on June 3, 2018. Start date = May 1, 2018 End date = May 31, 2018