Multi-select prompt issue

[Kumar_rahul]

Hi All,

 

I have a multi-select prompt which is populated by data fetched from database. It is implemented using $X{IN,field,parameter}

 

There is a string which begins with a "tab-space". When a user selects this particular value we get an error: "net.sf.jasperreports.engine.JRRuntimeException: Multi parameters cannot contain null values."

 

Any ideas/ suggestions?

 

Thanks and Regards,

Kumar Rahul.

[Kumar_rahul]

Any thoughts on this...

 

Regards,

Kumar Rahul.

[swood]

I think the tab-space is being lost as it is converted to HTML and back.

 

Can your SQL query for the control encode those values and then decode them in the parameter in the JRXML?

 

 

Sherman

JasperSoft

[Kumar_rahul]

Can your SQL query for the control encode those values and then decode them in the parameter in the JRXML?

 

How exactly do i do that? I have been trying to accomplish this for long but to no avail.

 

Thanks,

Rahul.

[swood]

You can create a query based input control. These have a display name and a value behind the scenes. There is an example of this in the User Guide - look for "Single Select Query".

 

 

Sherman

JasperSoft

[Kumar_rahul]

Hi Sherman,

 

Thanks for your response.

 

I guess my query was not properly framed. I have been using query based input control query for long without any issues. What I was interested in was "encode those values and then decode them". I wanted to know how actually can I encode and decode a value fetched from a query.

 

Rahul.