I do have this file and have been looking over it. What I most need to do
is have a way to tell Crystal Reports what database file to use while
generating its report. I found an example that lets you change the DSN, but
that doesn't help since I have 1 DSN and many many different database files.
Supposedly, there is an example in that file you mentioned, but I don't know
enough about ASP to find it. You wouldn't happen to know which file that
example is in, or how to do it, would you?
Todd
----- Original Message -----
From: "Terri Stocke" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, August 07, 2001 12:55 PM
Subject: Re: Crystal Reports without cfreport
|
| 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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
