Mailing labels for dummies

Ok, I'm an idiot. Does anyone out there have some step by step instructions for creating a report that will do mailing labels. I've got multiple columns on my report but I end up with the contents of each column being the same across each grouping/row. In other words for each record read, since I have three columns, I get three occurances of each customer and address until all the data selected for that row is presented, then I go to the next customer which again is repeated across all three columns.

I'm sorry I'm so stupid, but I've looked at other entries on the forum, and I just can't figure it out. We are trying to get out from underneith Business objects thumb and any help would be greatly appreciated. Thanks! - Eric -

Carpet King,

I think what you are looking for is the Multiple Column type report. you will set this up by using going into the report properties and setting the number of colums to 3.

Hope this helps

|||

Thanks Bret for the input. Your posting helped me to figure out where to look and change the properties. It through me for a while 'cause the pre-view doesn't show the multiple columns. As a result, after reading your input and making the change, it took a while to figure out that what you told me to do really did fix the problem.

The SQL reporting services is still Marginal (at best!) in creating labels. I'm having a heck of a time getting things evened out so that they will print on my labels correctly. I'm still having a lot of problems getting it set up just right so that information from one label doesn't carry over to another.

None the less, thank you very much for your help! I don't want you to feel like I am shooting the messanger, just venting. Sorry. :B - Eric -

|||

Hello,

I am working on mailing labels and I have the 3 columns, but now I am trying to get them to print across the page,rather than down the page. (Trying to prevent wasting labels by going down the page.) Below is an example of what I need:

1 2 3 4

NOT

1

2

3

4

Any ideas would be greatly appreciated!

mbsqlnewbie