Hi,

What iam trying to do is pull order information from database. If i enter order id the report should bring only that particular order. I could retrieve in access but CF report iam confused. Below is my code. With below query when i enter the order number it s brining up complete records available in database. And us CFreport builder to pull reports.

[code]
<cfif isDefined("form.submit")>
<cfreport template="#print#" format="#ftypeall#"/>
</cfif>

<cfform format="flash" height="600" skin="halosilver" width="600" title="ARCHIEVED ORDERS">
<cfformgroup type="panel" label="ARCHIEVED ORDERS">
<cfformgroup type="hdividedbox" label="PRINT ORDERS">
<cfformgroup type="panel" label="PRINT ORDERS">
<cfformgroup type="horizontal">
<cfinput type="text" name="enter" width="100">
<cfselect name="print" label="OPTIONS" width="150">
<option value="1.cfr">ORDER ID</option>
<option value="2.cfr">REFERENCE NUMBER</option>
<option value="3.cfr">PO</option>
</cfselect>
<cfselect name="ftypeall" id="ftypeall" width="90">
<option value="Flashpaper">Flashpaper</option>
<option value="PDF">PDF</option>
<option value="EXCEL">EXCEL</option>
</cfselect>
</cfformgroup>
<cfinput type="submit" name="submit" value="PRINT" width="150">
</cfformgroup>
</cfformgroup>
</cfformgroup>
</cfform>
[\code]

The records that the report builder files shor use either an internal query or an external query. If you specify an external query (with query="queryname") the external query is used.

So if you run a query that restricts to just the record you want, then run the report using that query, you should be OK.