Creating Letters in Reporting Services


We're currently migrating over from Crystal reports to SSRS & we have a number of letters that need to be converted. There doesn't seem to be an obvious way of adding the static text of the letter to a report container (e.g. textbox) & then embedding the data that comes from a dataset.

Does anyone have any suggestions on how best to achieve this?

Who is Participating?
brejkConnect With a Mentor Commented:
One more thing. You can combine both static and dynamic content.

For example you can set Value property of TextBox to:

="Product: " & Fields!ProductName.Value & Chr(13) & Chr(10) & "Second line..."
TextBox (or multiple textboxes) is all you need. Just set the Value property to one of your fields from DataSet (if you provide content dynamically) or write it yourself (Shift+ENTER = new line).
monserobAuthor Commented:
Thanks brejk, I figured out that perhaps I could do it that way & will accept you answer as a solution but just wondered if there was anyway of copying the text from a word document (keeping the format & layout) & then embedding the dynamic bits
monserobAuthor Commented:
I've since found an application called OfficeWriter that integrates Word/Excel with reporting services, which gives me what I need
All Courses

From novice to tech pro — start learning today.