himanshu17sept Posted November 2, 2017 Share Posted November 2, 2017 I have created a multiselect parameter in the iReport tool with an Prompt option checked, when i run through front end (jasper server) is not showing any prompt (blank page). If i remove the multiselect parameter and add a normal data parameter single select then its working fine.can anybody tell me Whats the mistake in that? Link to comment Share on other sites More sharing options...
Joe_123 Posted November 2, 2017 Share Posted November 2, 2017 Hi,what is the class of the parameter in iReport? It should be Collections.How do you refer to the parameter in query? Link to comment Share on other sites More sharing options...
himanshu17sept Posted November 2, 2017 Author Share Posted November 2, 2017 Hi Joe,Class is java.util.Collectionin query i am handling like below:($P{Para_Family} IS NOT NULL AND $X{IN, 'All', family_LOV} AND upper(item.item_family) LIKE upper($P{Para_Family})) Link to comment Share on other sites More sharing options...
Joe_123 Posted November 2, 2017 Share Posted November 2, 2017 Hi himanshu17sept,have you tried to set the nested type of family_LOV parameter to string? Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now