Hi Todd,
Yep, it sure is possible. Here's how we did it, after having no luck with
CFREPORT (CF 4.0 Enterprise). It wasn't easy, but we finally figured it out.
We pass the CF variables into an ASP page, and then call the CFREPORT from
the ASP page. If you go to Crystaldecisions.com and search for a download
called ASPXMPS8, it will give you all of the examples you need. Of course,
you also need the Web Component Service running on your server as well (so
Crystal Reports can serve the report up via the browser). Here are my tips:
This is how I passed the information from my page to the ASP page. Note that
these are hidden fields only because these values came from my form page. If
you have no interim page, you can just send the info directly from your form
page:
<cfform name="continue" action="http://ourserver/open_rpt.asp";
method="post">
<cfoutput>
<input type="hidden" name="reportname" value="#form.reportname#.rpt">
<input type="hidden" name="param1" value="cursor">
<input type="hidden" name="param2" value="#form.param1#">
<input type="hidden" name="param3" value="#form.param2#">
<input type="hidden" name="param4" value="#sessid#">
<input type="hidden" name="promptOnRefresh" value="0">
</cfoutput>
Note that the field names are named "param1", "param2", etc. This is what
you need to name them. Crystal Reports will use whatever is in param1 as its
first parameter, whatever is in param2 as its second parameter, etc.
The files you will need from the examples on CrystalDecision's site are:
open_rpt.asp (the main file--this is where you would change the dsn/pw info)
rptserver.asp (I'm no ASP expert, but somehow this file tells ASP how to
communicate with Cr. Rpts.)
AlwaysRequiredSteps.asp (an include for open_rpt)
MoreRequiredSteps.asp (another include for open_rpt)
the JavaViewer and/or ActiveX viewer (allows the report to be viewed in the
browser).
Not being an ASP person, I didn't know how to fix this particular problem,
but if you try to pass more parameters/fields than what open_rpt is
expecting, you will get an error.
Be patient. You will probably get alot of errors until you get this right ;)
----Original Message Follows----
From: "Todd Ashworth" <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: CF-Talk <[EMAIL PROTECTED]>
Subject: Crystal Reports without cfreport
Date: Fri, 17 Aug 2001 10:07:09 -0400
Does anyone have an example of connecting to a Crystal Reports report
without using cfreport? Can this even be done?
Todd
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
