Mailing Label Report

How can I create a multi column report where each column in a detail data row would contain data for a different data record?

For example, to create mailing labels in three columns, in the first detail row customer 1 would be in the left column, customer 2 would be in the middle column, and customer 3 would be in the right column. The second detail row would be customer 4, customer 5, and customer 6. And so on.

I tried creating a 3 column table, but I couldn't figure out how to define the individual data elements in each column so that data from a new data record would be displayed.

Any suggestions how to accomplish this?

Find more posts tagged with

Comments

mwilliams

Hi jjfeigal,

This report should help you out with that. It was created with BIRT 2.2.2.

jjfeigal

<blockquote class='ipsBlockquote' data-author="mwilliams">Hi jjfeigal, 
 
This report should help you out with that. It was created with BIRT 2.2.2.</blockquote>
 
Thanks for the quick response. 
 
My initial attempt at this report was one table with three columns rather than your report using a three column grid where each column included a single column table. I modified my report to look like your report (e.g., a grid with tables), but I still don't see data values for three unique dataset records in each row. The data for each column in a row is the same. 
 
I reviewed the xml for your report and don't see any scripting which does any special handling of the data prior to presentation. Is there something that I am missing that will present data for three different dataset records in each row? Is the "Row Number" data element in each dataset record used for this processing?

mwilliams

jjfeigal,

There are filters on each table that use the row number to separate which records go in which table.