question

NavMukkasa-9693 avatar image
0 Votes"
NavMukkasa-9693 asked ZoeHui-MSFT edited

test title MSFT

test title MSFT

not-supported
· 1
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ZoeHui-MSFT avatar image ZoeHui-MSFT ·

Hi @NavMukkasa-9693,
Do you have further question on this , could we offer more support?
If this helps on your issue, you could mark it as answer so other user with similar problem could see this easier. :)

0 Votes 0 ·

1 Answer

ZoeHui-MSFT avatar image
0 Votes"
ZoeHui-MSFT answered ZoeHui-MSFT edited

Hi @NavMukkasa-9693,

As far as I know, if you use e-mail as delivery in data driven subscription, there is no such a functionality temporaraily.

However, if you use Windows File Share, you may try with below.

  1. Click on New Data driven subscription button

  2. Select Windows File Share.

  3. Edit dataset and enter the query

    select 'Myreport' + ' ' +convert(varchar(10), Getdate(), 112) as FileName , 'C:\Monthly Reports\Shared Reports folder' as Path


  4. Set Delivery options (Windows File Share)

171196-image.png

And then you may e-mail the file to the users you want.

Regards，

Zoe

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.











image.png (18.7 KiB)
5 |1600 characters needed characters left characters exceeded
Toggle Comment visibility. Current Visibility: Visible to all users

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.