Post reply

SSRS report with custom filename and tab name for email delivery subscription

  • October 17, 2013 at 9:08 am

    #278980

    Hi,

    I have a report and its name is MonthlyReport and I run it for 20 diff states(PA,NJ,DE,MA,CT etc..).

    I need to run the report on 1st of every month and email this report for respective recipients.

    The report name for data in PA should be MonthlyReport-PA ,data for the stat NJ should be MonthlyReport-NJ. Like this I have to create 20 report for 20 diff states.

    Since the recipients are diff for each report I am creating a diff subscription for each state.

    But the problem I am not able to create a diff file name per each state. For all the states the subscription is generating the same file name which is report name(monthlyReport).

    I don't find a place/way to generate a file name in data driven subscription when I choose email as the method of delivery.

    using the following query in data driven subscription.

    SELECT 'testrecords1233@hotmail.com' , 'MontlyReport '+StateCode as [FileName]

    FROM adventureworks.dbo.state

    WHEREStateCode='PA'

    I am able to select Email value from the above query under to value in the email but I dont see a place/Section where I can assign the filename as we do for windows File Share delivery.

    I dont find any help when I google this issue.

    Can anyone help me with this?

    THanks.

  • October 17, 2013 at 9:21 am

    #1659380

    This will get you the results you want. Maybe a bit overkill with the custom subscription part, but it's the only way I've found to do it.

    http://www.sqlservercentral.com/articles/Reporting+Services+(SSRS)/69546/

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg

  • October 17, 2013 at 9:45 am

    #1659394

    Can I use the Stored procedure and other setting changes described in these articles on 2012 reporting services?

  • October 17, 2013 at 9:51 am

    #1659395

    I've not tested against 2012, you'll have to try and post back here if it does work.

    ______________________________________________________________________

    Personal Motto: Why push the envelope when you can just open it?

    If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.

    Jason L. Selburg

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply