Feh, that's basically what I expected to hear. I really only need something for printing contracts (which have to be built for a specific printer), so maybe I'll just built that piece in Access & link it to the SQL database. I'm tired of fooling with it.
Josh > -----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 Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
