×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

CFreport

How can i call a crystal report then ? by ibearian
Posted: 10 Jul 03

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 !

Back to Adobe FAQ Index
Back to Adobe Forum

My Archive

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close