A parameter in subject line in Reporting Services
Hello @ all,
there are two standard parameter in the subject line: @ReportName and @ExecutionTime.
I want to set an individual report parameter value to the subject line.
These are my report parameter:
@YEAR, @DATE, @FILES
And I want to set the subject line to something like that:
@ReportName with @FILE (@ExecutionTime)
Any ideas or solution?!?Please 'Mark as Answer' if I helped. This helps others who have the same problem!
July 1st, 2011 6:03am
Can you please elaborate? What exactly you mean by subject line? Are you talking about the Email Subscription, and customizing the Subject line?
Which version of SSRS are you using?
Additionally check these:
http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/fa1a772c-fad4-4b66-952f-c310042b2f08 [Subscription
customization]
E-Mail Delivery in Reporting Services
Creating, Modifying, and Deleting Standard Subscriptions
Setting Parameters in a Subscription
Chaitanya( Twitter |
Blogs )
Any documentation bug? Tell us about it at
Connect. Please feel free to add any community comments in any of the MSDN/technet articles.
This posting is provided "AS IS" with no warranties, and confers no rights.
Free Windows Admin Tool Kit Click here and download it now
July 1st, 2011 6:54am
Hello,
yes, I'm talking about the Email Subscription and I want to customize the subject line.
I want to customize the subject with an individual report parameter.
I'm using SSRS 2008.Please 'Mark as Answer' if I helped. This helps others who have the same problem!
July 4th, 2011 1:43am
Hi Dennis,
As Chaitanya posted, if you need to customize the Subject line, you can use Data-driven subscription instead of standard subscription. When we create a Data-driven subscription for a report and delivery by E-mail, we can use "Specify delivery extension settings
for Report Server Email” page to customize the Subject line.
For more information about Tutorial: Creating a Data-Driven Subscription, please refer to the article below:
http://msdn.microsoft.com/en-us/library/ms169673.aspx
If you have any more questions, please feel free to ask.
Thanks,
Bin Long
Free Windows Admin Tool Kit Click here and download it now
July 4th, 2011 10:54pm