Multi Line email body in Data Driven Subscription in SSRS 2008
Any body knows how to create a multi-line email body in Data Driven Subscription in SSRS 2008? The body of email created form the Comment parameter of the Data Driven Subscription, unfortunately even the parameter is filled from a db field which contains multi-line data, all the CR-LF are removed from the text and text in the email arrives as one line(paragraph).
As I wrote in my question. When you have a Data Driven Subscription in SSRS and when you choose email delivery, there is a field named Comment, which represents the body of the email. It is the message in the email and the report will be attached to this email. You can write a simple text into this field or choose a db field from the query used as source of the subscription. Problem is when you need a multi-line email with several articles in it (Need to explain what the report is and how to use it). Unfortunately SSRS always removed all the new-lines and put all the articles together as a single line. After several hours of playing with this I found, that you can put a HTML Source for this field and it will be put as the email body and then correctly showed by the email client :-) So you can use HTML code:
You can use all the HTML features and the text is then correctly rendered in the client. At least in Outlook. **You have to put the HTML source into this field. :-)**