showing items in order reports - solved

     <TD VALIGN=top>
     <table width="10%" border=0 cellpadding=0 cellspacing=1>
[query list=1 table=orderline sql="select * from orderline where 
order_number = '$line->{order_number}'" ignore_undefined=1]
             <tr class="[sql-alternate 
2]rowalt[else]rownorm[/else][/sql-alternate]" valign=top>
                <td>[sql-param sku]</td>
             </tr>
[/query]
          </table>

     </TD>


The above code was added to the pending orders report to show the items 
in each order.

html code for resulting table below:


<TABLE width="90%" border=5 cellpadding=0 cellspacing=0><tr 
class=rborder height=1><td colspan=7></td></tr><TR class=rmarq><TD 
VALIGN=top >Order </TD><TD VALIGN=top>Affiliate </TD><TD 
VALIGN=top>Items </TD><TD VALIGN=top>Name </TD><TD VALIGN=top>Address 
</TD><TD VALIGN=top>Date/Time </TD><TD ALIGN=right VALIGN=top>Amount 
</TD><TD ALIGN=right VALIGN=top>Status </TD></TR><tr class=rborder 
height=1><td colspan=7></td></tr><TR class=rnorm BORDER=4><TD 
VALIGN=top><A 
HREF="https://huldaclarkparazapper.com/cgi-bin/cart.cgi/admin/order_view?order=HCPZ55370&id=fBLKERzq&mv_pc=168">HC15300</A></TD><TD 
VALIGN=top>paradevi&nbsp; </TD><TD VALIGN=top><table width="10%" 
border=0 cellpadding=0 cellspacing=1><tr class="rownorm" 
valign=top><td>pz40066</td></tr></table></TD><TD 
VALIGN=top>Hullsby&nbsp; </TD><TD VALIGN=top>Clinton, MA </TD><TD 
VALIGN=top>20180430 03:09:31 </TD><TD ALIGN=right VALIGN=top>$479.15 
</TD><TD ALIGN="right" VALIGN=top >pending </TD></TR><TR class=rnorm 
BORDER=4><TD VALIGN=top><A 
HREF="https://huldaclarkparazapper.com/cgi-bin/cart.cgi/admin/order_view?order=HCPZ55371&id=fBLKERzq&mv_pc=169">HC15301</A></TD><TD 
VALIGN=top>pzcom&nbsp; </TD><TD VALIGN=top><table width="10%" border=0 
cellpadding=0 cellspacing=1><tr class="rownorm" 
valign=top><td>pz00024</td></tr><tr class="rowalt" 
valign=top><td>pz40066</td></tr></table></TD><TD 
VALIGN=top>Youngoos&nbsp; </TD><TD VALIGN=top>Thomas, CA </TD><TD 
VALIGN=top>20180430 10:44:22 </TD><TD ALIGN=right VALIGN=top>$571.00 
</TD><TD ALIGN="right" VALIGN=top >pending </TD></TR><tr class=rborder 
height=1><td colspan=8></td></tr><TR class=rnorm><TD VALIGN=top>GRAND 
TOTAL </TD><TD VALIGN=top>&nbsp; </TD><TD VALIGN=top>&nbsp; </TD><TD 
VALIGN=top>&nbsp; </TD><TD ALIGN=right VALIGN=top>&nbsp; </TD><TD 
ALIGN=right VALIGN=top>&nbsp; </TD><TD ALIGN=right VALIGN=top>$1,050.15 
</TD><TD ALIGN=right VALIGN=top>&nbsp; </TD></TR><tr class=rborder 
height=1><td colspan=8></td></tr></TABLE>

_______________________________________________
interchange-users mailing list
[email protected]
http://www.icdevgroup.org/mailman/listinfo/interchange-users