Separate HTML for Basic Foil 33 Using CFREPORT to Add Crystal Reports Output

Basic HTML version of Foils prepared May 3 1998

Foil 33 Using CFREPORT to Add Crystal Reports Output

From Java Blend and Cold Fusion High Level Database Interfaces CPS616 Web Technologies -- Spring 98. by Chao Wei Ou

This example uses a function to determine the application page path. The report displays only those records that match ZIP code and last name criteria entered into an HMTL form:

<CFREPORT REPORT="#GetDirectoryFromPath

(Application PagePath)#myreport.rpt"

{ZipCode} = "#Form.ZipCode#" AND

{LastName} like "#Form.LastName#*"

</CFREPORT>

If you have any comments about this server, send e-mail to webmaster@npac.syr.edu.

Page produced by wwwfoil on Sat Nov 28 1998