I took a look at some of the ASP examples, and of course they made it look like you needed about 200 lines of code to accomplish calling Crystal. Now, likely that's not true, but I haven't found a good, simple ASP example online yet. I don't have any issue rolling a non-CF solution for this one piece.
Josh > -----Original Message----- > From: Dan O'Keefe [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 31, 2003 2:52 PM > To: CF-Talk > Subject: RE: Bloody CFReport > > > What about calling it from an ASP page. I played around with that some > time ago, and I have a project where I will need to do that soon. > > Dan > =================== Previous Message Below =================== > > > -----Original Message----- > From: Ian Skinner [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 31, 2003 2:28 PM > To: CF-Talk > Subject: RE: Bloody CFReport > > > You might be in trouble. I fought with this myself about a year ago for > a project. I learned at that time that Crystal NO LONGER supports > CFReport. They have gone their own way, and they want you to use THEIR > system. I can only offer you sympathy and a hardy Good Luck. I never > did get it to work, and we ended up rolling our own CF - RTF report > system. > > -------------- > Ian Skinner > Web Programmer > BloodSource > Sacramento, CA > > > -----Original Message----- > From: Josh Remus [mailto:[EMAIL PROTECTED] > Sent: Thursday, July 31, 2003 11:21 AM > To: CF-Talk > Subject: Bloody CFReport > > > Okay - I've seen in many cases out there while googling for help that > many people have been unable to get CFReport to work at all. I believe > I have installed it correctly, however I must be doing some slight thing > wrong that is keeping me from my goal. I have tried several different > things, > including: > 1. Moving the report in question from ODBC to Native, etc. > 2. Trying a simple report (with no database fields involved) - this > worked fine. But as soon as I added even one database field, it failed. > 3. Combinations of username and password, no user name, no password, > all of the above. > > The error that I'm getting most of the time is: "An unexpected error > occurred while using the Crystal Engine. Error number 599 occurred > (Cannot open SQL server.)." I believe the call is getting to Crystal, > just not getting back. My RESPONSE.INI file has the following lines in > it: > > [ReportStatus] > ReportSucceeded=0 > ReportErrNumber=599 > ReportLibInfo=<P>Crystal Library = C:\WINNT\System32\CRPE32.DLL > (2/10/2001 > 1:43) <BR>DLL Version = 8.80, Engine Version = 8.80 > > The code for the page in question is this: > <cfreport report="c:\Inetpub\wwwroot\crm_production_tree\PEPs\test.rpt" > username="#Request.UserName#" password="#Request.Password#" > type="microsoft"> </cfreport> > > The file does exist, I can open it, verify the database, refresh data, > etc., from the server machine successfully. Request.UserName & Password > are correct. I've also tried hard-coding them in. I've tried it with > and without the type="microsoft". > > I'm hoping that someone will have some new idea on what to try. I > appreciate any help I can get! > > Thanks! > --- > Josh Remus > Network Manager > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
