Now I'm getting the following error. What am I missing? Quotes around the form parameter? Sorry for the beginner question.
Error Occurred While Processing Request Error Diagnostic Information An error occurred while evaluating the expression: "http://s049188/itweb/testreport.rpt?music.artistcode=#form.artistcode#" Error near line 9, column 18. ---------------------------------------------------------------------------- ---- Error resolving parameter FORM.ARTISTCODE The specified form field cannot be found. This problem is very likely due to the fact that you have misspelled the form field name. The error occurred while processing an element with a general identifier of (CFLOCATION), occupying document position (9:1) to (9:104) in the template file c:\inetpub\wwwroot\itweb\report.cfm. Date/Time: 04/03/02 10:05:11 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) -----Original Message----- From: Gieseman, Athelene [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 02, 2002 8:10 PM To: CF-Talk 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists