Using SSRS to produce form letters (mail merge)

  • Hi all,

    Has anyone used Reporting Services to produce form letters? I'm drawing customer data from a fairly simple query, and had hoped it would be as simple as just feeding into a series of textboxes to fill in the blanks. Unfortunately, what I get when I drag a field into each textbox is "first(etc..)", and what I'd hoped would run as a series of letters only actually produces one.

    Am I missing something glaringly obvious, or is this more complicated than it should be?

    TIA

  • You need to use either a table or list control. I am attaching a simple example using a table and the AdventureWorks database.

    Basically I created a group on the details and put a page break at the end of the group.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply