Horizontal Columns by Group?

[2005 IR Help]

By: Rich Johnson - rwj999

Horizontal Columns by Group?

2004-09-22 13:27

Hello all,

 

Is it possible to print data horizontally by group rather than by the detail record?

 

I have several records that contain a Category (Fruit, Vegetable, etc) and an Item (Apple, Carrot, etc)

 

I'm grouping on the category and have a detail section for each item

 

For example:

 

I would like the following layout

 

Fruit Vegetable

----- ---------

Apple Carrot

Orange Broccoli

Peach

 

Vehicle Tree

------- -------

Car Maple

Truck Poplar

Ash

 

With horizontal print order I get:

 

Fruit

-----

Apple Orange

Peach

 

Vegetable

---------

Carrot Broccoli

 

Vehicle

---------

Car Truck

 

Tree

---------

Maple Poplar

Ash

 

With Vertical print order I get

 

Fruit Vechcle

----- --------

Apple Car

Orange Truck

Peach

 

Vegetable Truck

---------- ---------

Carrot Maple

Broccoli Poplar

Ash

 

While the vertical print order is close to what I want visually, I need my columns to read left to right, not up to down.

 

If anyone could shed some light on this I'd greatly appreciate it.

 

Thanks in advance

 

Rich

 

 

 

 

By: Rich Johnson - rwj999

RE: Horizontal Columns by Group?

2004-09-23 06:06

<br>Sorry, my previous post lost its formatting. Here it is again in HTML.<br><br>

 

<br>I would like the following layout<br><br>

 

<table width="30%" border="0" cellspacing="0" cellpadding="0">

<tr>

<th align="left">Fruit</th>

<th align="left">Vegetable</th>

</tr>

<tr>

<td>Apple</td>

<td>Carrot</td>

</tr>

<tr>

<td>Orange</td>

<td>Broccoli</td>

</tr>

<tr>

<td>Peach</td>

<td> </td>

</tr>

<tr><td colspan="2"> </td></tr>

<tr><th align="left">Vehicle</th><th align="left">Tree</th></tr>

<tr>

<td>Car</td>

<td>Maple</td>

</tr>

<tr>

<td>Truck</td>

<td>Poplar</td>

</tr>

<tr>

<td> </td>

<td>Ash</td>

</tr>

</table>

 

<br>With horizontal print order I get:<br><br>

 

<table width="30%" border="0" cellspacing="0" cellpadding="0">

<tr>

<th align="left">Fruit</th>

<th align="left"> </th>

</tr>

<tr>

<td>Apple</td>

<td>Orange</td>

</tr>

<tr>

<td>Peach</td>

<td> </td>

</tr>

<tr><td colspan="2"> </td></tr>

<tr>

<th align="left">Vegetable</th>

<td> </td>

</tr>

<tr>

<td>Carrot</td>

<td>Broccoli</td>

</tr>

<tr><td colspan="2"> </td></tr>

<tr>

<th align="left">Vehicle</th>

<td> </td>

</tr>

<tr>

<td>Car</td>

<td>Truck</td>

</tr>

<tr><td colspan="2"> </td></tr>

<tr>

<th align="left">Tree</th>

<td> </td>

</tr>

<tr>

<td>Maple</td>

<td>Poplar</td>

</tr>

<tr>

<td>Ash</td>

<td> </td>

</tr>

</table>

 

<br>With Vertical print order I get<br><br>

 

<table width="30%" border="0" cellspacing="0" cellpadding="0">

<tr>

<th align="left">Fruit</th>

<th align="left">Vehicle</th>

</tr>

<tr>

<td>Apple</td>

<td>Car</td>

</tr>

<tr>

<td>Orange</td>

<td>Truck</td>

</tr>

<tr>

<td>Peach</td>

<td> </td>

</tr>

<tr><td colspan="2"> </td></tr>

<tr><th align="left">Vegetable</th><th align="left">Tree</th></tr>

<tr>

<td>Carrot</td>

<td>Maple</td>

</tr>

<tr>

<td>Broccoli</td>

<td>Poplar</td>

</tr>

<tr>

<td> </td>

<td>Ash</td>

</tr>

</table>

<br>While the vertical print order is close to what I want visually, I need my columns to read left to right, not up to down<br><br>