topic Custom file name for email attachment for subscription in Report Server

Custom file name for email attachment for subscription

Anonymous — Fri, 25 Nov 2022 09:12:31 GMT

Hello Team,

I have created an email subscription with data driven Subscription with email as the delivery option.

I donot see any option to have dynamic file name for email attachment, Can some one please help.

Regards,

Arif

Re: Custom file name for email attachment for subscription

Shahfaisal — Fri, 25 Nov 2022 23:50:15 GMT

You will need to use data driven subscription to able to have a dynamic file name for email attachment. See https://www.sqlshack.com/enhancing-customer-experiences-with-subscriptions-in-ssrs/

Please note that data driven subscription is an Enterprise features which means you will need a Enterprise Edition of SQL Server (Standard Edition won't work).

There is also an un-supported way to make this work - by updating the tables in the Report Server database as the subscription is running but I don't recommend that.

Re: Custom file name for email attachment for subscription

Anonymous — Mon, 28 Nov 2022 11:31:01 GMT

Hello,

Thanks for your reply.

But, I would need an Email subscription where i can have the same name as given in the tables for the Email attachment.

Can you please help!

Regards,

Arif

Re: Custom file name for email attachment for subscription

Shahfaisal — Mon, 28 Nov 2022 12:09:31 GMT

Anonymous wrote:
But, I would need an Email subscription where i can have the same name as given in the tables for the Email attachment.

You will need data driven subscription which required SQL Server Enterprise Edition.