SSRS: Customising Subject field of a report for email delivery

Posted on 2007-10-18
Last Modified: 2010-05-18

I am currently in process of deploying SSRS 2005 reports. Some of the reports need to run on a periodical basis and are thus subscribed for delivery. When subscribing a report for Email delivery the subject line says "@ReportName was executed at @ExecutionTime". I understand that @ReportName and @ExecutionTime are runtime parameters passed to the Report Manager.

My questions are:
1. How can I customise Subject Line with Dynamic values?
2. Where can I find the list of values that can be passed to the subject line?

I have tried few different combinations of the internal report parameters but nothing has materialised. Your help is much appreciated.
Question by:LawCentral
    LVL 18

    Accepted Solution

    To customise it with data from a query I believe you will need to use a data driven subscription (only available in enterprise edition)

    Without using a data driven subscription, the two variables you mentioned (@ExecutionTime and @ReportName) are all that is available
    LVL 1

    Author Comment

    thank you.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
    Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
    This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
    Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now