cfreport

Overview ColdFusion Open BlueDragon Lucee

Used to do either of the following: - Execute a report definition created with the ColdFusion Report Builder, displaying it in PDF, FlashPaper, or Excel format. You can optionally save this report to a file. - Run 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.

Attributes

Name Required Type Default Description
datasource No String Name of registered or native data source.
encryption No String none Specifies whether the output is encrypted. PDF format only. Default: none
filename No String The filename to contain the report. You cannot specify both name and filename.
format No String Specifies the output format.
formula No String 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';"
name No String The name of the ColdFusion variable that will hold the report output. You cannot specify both name and filename.
orderby No String Orders results according to your specifications.
overwrite No Boolean false Specifies whether to overwrite files that have the same name as that specified in the filename attribute. Default: false
ownerpassword No String Specifies an owner password. PDF format only.
password No String Password that corresponds to username required for database access. Overrides default settings for data source in CFML Administrator.
permissions No String Specifies one or more permissions. PDF format only. Separate multiple permissions with a comma.
query No String The name of the query that contains input data for the report. If you omit this parameter, the report definition obtains data from the internal SQL or from cfreportparam items.
report No String Report path. Store Crystal Reports files in the same directories as CFML page files.
8
resourcetimespan No VariableName Life span of the resource directory. Used only with format=HTML
8
style No String Style in CSS format that overrides a style defined in the Report Builder report at run time.
template No String Specifies the path to the report definition file, relative to the web root.
timeout No Numeric Maximum time, in seconds, in which a connection must be made to a Crystal Report.
type No String standard * standard (not valid for Crystal Reports 8.0) * netscape * microsoft
username No String Username required for entry into database from which report is created. Overrides default settings for data source in CFML Administrator.
userpassword No String Specifies a user password. PDF format only.