Wednesday, March 21, 2012

Reporting Services Monthly Subscription

Hello,

I'm scheduling monthly subscriptions in reporting services. I would like to receive subscriptions every 2nd Monday of the month. For instance, if the 1st is a Friday, then report should be delivered Monday, the 11th.

So my question is: in reporting services:

if I set the subscription for Monday - 2nd week, and the first day of the month is a Friday

- does it consider the week from 4 -> 10 as the second week (because month began the week before)

- or as the first week (because it takes into account only full weeks)?

Thanks a lot for any help!

Best regards,

Tiago

Hello Tiago,

I just ran a test to check this out. I created a schedule to run on Monday - 2nd week, the next run will be February 12th. It will assume that 1-7 is the first week of any month, 8-14 is the second week, etc.

So, in your example of your subscription on Monday - 2nd week and the 1st is a Friday, it will run on the 11th. Setting a subscription for Monday - 2nd week will be the correct schedule for what you're trying to accomplish.

Hope this helps.

Jarret

|||Excellent, thanks a lot Jarret!

No comments:

Post a Comment