SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Something like a more detailed mail merge...how to do it?


Something like a more detailed mail merge...how to do it?

Author
Message
tacy.highland
tacy.highland
SSC Veteran
SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)SSC Veteran (261 reputation)

Group: General Forum Members
Points: 261 Visits: 465
Hello all,

I have a letter I'm creating for the company's clients to receive, very much like the typical mail merge. However, each client has a secondary set of data specific to them which is listed within their letter. Looks something like this:


Joe Smith
1234 5th Ave
Anywhere, OH 45678

Dear Joe,

Generic letter text here...

You were delinquent for the following trips:

1/3/2014 5:30am 1234 5th Ave to 8765 4th Ave S
1/6/2014 6:00am 1234 5th Ave to 8765 4th Ave S

Please comply promptly.

Thanks a bunch
The Company


So I created a list with the letter text inside it and added the client's mailing info in individual fields at the top of the list. The trick is, when I add the delinquent trip information at the bottom, after the generic letter text but still inside the list, it's generating multiple letters for each client rather than one letter with multiple delinquent instances.

I tried putting the delinquent trips inside another list inside the original list. Also grouping the main list by the client name, but neither option did anything. Grouping the delinquent trip information in a list was a no-no as the tablix "has a detail member with inner members. Detail members can only contain static inner members". Even tried deleting the details row and moving the fields to another row to get around that issue but still no change in how it displays.

I'm used to getting this done easily in Crystal and for whatever reason thought it would be equally easy to do in SSRS. Anyone out there have any suggestions on how I handle this?

Where did I go wrong?
Thanks
sylvain.pouliot
sylvain.pouliot
Forum Newbie
Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)Forum Newbie (1 reputation)

Group: General Forum Members
Points: 1 Visits: 87
Hi Tacy

I don't know if I understand you correctly, but I think you only need to create a report, put a TABLE in it
Then add a group for the CLIENT NAME and put all the "header" information of your letter in the group header

Finally, add your delinquent trips in the detail section

I hope this helps. If not, send us more information

have a nice day!
MMartin1
MMartin1
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2745 Visits: 2031
It would be nice to post create tables statements with sample data to see how your data is structured. What I am seeing / reading described is a final front end. Can you describe with t-Sql what you've done so far if this is still an issue?

----------------------------------------------------
How to post forum questions to get the best help
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search