topic Re: Subscribe a report on last day of the month in Report Server

Subscribe a report on last day of the month

SSWADOOD — Wed, 18 May 2022 07:55:35 GMT

Hello,

i am currently working on paginated reports, one the reports need to be shared with users on the last day of the month

as some months have 31 days some have 30 days,

can it done by creating a single subscribtion or should i create two seperate subscribtions one for months with 30 days and other for months with 31days.

Thanks and Regards

Re: Subscribe a report on last day of the month

sevenhills — Wed, 18 May 2022 22:42:03 GMT

on the 30th day of April, June, September & November
on the 31st day of January, March, May, July, August, October & December
on the 28th day of February

Not sure you want to create one more for leap year 😉

There are other ways like Power Automate, data driven

https://debajmecrm.com/how-to-get-last-day-of-current-month-in-power-automate/

Re: Subscribe a report on last day of the month

v-henryk-mstf — Tue, 24 May 2022 09:58:05 GMT

Hi SSWADOOD ,

It seems that for now, Power Bi does not have the option of "last day of the month".

But there is an alternative that is a workaround: an option to run the subscription on the first day of the month that defaults the report to the previous month. To make this an option, you need: 1. the data parameters in the report and 2a. the report already defaults to last month or 2b. a SQL Server version that supports data-driven subscriptions to override the default parameters to last month.

For more details, you can read this blog:

Report Manager Subscription Last Day of Month – The Data Queen (unlimitedviz.com)

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Re: Subscribe a report on last day of the month

SSWADOOD — Thu, 26 May 2022 05:18:59 GMT

hi Henry thanks for the message, i will test this on the report.....

for now i had created 3 subscriptions

first one for 28 days of Feb

second one for months with 30 days

third one for months with 31 days

i will probably shift to single subscription option via SSMS.

Re: Subscribe a report on last day of the month

Andrew_Stewart — Mon, 27 May 2024 22:08:39 GMT

I found a workaround that is applicable for most of the world:

schedule the report to run on the first of every month at 12:45 am in timezone UTC+12

That way it will actually run in the last day of the previous month as long as your timezone is less that UTC+11.

Re: Subscribe a report on last day of the month

MP-iCONN — Thu, 01 Aug 2024 13:46:17 GMT

This worked out great for us! We are in CST so for us 9:30AM UTC+12 on the 1st converted to the last day of the month at 4:30PM. 😀