How to Build Reports in ColdFusion

The Adobe ColdFusion family of products includes a number of capabilities important to business users. Among these are the ability to create and deploy databases and Internet applications. ColdFusion users can also build custom reports that provide real-time results to end users. The report wizard function built into Adobe ColdFusion makes it easy for even first-time database creators to build custom reports and tweak them to meet the needs of end users.

Instructions

1

Log on to your PC and open ColdFusion. Open the file you want to use to create the report.

2

Start "Report Builder" and choose the "Report Creation Wizard" option. Click the "Query Builder" button.

3

Click the plus sign next to the database pane and select the database you want to use. Click the plus sign next to the tables folder and double-click the table you want to base the report on.

4

Double-click additional tables if you want to base the report on more than one table in your database. The report builder tool automatically adds that table and displays the list of fields it contains. Double-click the fields you want to include in your report. Continue choosing all the fields you want to include in the report. Click the "Test Report" button to see the results of your query.