How can i call a crystal report then ?

Calling a crytsal report without the <cfreport> tag is easy when you know how. The example below is based on a accounts database and in VALUE1 is equal to starting account number and VALUE2 is equal to ending account value

SELECTION PAGE

<FORM action="index_act.cfm" method="post">
<INPUT NAME="VALUE1" TYPE="text">
<INPUT NAME="VALUE2" TYPE="text">

<input type="submit" value="submit">
</FORM>

ACTION PAGE

This page isn't really needed but show you the logic. It appends the url to include PROMPT0, PROMPT1, PROMPT2 etc with the values you have selected. I have found to make this work you can only use discrete paqrameters (only one prompt per paramters). If you need to do a range then use the BETWEEN selection funtion and put paramter1 in the top box and parameter2 in the bottom.

<cfoutput>
<cflocation url="sql.rpt?prompt0=#form.value1#&prompt1=#form.value2#">
</cfoutput>

This calls the report and uses the parameters (as far as i'm aware you need CE installed). If you want to disable any feature then i'm afriad you need to use the ASP alternative


I can claim little inginuity for this and must quote PHILEDGE as the guru who told me !