Becky,
Here's an example that passes date variables from cf to cr to filter the
date range of the report.
The "GetDirectoryFromPath" part was a key in getting it to work.
BTW, this is using CF 3.1 and CR 6 so YMMV...
<CFREPORT
REPORT="#GetDirectoryFromPath(CF_TEMPLATE_PATH)#crname.rpt"
DATASOURCE="ALPHA">
{AREANOTE.UNIT_ID}="#UnitID#" AND
{AREANOTE.REPORT_DATE} >= Date(#start_year#, #start_month#,
#start_day#) AND
{AREANOTE.REPORT_DATE} <= Date(#end_year#, #end_month#,
#end_day#)
</CFREPORT>
HTH.
Ben Braver
Information Technology
Ultramar Inc.
Golden Eagle Refinery
150 Solano Way
Martinez, CA 94553-1487
(925) 370-3673 voice
(925) 370-3393 fax
(510) 716-2557 pager
[EMAIL PROTECTED]
-----Original Message-----
From: Jones, Becky [mailto:[EMAIL PROTECTED]]
Sent: Friday, April 27, 2001 12:08 PM
To: CF-Talk
Subject: cfreport
does anyone have any examples using the cfreport tag? i have a few cf books
and none of them go into any detail how to use it.
thanks,
bec.
*************************************************
This e-mail, including any attachments, is intended for the
receipt and use by the intended addressee(s), and may contain
confidential and privileged information. If you are not an intended
recipient of this e-mail, you are hereby notified that any unauthorized
use or distribution of this e-mail is strictly prohibited.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists