September 18, 2009 at 7:03 pm
Hello ,
I am creating a Mailing Labels Report using SSRS 2008.
As per advise, first I placed three list boxes then placed a rectangle inside the list boxes to all three and set the visibility by expression
=iif(rownumber(nothing) mod 3 = 1, false, true)
=iif(rownumber(nothing) mod 3 = 2, false, true)
=iif(rownumber(nothing) mod 3 = 0, false, true)
Report are shown with line feeds on list boxes 2 and 3 while view/render/published on server.
Some one advised me recently to place the rectangle first to fit to page, then place three list boxes there inside and set the visibility... I tried this way around too..
Still the report is displaying labels with line feeds.
My dataset has three columns, and I am concatenating into a single column in Report (like Last Name, FirstName, addresss - as =Fields!LastName.Value +" "+ Fields!FirstName.Value + vbCrLf + Fields!Address.Value
Please anyone give suggestions..
Thanks
Joe.
September 20, 2009 at 9:25 am
I will show you how to create a mailing label merge using Excel and Word, so that you can mail out your wonderful created letters from the successful mail merge in the previous tutorial.
1. First, ensure you have the Excel workbook where you have all the address data securely saved and accessible, although, you don’t need to have it open to create the mail merge. Open Microsoft Word 2007 and go to Mailings>Start Mail Merge>Labels, and the “Label Options” pop up window box will appear.
2. Under “Printer Information” select “Page printers” and under “Label information” select “Avery US Letter,” and finally, under “Product number” you need to find the size of the labels you will be using for the mail merge. And click OK. Now before moving on to the next step, go to Table Tools Layout>Table>View Gridlines, so that you can see the gridlines of the mailing labels.
3. Next, go to Mailings>Start Mail Merge>Select Recipients>Use Existing List and the “Select Data Source” pop up window box will appear. Next, find the Excel file that contains the address information for the mailing labels. After you find the file, click on the range or sheet within the workbook that has the table with the address information and click OK.
4. Now looking at the Word document, place the cursor in the first label field (upper left hand corner of the screen) and go to Mailings>Write & Insert Fields>Address Block, and next within the “Insert Address Block” pop up window box click the format that you want to use and hit OK.
5. Next, go to Mailings>Write & Insert Fields>Update Labels, and the format you selected will appear. Following that, go to Mailings>Preview Results>Preview Results and the mailing labels merge will appear for your review.
6. Once you review the document, go to Mailings>Finish>Finish & Merge to finish the process and then you will be ready to print or edit each label section individually.
Good Job! You just created a mailing labels mail merge, and this can really save you time and energy on your next mailing.
September 21, 2009 at 10:20 am
i posted this request to solve the issue with mailing list - reporting services 2008.
pls some one give suggestions
thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply