<CFREPORT REPORT="report_path" ORDERBY="result_order" USERNAME="username" PASSWORD="password" FORMULA="formula"> </CFREPORT>
CFREPORT runs a predefined Crystal Reports report.
Required. Specifies the path of the report. Store your Crystal Reports files in the same directories that you store your ColdFusion page files.
Optional. Orders results according to your specifications.
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.
Optional. The password that corresponds to a username required for database access. Overrides the default settings for the data source in the ColdFusion Administrator.
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';"