SSRS 2005 - How to do a multi-line comment field (email body opening) for email subscriptions? Would like to add some line feeds and carriage returns to the email body.
in [Reports]
|
Prev: Trouble passing URL parameters to report in SharePoint
Next: Cannot connect to SSRS 2008 Report Manager URL
From: Mary S. on 31 Aug 2009 22:52 Hello All, I'm new to SSRS 2005 but really love the power of it. Now I need some recommendations for some good books. lol I'm setting up a basic report with a subscription to email the report. My question is, can one format the format the comment field (and therefore whatever gets stuck into the email) for multiple lines? That is, using line feeds and carriage returns or some other method? I've typed blank lines into the comment field in BIDS, but everything gets run together when the email from Exchange is received. However, if I use SQL Server Management Studio and connect to the Reporting Services instance, when I look at the Report Subscription Properties, the comment field shows the blank lines that I'd like to insert. I am rendering the report as a PDF file, including the report, and including the link. The email gets forwarded to an Exchange server, all emails are internal. Interestingly, when I us SSMS to script the subscription to an RSS file, it shows the commend field as: ParameterValues9.Name = "Comment" ParameterValues9.Value = "Greetings,"&Global.Microsoft.VisualBasic.ChrW(13)&Global.Microsoft.VisualBasic.ChrW(10)&"Next line." So it sort of looks like it's putting something in the comment that would seem to relate to a CRLF combo. Is there a way to include blank lines in the Comment field, and therefore the email body? Do I need to somehow point SSRS to .NET stuff? As far as I know we have it on the server since it's a requirement for another ASP application running there. Ideas and suggestions on how to accomplish this would be greatly appreciated. I've Googled around but can't really find anything relevant. Thank you, Mary |