labels

[Baylor03]

when making labels in crystal, say ones that print two per row, is there a way to have two different formats per person, say one with name and address and one next to it with just the name. so there would be two labels per person

please help,
thanks

 

[Turkbear]

Hi,
I am not sure you can do that.
Usually labels are 1 per row of data, so unless you wanted to insert a new row for each person, it will be difficult.
In Oracle sql it would be something like this:

insert into table_with_nameandaddress
select name from same_table;

This will put a record of just the Name into the table..Order it by Name before the labels and you should get what you want.

Note: There may be a Crystal-Only way to do this, but I am not aware of how.

 

[Baylor03]

thanks, I didnt think it could be done, but i wanted to ask

 

[rosemaryl]

Hey Baylor03,

I think you can do this by fooling it.

You will have to waste a few, but basically treat the two rows as one.

Modify the label settings so that the width encompasses the width of both labels.

Create a formula (formatted can grow) for the address part.

Something like the following:

{Clients.First Name} & ' ' & {Clients.Last Name}
&chr(13)&
{Clients.Address}
&chr(13)&
{Clients.City} & ', ' & {Clients.State} & ' ' & {Clients.Zip}

Place that in the detail section positioned so it appears on the first label.

Now create a second formula tht is just the Name one and position it on the page where it prints inside the left edge of the second label.

{Clients.First Name} & ' ' & {Clients.Last Name}

Now, if you have gone to Details, format section, clicked the layout tab and messed with the width so that the width of the label encompasses both, you should be fine and end up with what you want.

Make sure that across and then down is selected.

Regards,

ro



Rosemary Lieberman
rosemary@microflo.com,

http://www.microflo.com

Microflo provides expert consulting on MagicTSD and Crystal Reports.

 

[Baylor03]

Thanks, that is exactly what my boss did(this question was for her) and she said it worked great.