cfreport

Runs 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.

Extensibility tags

<cfreport 
   report = "report_path"
   dataSource = "ds_name" 
   type = "type" 
   timeout = "number of seconds" 
   orderBy = "result_order"
   username = "username"
   password = "password"
   formula = "formula">
</cfreport>

cfcollection, cfexecute, cfindex, cfobject, cfsearch, cfwddx

ColdFusion MX: Changed data source connection behavior: Crystal Reports now establishes an independent connection to the data source. The connection is not subject to any ColdFusion data source-specific restrictions. For example, the Crystal Reports server can access a data source, regardless of whether it is disabled in the ColdFusion Administrator.

Attribute Req/Opt Default Description

datasource

Optional

 

Name of registered or native data source.

type

Optional

standard
  • standard (not valid for Crystal Reports 8.0)
  • netscape
  • microsoft

timeout

Optional

 

Maximum time, in seconds, in which a connection must be made to a Crystal Report.

report

Required

 

Report path. Store Crystal Reports files in the same directories as ColdFusion page files.

orderBy

Optional

 

Orders results according to your specifications.

username

Optional

 

Username required for entry into database from which report is created. Overrides default settings for data source in ColdFusion Administrator.

password

Optional

 

Password that corresponds to username required for database access. Overrides default settings for data source in ColdFusion Administrator.

formula

Optional

 

One or more named formulas. Terminate each formula with a semicolon. Use the format:

formula = "formulaname1 = 'formula1';formulaname2 = 'formula2';"

If you use a semicolon in a formula, you must escape it by typing it twice (;;). For example:

formula = "Name1 = 'Val_1a;;Val_1b';Name2 = 'Val2';"

This tag requires an end tag.

<!--- This view-only example shows the use of cfreport --->
<h3>cfreport Tag<h3>
<p>cfreport lets reports from the Crystal Reports Professional report writer
display through a ColdFusion interface. To run, the tag requires the 
name of the report. cfreport can also pass information to the report 
file displayed, to change the output conditions.
<p>This example would run a report called "monthlysales.rpt " and pass it an
optional filter condition to show only the information for a subset 
of the report.

<cfreport report = '/reports/monthlysales.rpt'>
     {Departments.Department} = `International'
</cfreport>

<p>Substitute your report files and filters for this code. cfreport can put 
Crystal Reports into web pages.

View comments on LiveDocs