Report in order to make labels

Hello!
I want to create a report in the view to be printed in order to make labels. I have some manufacturers (addresses, activity…), each one must correspond to a label. I want to put 6 per page of them. The problem is that I do not manage to format this report (to put two recordings one beside the other…).
Could somebody help me? Do there exist models of report which I could exploit?
Thank you in advance.
Nicolas.

Post Scriptum: sorry for my bad english.


madjic (BOB member since 2004-07-06)

If you can return a row number with the report, you could produce two tables side by side, filtering one for odd numbers and one for even numbers filters being ROWID/2 = INT(ROWID/2) for even and ROWID/2 > INT(ROWID/2) for the odd numbers. To get them side by side, use the format table options by right clicking on the second table (which you can copy from the first after you have got its layout right).

Regards,
Mark

In fact, I have no ID for any manufacturer (just name, address, activity…)…


madjic (BOB member since 2004-07-06)

Is there anything else that you could filter on to split the list into two halves so that you could show half in the left table and half in the right?

Unfortunately not.
Simply, it does not exist any tool ,that permits to structure registrations in the report? Have we to have obligatory any registration below the previous?
Does it exist patterns (delivery by BO) on the network, we can use?
Thank for your help Mark.

Nicolas


madjic (BOB member since 2004-07-06)

If you are using Oracle, you could create an object where the sql statement is simply

ROWNUM

and use this in your query (you can hide it in your report within the pivot section of format table)

Regards,
Mark

I usually show this Reporttype “labels” during my BO-Trainings…
You can set a table to show in colums on a layout view… properties table - first tab bottom left - and you may define space between the colums…
you may use breaks to keep adressdata together so that every label starts with the same data… that’s I do it!

Use view structure to arrange your cells - control in layout view to see how it works!

  • Yours…
    WoBi :smiley:

Wolfgang Bidner :austria: (BOB member since 2002-08-30)

Simply set up your output in two columns, it’s very simple.

There is an article on the Integra web site that will help you get started.

Printing Labels in BusinessObjects

It’s a simple text file with some ideas on how to print labels from BusinessObjects, including the steps needed to set up two (or more) column output.

To set up multi-column output, simply right-click on your table, select Format Table, select the General tab on the dialog box, and set the number of columns and spacing between them on the bottom of the screen.


Dave Rathbun :us: (BOB member since 2002-06-06)

Thank’s a lot!!!
Bye!

Nico


madjic (BOB member since 2004-07-06)