2005 IR Help Posted August 27, 2006 Share Posted August 27, 2006 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> Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now