cfreport

Description

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.

Category

Extensibility tags

Syntax

<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, cfexecute, cfindex, cfobject, cfsearch, cfwddx

History

New in ColdFusion MX: Crystal Reports 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.

Attributes

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';"

Usage

This tag requires an end tag.

Example

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

Comments