Multiple Columns -- Down then Up

[nlaliberte]

I'm using Crystal XI and an OLE DB Connection.

Basically I have a report that looks something like this.

Report Header A
Report Header B
Report Header C
Details
Report Footer A
Report Footer B


The Report Headers and Footers are pretty important legal mumbo-jumbo, and it's very important that this report stay on one page. There will never be more than 15 or so details and they are very small width wise ('Fund -- Commitment Amount), but the way it is set up if there are more than 10 details than it pushes my footers onto another page.

I would like to use the 'Format with Multiple Columns' (Down then Across) functionality, but I can't seem to get it to work right.

Is it possible for me to set the detail number on which it will start a new column? I would like it to list them in increments of say 5. First 5 in one column, next 5 in the second column, last 5 in the third column.

This would allow enough room below the detail section for the Report Footers to stay on Page 1.

Is this possible?

 

[lbass]

Create a formula {@cnt}:

whilereadingrecords;
numbervar cnt;
numbervar i;
numbervar j;
numbervar x := 5;//change to reflect the number desired per column

for i := 1 to 3000 do //hardcode the maximum number of records instead of 3000
(
if cnt in (i*x)-(x-1) to x*i then
j := i
);
j

Insert a group on this formula. Format the detail section to multiple columns->layout->set the width and gap->down then across->format groups in multiple columns. Then in the main screen of the section expert, format the group footer to "print at bottom of page." This will force a column break per set of x number of records. You can suppress the group header, but NOT the group footer. You would then have to use the new group footer for your report footer fields. You can insert a second group footer, and then suppress the report footer.

-LB

 

[kyzina]

I have similar report but I have:

Group HeaderA: DeptName
Group HeaderB: Name
Group HeaderC: title
Detail: Pnone.

Did you find any solution for the multipe column formatting