Printing multiple records in 1 row

[dstepans]

Hello,

I have a table that has only 2 fields. Printing 1 record per row, is a waste of space. I would like to print 2 records per row. Ex:
record1 | record2
record3 | record4
record5 | record6

Is that possible to do?

Thanks,
Denis

 

[pgtek]

Hi
inser your field in the detail section
and in the format section choose layout and there you can specified colummn and rows

cheers


pgtek

 

[bdreed35]

Choose Format --> Section
Highlight Details.
Check the option "Format with Multiple Columns" in the bottom right.
This creates a new tab at the top called "Layout".
Click the Layout tab.
Set the width of your detail section. If you want 2 columns, divide your total page width in half and put the number there.
Set the printing direction to Across, then Down.
Close and Test.


~Brian

 

[dstepans]

Thanks for replies guys.

But that devided the whole detailed section in two. I have several detail sections: Details a - Details n.

I have a subreport from which I want to print 2 records per row in Detail b, so I need this to work only for Detail b.

Is it possible?
Denis.

 

[lbass]

Do you mean the subreport only displays in detail_b? Then use "format multiple columns" within the subreport to achieve this.

Otherwise, if you were trying to do this with fields, I think you could use the "next" function and lay out the fields like:

{table.field} {@nextfield}//where {@nextfield} = next({table.field})

And then suppress every other detail_b section using:

remainder(recordnumber,2) = 0

-LB

 

[dstepans]

Thanks guys. "format multiple columns" within the subreport did it.
Sorry for so many questions, just started using CR.

I got one more problem.

When it is not enaugh space on the current page for the subreport to print all its records it scips the current page completely and starts on the next, so I have half the page left blank. What I would like it to do is the subreport to start printing on current page and if there is not enaugh space, then print the only the rest of the records on a new page. I unchecked Keep Together checkbox both in the Main's report Details b and in the Details section of subreport but that didn't solve the problem. This is the second subreport in the Main report. For the first subreport to solve this problem I moved everything above it to the page header.
What can I do to solve this problem for the second report?

TIA.
Denis

 

[lbass]

It might help to select the subreport, right click->format subreport->common and uncheck "Keep object together."

-LB

 

[dstepans]

Thanks LB! That did it.

Denis