Wrox Home  
Search P2P Archive for: Go

  Return to Index  

asp_web_howto thread: Problem passing string parameters to a Crystal Reports report from ASP


Message #1 by "Kathy Egan" <kathy.egan@h...> on Thu, 6 Dec 2001 19:34:48
I'm invoking Crystal Reports v7.0 from an ASP page (ASP v2, IIS v4, NT 4).  

My report runs against a SQL Server v7.0 stored procedure that has a number 

of parameters.  I am setting the parameters in the ASP code like so:



set param1 =  session("paramCollection").item(1)

call param1.setCurrentValue (cint(int1),7)

set param2 =  session("paramCollection").item(2)

call param2.setCurrentValue (cstr(str1),12)



The integer parameters are being passed properly (i.e., the stored 

procedure runs and the correct data is displayed), however, when I pass 

string parameters and use the strings in the WHERE clause of the query, I 

get no data. If I run the stored procedure outside of Crystal with the 

string, I get data.  I also verified that Crystal is accepting the 

parameter by displaying the string on the report.



Does anyone know if there is a problem passing string parameters from ASP?  

Do I need to "cast" the string into some other data type prior to 

submitting it to Crystal?  Help!


  Return to Index