View Full Version : 2 db records on a single print line


upsman
08-21-2005, 04:05 PM
I need to be able to print 2 database records on a single report line. It needs to be a 2-up report but they are not labels. Here's an example

db record 1 dbrecord 1 db record 1 db record2 db record 2 db record 3
field 1 field 2 field 3 field 1 field 2 field 3

Each record contains a field called 'Block'. I need to print the odd-numbered 'Blocks' on the left side of the page and the even-numbered 'Blocks' on the right side. How can I do this?

Bhaughbb
08-22-2005, 08:24 AM
I may not be fully understanding what you need but my approach would be to use the Columns feature in reports and depending on the specific needs of the rest of the report use them in a sub report to display the detail records.

You can define them in the page setup while editing the report and make the columns wide enough that 2 fit on a page side by side within the margins. As long as your odd and even numbered blocks are actually every other record line in your results you are using this could solve your needs.