I have this report that I run sometimes mid-month. People want to see some sections with daily data, in the mid-month report. i.e. if the report is run on the 18th Dec, then they want to see a table with 18 columns showing the MTD of the current month.
Also, it would be ideal to be able to have a comparable calculated field, i.e. same period but in the prior year.
I know I could easily go in to the report each time and change the dates, however key thing here is that the report must be dynamic as there are lots of them!