Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I would like to set up an SSRS email subscription that attaches the report in PDF format to the email with a custom file name that changes daily. I was hopeful that I could to this via a data-driven subscription, but that does not seem possible. Does anyone have a handy work-around for this limitation?

UPDATE: @swasheck provided a decent work-around, and one that we currently use. But I am hoping to remove the step of saving to a file-share.

share|improve this question
    
How are you creating the PDF? SSIS expressions might be an option for you, but let's hear about how the PDF originates. –  Eric Higgins May 29 '12 at 16:06
    
Not very exciting - just by rending the report as PDF as defined in the subscription. –  JHFB May 29 '12 at 16:12
add comment

1 Answer

This is the first way I could think of to make this happen:

  1. Create a data-driven subscription for the report
  2. Specify Windows File Share as the delivery method (this would imply that you had a file share location available)
  3. Connect to a data source
  4. Write a query to generate the name
  5. Specify that name as the report name in the location of your file share
  6. Have a process by which the end-users are emailed this report - perhaps a SQL Agent job?

As a matter of personal exploration, I wonder if it'd be possible to modify the SQL Agent job that the subscription creates such that you could add a step to send the file via email.

share|improve this answer
    
Good work around - and actually what we currently do. :) –  JHFB Jun 6 '12 at 13:32
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.