Hi everyone - just wanted to pitch in. Trying to also set up my subscription to send out at the very last day of the month. I've got a pretty easy method I think but it does have a drawback which is pretty minor (depending on your users I guess).

OK, I have a monthly report that uses 2 parameters - month and year. I have the report parameters default to the current month and year. But this thing has to go out at the very last day of the month so as a workaround, I set the subscription to the very 1st of the month and then default my parameters like so:

MONTH parameter default value = IIF(Month(Now)=1,12,Month(Now)-1)

YEAR parameter default value = IIF(Month(Now)=1,Year(Now)-1,Year(Now))

Have to use the IIFs because of the issue of January - when January, now gotta default to December of the previous year, but otherwise, default to the previous month of the same year.

The downside? When users open the report, it'll default to the previous month. So it may confuse some users but I think it's a fairly minor nuisance. Hope this helps everyone.