Programming ColdFusion

Name

CFREPORT

Synopsis

<CFREPORT> ... </CFREPORT>

Executes a predefined Crystal Reports report and populates it with data from a ColdFusion template. In order to use this tag, you must have Crystal Reports installed on your ColdFusion server.

Attributes

REPORT=" report_path "

The full path to the Crystal Report file to be executed. Required.

ORDERBY=" result_order "

Orders results according to your specifications. Optional.

USERNAME=" username "

A username for the database providing data for the report. Optional. If a username is specified, it overrides the value set in the ColdFusion Administrator.

PASSWORD=" password "

Password associated with USERNAME. Optional. If a password is specified, it overrides the value set in the ColdFusion Administrator.

FORMULA=" formula "

One or more named formulas within the report. Separate formula parameters with semicolons. If the formula contains a semicolon, it should be escaped by doubling it up. Optional.

TYPE=" report_type "

The type of HTML that should be used to generate the report. Options are Standard, Netscape, and Microsoft; they refer to the web browser the report is destined for. This attribute can be dynamically set by first determining the browser in use with the CGI variable HTTP_USER_AGENT. The TYPE attribute isn’t documented in the Allaire documentation and was designed to overcome a problem using CFREPORT with Crystal Reports 8.x. When using the CFREPORT tag in versions of ColdFusion prior to 5.0 to generate a report ...