Homecoding.com
CODE WEEWHO EH?
<!--- fetch a new order--->
<CFQUERY NAME="getOrder" DATASOURCE="#DSRCE#">
Select id as id,
SiteID,orderdate,Contact,OrderstatusID,ordertype,
installexpdate,shiptoname,shiptoaddress1,shiptoaddress2,
shiptocontact
from SBCOrders
where
left(ordertype,2) = 'SO'
and orderstatusid in (#NOTD#)
and picklistprinteddate is null
and exists (select 1
from SBCOrderlineitems
where orderid = sbcorders.id
and statusid = #NJR#)
     </CFQUERY>
<table align=center border=3 bordercolor=red><cfoutput>
<tr><td align=center><H3> PICK LIST REPORT COVERSHEET </H3>#font#
<SCRIPT Language="Javascript"> 
var NS = (navigator.appName == "Netscape");
var VERSION = parseInt(navigator.appVersion);
if (VERSION > 3) {
    document.write('<form><input type=button value="Print this REPORT" name="Print" onClick="printandgo()"></form>');       
}

I can help your website and database get the job done and the report formatted correctly.