Columns within Columns

[RexesOperator]

Is it possible to do columns within columns in a report?

I have a report with three columns on the page. There is one field in the detail section. There will be several hundred or more items in the field. I have a roster list of companies and contacts with the file numbers associated with each contact. The layout is three columns. In the detail section is one field - file numbers. When that list grows to several hundred it starts to use up a lot of space on the printout.

I guess what I am asking is can the detail section also be set up with columns?

 

[WayneRyan]

RO,

If you mean that you have a report like:

Field1 Repeating Field 1 Field2
====== ================= ======
F1     RF1               F2
       RF2
       RF3
       RF4
...

It really depends on how your data is structured.

Is the Repeating Field in a child table?

Need more info,
Wayne

 

[gemma-the-husky]

to do columns in a report. set columns in file/pagesetup/columns

then design your report so that the detail occupies only a fraction of the width of the page

ie 1/2 width for 2 columns
1/3 width for 3 columns

does that help?

 

[stopher]

to do columns in a report. set columns in file/pagesetup/columns

then design your report so that the detail occupies only a fraction of the width of the page

ie 1/2 width for 2 columns
1/3 width for 3 columns

does that help?

Adding to Gemma's comment, you can do columns and sub columns. To do this you need to create a subreport to show your child data and set the columns (as described by Gemma) for both your main report and your sub report. So you could have two Region columns, then in each Region column you could have 3 Customer columns. Obviously you need to ensure your page width will accomodate 6 customer fields wide in this example.

Chris

 

[RexesOperator]

I have played around with a sub report, but not effectively. But you have given me some ideas. The repeating field is not in a child table, but could it be done with a query/sub query? That will be my next attempt. I will look at that on the weekend.