Two labels for diferents records

[sacramento]

Hi to all:

The picture show a report that should sort 2 records on each label, but like you see the report sort the same record in the two labels.
That i want is the report sort the record number 1 in the label of the left and the next record in the label of the right...



Wich way i can resolve this problem?

Thanks

[jggtz]

Use labels that has 1 label for each row

JG

[sacramento]

Well...Do you mean it's not possible do that with 2 labels?

[jggtz]

Sorry, the only solution that comes to my head is to modify the application, create a new table and writes the labels, 2 in a row...

JG

[sacramento]

yes i see...

[sacramento]

I could create a formula that jump to a specific recordnumber no?
Do you know the way to print a specific recordnumber in CR?

[jggtz]

You may try creating a new report type 'Mail Label' using report wizard
Select data source
Select table
Select fields
Select page, try with 'Avery 5161' that are 2 labels for row

JG

[sacramento]

I can't create the table via wizard...this project chance the name of the table every year and i must create the query via code...

[sacramento]

Hi:

Thanks for your suggestion...I had adapte some thinks and now i have that i want in my report

Regards