Jump to content

Initializing parameters


Recommended Posts

Can somebody help me to intialize the following parameters in iReports for Jasper reports?


1. Initialise string parameter(java.lang.String)


Report had a parameter called P_IDS(String datatype) which passes a comma separated list. I would like to initialize this parameter to 9999. What should i give in "Default parameter expression" for this? I tried "9999", but it didnt work in the SQL query which has

...empid in ($P!{P_IDS})


If i give as 9999, i get the error 'Cannot convert from int to String)



2. Initialise a date parameter which is passed as String datataype


I would like to initialise date field which is passed as string datatype to report query.

How is this possible to intialise this parameter as "07/01/2006"


How can i initialise a date parameter to beginning year start date (01/01/2006) which is passed as string datatype.


Also i need to intialise the date parameter(java.util.Date) type as today date( without time stamp)


Thanks for ur help.

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...