Mailing Label Report

[jjfeigal]

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?

[mwilliams]

Hi jjfeigal,

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

[jjfeigal]

Originally Posted by mwilliams

Hi jjfeigal,

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

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.