Creating Letters in Reporting Services

Hi

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?

Monserob
monserobAsked:
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..."
0
 
brejkCommented:
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).
0
 
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
0
 
monserobAuthor Commented:
I've since found an application called OfficeWriter that integrates Word/Excel with reporting services, which gives me what I need
0
All Courses

From novice to tech pro — start learning today.