How to duplicate mailing label 3 across 2

[NewToThis2]

CR V9 - Avery Label #5960, 3 across, 10 down

I need each address to repeat 3 time across. For example:
Jane Doe Jane Doe Jane Doe
John Blue John Blue John Blue
Bill Black Bill Black Bill Black

How can I tell Crystal to do that? Any assistance would be greatly appreciated. Thanks so much!

 

[pgtek]

hi

read this

http://support.businessobjects.com/library/kbase/articles/c2001548.asp

cheers

pgtek

 

[NewToThis2]

Thanks so much for your response. The article you referred to recommends modifying the database which I can not do. It is is a HUGE database that I do not have access to for making modifications and it would be a huge request for our MIS department. I'm hoping someone out there has wanted to do this same thing and may have another option for me. Thanks again!

 

[bdreed35]

Another solution to your problem would be multiple sections and underlaying.

Report, Section Expert.
Highlight Details.
Click the Insert button at the top 2 times so you have details a, details b, and details c.
Highlight Details a, and select the Underlay proeprty on the right.
Repeat the same process for Details b.
Now, close the section expert.

Create your address label now.
I add a text object, and add the address fields to it, seperating then with a press of the enter key, or a comma and a space for the city, state and zip code.
The address field should be placed on the left side of details a.
Copy the field and place the copy in the center of details b.
Copy the field again and place the copy on the right side of details c.
When you preview the report, you should get the desired look you want.

You may need to size the sections amd fields to get the right placement and size for your labels but I am sure you can handle that.

~Brian