Record Formating 1

[dawtes]

Hi,

I have a report which has one group and about 25 records in the detail section from one field. Is there anyway to break the report when it reaches the 5th record and to start a new column.
Thanks
Example

Group A

Field A
1
2
3
4
5
6
7
8
9
10
.
.
.
Change to

Group A
A A A
1 6 11
2 7 12
3 8 13
4 9 14
5 10 15

 

[smcnulty2000]

Tricky problem.

My solution:
Build a report that uses multiple columns (open section expert and click on the details section, a checkbox should be available), set the layout tab with a width of .75" or so. Suppress the headers and footers leaving only the details showing. Save this report.

Next you build a new report, and bring the previous one in as a subreport. Set it's 'Can Grow' setting OFF. Then run it.

You should be able to resize it so it will recolumn every fifth record, or every sixth, or whatever you like at this point. Link the subreport in as you need to.

Cool problem.

Scott.