2-column report

[victora]

How can i print a 2-column-per-page report. I'm trying to create a Provider Directory that prints 1-12 records on the first column and records 13-24 on the second column...So its like 24 records per page.

thanks

victora

 

[synapsevampire]

Right click the details section and select format section->Select Format with multiple columns->Click the Layout tab.

Or if you're starting from scratch, pick a mailing label type of report, it will have a canned choice of Audio Cassette (Avery 5198) which is 6 down by 2 across.

-k

 

[bdreed35]

victoria:

You can create columns in the detail section of your report by doing the following:

1. Right click in the grey area to the left of the report
2. Select Format Section
3. In the Section Expert, highlight Details and select "Format with Multiple Columns" check box
4. A new tab called Layout will be created. Click on it.
5. Set up the width you desire for you columns. You can divide your available page width by 2 to start.
6. Select Down the Across and Click OK
7. Now set up your fields on the left and they will be duplicated on the right.

You will either need to size your detail section to break to the new column after 13 records, or you will need to create some formulas to limit it to 13. ~Brian

 

[synapsevampire]

Oooops, you wanted 12x2, select 0.8 as the label height.

-k

 

[victora]

Thank you guys, VERY MUCH...

 

[akabatman2]

Hi all,

I have a similar problem to Victoria. I am interested in what formula I can use per group to specify the number of lines printed in the first column, before the data moves to the 2nd column.

For instance:
1st Change of Group, records 1-26 print in column1, 27-51 print in column 2.
2nd Change of Group, records 1-15 print in column1, 16-30 print in column 2
3rd Change of Group, records 1-18 print in column1
(3rd change of Group ends at 18 records and then a new group begins)
4th Change of Group, records 1-30 print in column2

Any suggestions would be most appreciated.

Thanks,

Tom

 

[synapsevampire]

Since columns can extend beyond pages, the formula might get a little hairy.

Are you wondering the qty per page, or per group?

If by group the formulas below should get you there.

Otherwise, you'd have to know the total lines that can display on the page (printer/font dependent), the height of the group header and footer, etc.

Are you starting separate pages per group and no group will extend beyond a full page? If so, that greatly simplifies the complexity, but it still won't be easy.

Anyway, here's some theory:

This tells you the row count for a group:

Count ({table.Name}, {Table.State})

where {table.name} is the field being counted, {table.State} being the group.

So this gets you 1/2 of that:

int(Count ({table.Name}, {Table.State})/2)

So the next column starts at the above +1.

There's the numbers, hope it helps to get you there.

-k