pass the report parameter to stored procedure

[2001 JI Open Discussion]

By: dolesz - zselod

pass the report parameter to stored procedure

2004-05-29 14:44

Hi ,

Did anyone succeed to pass the report parameters with iReports to a stored procedure in the Datasource/Report Query?

If I use an sql with $P{param1} in it ,works, but

in the form:

'storedprocedure_example $P{param1}'

gives a syntax error when retrieveing the fields

I tried with different data types for the parameter:

param1:Integer,@param1:Integer (of the stored procedure) param1:String, @param1:char,varchar,nchar,text... and also a param1:Date, @param1:Datetime combination