Multiple Columns 1

[rbh123456789]

CR 11.5

I have a report that has one field in the details section.
There is lots of data, so the report ends up being over 200 pages.

How do i format the report so i can have that one field changed from this:

1
2
3
4
5
6
7
8
9

to this:

1 4 7
2 5 8
3 6 9

 

[fisheromacse]

This is untested and off the top of my head, but i think it should give you 3 detail items for each 'row'. You will need to put the //Collect formula in the details section and suppress the details section, then place the //Display formula in a group (or report) footer section, and check the 'can grow' option on the Common tab of the Format Field options.

//Collect
Whileprintingrecords;
stringvar collect;
IF recordnumber = 1 OR remainder(recordnumber,3)<>1 then
collect := collect & {table.field} & " "
else
(
IF recordnumber <> 1 AND remainder(recordnumber,3)=1 then
collect := collect & chr(13) & {table.field} & " "
else collect := collect
)

//Display
whileprintingrecords;
stringvar collect;
collect

 

[lbass]

Go into the sectione expert->details->format with multiple columns->layout tab->set the width and gap->check "down, then across". You will have to play with the width and gap until the number of desired columns is forced.

-LB

 

[rbh123456789]

lbass - thanks, but this did not resolve my problem.
See the image below. There is still only one column streaming down the page.

 

[lbass]

What did you enter for width and gap? It should be something like 2" for width and .5 for gap. As I said, you have to play with this.

-LB

 

[fisheromacse]

oh geeeesh, how could i not think of formatting the details w/columns. Nothing like trying to do things the hard way.

In my defense i did just spend hours re-installing and patching out a new VM for Server2008, and i still have 1 patch/update that refuses to go...thanks MS! smooth products as usual. LOL

thanks for coming to the rescue lbass!!

 

[rbh123456789]

fisheromacse - i appreciate the help anyway!
lbass....you nailed it, thanks a lot!