Accessibility

Table of Contents

  1. Introduction
  2. Getting Familiar with the New CFREPORT Tag Syntax
  3. Introducing the ColdFusion Report Builder
  4. Building a Sample Report
  5. Building a Query for Your Report in the Query Builder
  6. Formatting Your Report
  7. Browsing Your Report

Building Reports with ColdFusion MX 7

Getting Familiar with the New CFREPORT Tag Syntax

The cfreport tag has undergone some slight revisions. Aside from still supporting its usual syntax that supports Crystal Reports integration, the new syntax is as follows:

<cfreport
     template = "report definition filename"
     format = "PDF or FlashPaper" or "excel"
     name = "cf variable"
     filename = "output filename"
     query = "query variable"
     overwrite = "yes" or "no"
     encryption = "128-bit" or "40-bit" or "none"
     ownerpassword = "password"
     userpassword = "password"
     permissions = "permission list"
>
     cfreportparam tags [optional]
</cfreport>

The ColdFusion MX 7 Reporting Solution

The ColdFusion reporting solution contains two parts: a report engine and a report designer.

The report engine contains the following functionality: graphing capability, columnar layouts, support of report runtime input parameters, and the ability to output in three formats (Adobe PDF, Macromedia FlashPaper, and Microsoft Excel). You can output these files directly to a browser, save them to disk, or send them through e-mail.

The report feature gives ColdFusion developers many advantages over third-party solutions:

  • It understands CFML expressions
  • It can use data sources defined in the ColdFusion Administrator
  • It has access to shared scopes

The report builder contains the following wizards to help you create reports:

  • Report Creation Wizard
  • Chart Wizard
  • Subreport Wizard
  • Server Setup Wizard

Let's discuss the report builder some more.

Page 2 of 7
Previous Page
Next Page