Crystal Reports professional comes with a 5 user license agreement that will allow up to 5 reports run at a time. I have not used cfreport with Crystal, but I have used ASP and I know with ASP, the licenses can get eaten up pretty quick. (Crystal keeps track of the open objects and will not allow any more to be launched past your license) We had to purchase a "universal connector license" or something like that to allow our company access. It was not very cheap at all and we have around 500 users. I inherited this project after the decision to use Crystal was made and they won't tell me how much they spent on it. All I know is that they weren't real happy when I suggested we dump Crystal and go with a straight CF/ASP/JSP solution. Needless to say, I am stuck with it for a while ....
Good Luck! Tim P. ----- Original Message ----- From: "Gieseman, Athelene" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, April 02, 2002 8:09 PM Subject: RE: CFREPORT and Error 500 > I use Crystal 8.0 web page server. It's very easy to pass information from > CF to the Crystal report. The following is an example of what I've done > that has worked for me: > > <cflocation > url="http://kcweb/firmdaily/isweb/ISBudget/PO.rpt?Prompt0=#FindPO#";> > > FindPO is the variable I'm sending from CF. It is the first Prompt variable > in the report. If I were to send another, I'd add it to the end as Prompt1. > > E.g.: > > <cflocation > url="http://kcweb/firmdaily/isweb/ISBudget/PO.rpt?Prompt0=#FindPO#&Prompt1=# > TheOtherVariable#"> > > This has worked reliably for me. One word of caution though. I understand > from someone on another list that version 8.5 requires a license for each > person who runs a report off of the web page server. I haven't verified > with Seagate. But if it's true, it would be way too expensive for us to use > (with about 1000 users.) Maybe someone on this list can answer if they've > used the latest version and if there is a licensing issue. > > Athelene Gieseman > [EMAIL PROTECTED] > > > > -----Original Message----- > From: Rick Walters [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, April 02, 2002 1:14 PM > To: CF-Talk > Subject: Re: CFREPORT and Error 500 > > In the CF Forums you can find a lot about using CFReport. Last I > checked the tag was depreciated since version 5 of Crystal Reports. > Crystal has it's own webserver product now. Crystal seems to have spent > a good deal of time integrating their product with ASP. I also remember > some undocumented features to the CFReport tag you must use to pass > parameters to the newer versions. Check the Forums. I hope the info is > still there. If not, send me a direct email and I'll dig about my own > archives for some of the examples I downloaded. Keep in mind that > Crystal is on version 8 now. CFReport is meant to work with Version 5. > > Hope that helps. > > > Good Fortune, > Richard Walters, > Webmaster, Davita Laboratory Services > [EMAIL PROTECTED] > (800) 604-5227 x 3525 > > >>> [EMAIL PROTECTED] 04/02/02 01:25PM >>> > I am trying to pass a variable to CFREPORT and I continue to receive > the > following. There is very little on the Allaire discussion forums about > this. > I am running CF 5 and CR 8.5. I thought the previous problems > regarding > CFREPORT has been fixed in CF 5. Anyone have an idea on this? > > Error Diagnostic Information > Error occurred while processing CFREPORT > > > An unexpected error occurred while using the Crystal Engine. > > Error number 500 ocurred (Not enough memory for operation.). > > Crystal Library = C:\WINNT\system32\CRPE32.DLL (2/10/2001 1:43) > DLL Version = 8.80, Engine Version = 8.80 > > > The error occurred while processing an element with a general > identifier of > (CFREPORT), occupying document position (9:1) to (9:59). > > > Date/Time: 04/02/02 11:02:09 > Browser: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0; T312461) > Remote Address: 129.43.39.167 > > Alan L. Wolf > MCSE, MCP, MCP + I > SAIC Frederick > PO Box B Bldg 458 > Frederick, Maryland 21702 > [EMAIL PROTECTED] > 301-846-5479 (V) > 301-846-6886 (F) > > > ______________________________________________________________________ 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 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
