Home
Analytics
Labels from BIRT
chandra t
<p>I need to generate label reports from BIRT reports , Is there any specific template ? or is that a regular</p>
<p> </p>
<p>report printed on a label?</p>
<p> </p>
<p>Thanks</p>
<p>Z</p>
Find more posts tagged with
Comments
wwilliams
<p>You can make a template if you think you would use it more than once, or just use one of the maximo templates like the list report and edit it accordingly.</p>
rdpeterson
<p>I designed my own label making report that works well. It has the following features:</p>
<ol><li>A blank master page with nothing in the header or footer with margins set according to the particular labels I'm using.</li>
<li>A report query that returns Oracle ROWNUM system field along with the rows returned.</li>
<li>A report with Body containing a single grid with the number of columns in the label page, and a single row.</li>
<li>A separate table inserted into each cell in the grid linked to the same data set in the report.</li>
<li>Set the filter property for each table using an expression in the form "BirtMath.mod(row["rownum"],{N}) = {column number} where N = number of columns on the label page. This is the math modulus function. This ensures that the results are printed sequentially utilizing all columns on the label page from left to right repeating each row.</li>
<li>Query fields are laid out as desired with exact and equal measurements for width of the parent grid's columns, or total width of the tables in each column. The height of the rows are also given exact values such that the total height of all rows to be displayed matches the vertical spacing of labels on the printed page.</li>
</ol><p>I also added printing instructions in the master page header small enough to print above the actual label area on the printed page. Mine say this: "Note: print on Avery Label #5160 with 8-12x11" paper. Before printing, please ensure you are using the following settings in the final print settings dialog box: Page Scaling - None, Auto-rotate and Center - Disabled, Choose Paper Source by PDF page size - Disabled."</p>
<p> </p>
<p>I hope this helps.</p>