cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
idarif2007
Regular Visitor

Custom file name for email attachment for subscription

Hello Team,

 

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

idarif2007_0-1669367448529.png

 

idarif2007_1-1669367495535.png

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

 

Regards,

Arif

 

3 REPLIES 3
Shahfaisal
Solution Sage
Solution Sage

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.

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


@idarif2007 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.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.