SQL Server 报告服务 2005；订阅
我对报告管理器中订阅中的评论有疑问。
无论我以什么格式创建评论，当报告邮寄出去并且评论中的段落被删除时，格式都会丢失，只留下句子。由于我们的报告对用户来说是新的，因此我需要包含一些说明，并且它们需要段落。
I have an issue with the comments in subscriptions in report manager.
No matter what format I create the comment in, format is lost when the report is mailed out and the paragraphs in the comment are removed, leaving just sentences. Since our reporting is new to users, I need to include some instructions and they require paragraphs.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
使用 HTML 标签
Use HTML tag
<br/>.经过一些测试，我认为这是不可能的。
我刚刚尝试使用存储过程创建数据驱动订阅，并将注释设置为使用存储过程结果中的值。我将此值硬编码为：
'abc' + CHAR(13) + CHAR(10) + 'def'如果您在 SSMS 中
选择此表达式并显示结果到文本，您会看到它显示在多行中。然而，在电子邮件中，它仍然是一行！编辑查看这篇文章关于 MS Connect。看起来它在 2008 R2 中已修复，对您来说没有多大用处。不过，有一个建议的解决方法，即使用 HTML 标记，例如
Following some tests, I don't think this is possible.
I just tried creating a data-driven subscription using a stored procedure, and set the comment to use a value from my stored procedure results. I hard coded this value as:
'abc' + CHAR(13) + CHAR(10) + 'def'If you
selectthis expression in SSMS with results to text, you'll see it displays over multiple lines. However, in the email it was still on one line!Edit Check out this article on MS Connect. It looks like it was fixed in 2008 R2 which isn't much use to you. However there is a suggested workaround which is to use HTML markup such as
<br />tags. This to me seems ugly, but if you can be sure your recipients use HTML email then it might solve the problem?电子邮件是使用 HTML 生成的，因此如果您使用标准 HTML 标签，例如用于换行符的
The emails are generated using HTML so if you use standard HTML tags such as
<br>for line breaks etc your formatting will be preserved in the email.