<CFREPORT REPORT="report_path"
    ORDERBY="result_order"
    USERNAME="username"
    PASSWORD="password"
    FORMULA="formula">
 
</CFREPORT>

CFREPORT runs a predefined Crystal Reports report.

REPORT

Required. Specifies the path of the report. Store your Crystal Reports files in the same directories that you store your ColdFusion page files.

ORDERBY

Optional. Orders results according to your specifications.

USERNAME

Optional. The username required for entry into the database from which the report is created. Overrides the default settings for the data source in the ColdFusion Administrator.

PASSWORD

Optional. The password that corresponds to a username required for database access. Overrides the default settings for the data source in the ColdFusion Administrator.

FORMULA

Optional. Specifies one or more named formulas. Terminate each formula specification with a semicolon. Use the following format:

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

If you need to use a semi-colon as part of a formula, you must escape it by typing the semi-colon twice (;;), for example:

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