User Guide

362 Chapter 2: ColdFusion Tags
cfreport
Description
Used to do either of the following:
• Execute a report definition created with the ColdFusion Report Builder, displaying it in PDF,
FlashPaper, or Excel format. You can optionally save this report to a file.
• Run a predefined Crystal Reports report. Applies only to Windows systems. Uses the
CFCRYSTAL.exe file to generate reports. Sets parameters in the Crystal Reports engine
according to its attribute values.
Category
Data output tags
Syntax
<!--- Syntax 1 - Use this syntax with the ColdFusion Report Builder. --->
<cfreport
template = "report definition filename"
format = "PDF or FlashPaper" or "excel"
name = "cf variable"
filename = "output filename"
query = "query variable"
overwrite = "yes" or "no"
encryption = "128-bit" or "40-bit" or "none"
ownerpassword = "password"
userpassword = "password"
permissions = "permission list"
>
cfreportparam tags [optional]
</cfreport>
OR
<!--- Syntax 2 - Use this syntax with Crystal Reports. --->
<cfreport
report = "report_path"
dataSource = "ds_name"
type = "type"
timeout = "number of seconds"
orderBy = "result_order"
username = "username"
password = "password"
formula = "formula">
</cfreport>
See also
cfcollection
, cfdocument, cfdocumentitem, cfdocumentsection, cfexecute, cfindex,
cfobject, cfreportparam, cfsearch, cfwddx; Chapter 32, “Creating Reports for Printing,” in
ColdFusion MX Developer’s Guide; Report Builder online Help