Wednesday, July 25, 2018

BI Publisher label printing

If you're looking to print labels using XML and BI Publisher, there are lots of posts on how to do it with BI Publisher commands, but I was never able to get it to go. I merely added MOD(ROWNUM,X) to the end of my select that generates the XML (where X is the number of columns of labels you're printing). Then this column can be used as a conditional region to determine where across the page to print. In your RTF, use tables to contain label information so it remains uniform on each page. Create a table with one row and the number of columns of labels you're printing. Give the cells in the table a height a little bigger than your label height. In each of those cells, create a single cell table that is the size of your individual label. Within each of those you will insert individual label information. In the inner box of each label, create a repeating group, followed by a condition region, followed by label fields. The conditional region determine where to print. In this case it is the ADDRESS_ROWNUM column that was added. When ADDRESS_ROWNUM = 1, it prints on the left. When ADDRESS_ROWNUM = 0 it prints on the right. Outside of the inner box, end the condition region, then end the repeating group. Below is an example: I hope that helps.

No comments:

Post a Comment