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?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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).
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..."

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
DB Reporting Tools

From novice to tech pro — start learning today.