Jump to content
Changes to the Jaspersoft community edition download ×

pass the report parameter to stored procedure

Recommended Posts

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

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...