<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>I have modified the order reports to include some new reports,
including 'pending orders. 'shipped orders', and 'canceled
orders'.<br>
</p>
<p>During the report generation, I have added an items field and
would like for the first 4 items of each order be looked up from
orderline and placed into the table data for that field.</p>
<p>Example</p>
<table border="0" cellspacing="0" cellpadding="0" width="90%">
<tbody>
<tr class="rnorm" border="4">
<td valign="top"><font color="#000000"><a
href="https://huldaclarkparazapper.com/cgi-bin/cart.cgi/admin/order_view?order=HCPZ55305&id=du6akAKs&mv_pc=123">HCPZ55305</a></font></td>
<td valign="top"> petz_UZI </td>
<td valign="top"> <br>
</td>
<td valign="top"> Sunny </td>
<td valign="top"> Keala, HI </td>
<td valign="top"> 20180221 04:02:49 </td>
<td valign="top" align="right"> $300.70 </td>
<td valign="top" align="right"> pending </td>
</tr>
</tbody>
</table>
would become
<table border="0" cellspacing="0" cellpadding="0" width="90%">
<tbody>
<tr class="rnorm" border="4">
<td valign="top"><a
href="https://huldaclarkparazapper.com/cgi-bin/cart.cgi/admin/order_view?order=HCPZ55305&id=du6akAKs&mv_pc=123">HCPZ55305</a></td>
<td valign="top"> petz_UZI </td>
<td valign="top"> pz30050<br>
pz00008<br>
pz00019m<br>
</td>
<td valign="top"> Sunny </td>
<td valign="top"> Keala, HI </td>
<td valign="top"> 20180221 04:02:49 </td>
<td valign="top" align="right"> $300.70 </td>
<td valign="top" align="right"> pending </td>
</tr>
</tbody>
</table>
<br>
<br>
<br>
Any suggestions on how to accomplish this. I have tried several
different ways of looking it up from orderline but none have worked
so far.<br>
<br>
<br>
</body>
</html>