Parameter is not prompting
Posted on November 2, 2017 at 2:25am
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?
Joined: May 24 2017 - 10:18pm
Last seen: 1 year 5 months ago
Posted on November 2, 2017 at 3:49am
Hi,
what is the class of the parameter in iReport? It should be Collections.
How do you refer to the parameter in query?
Joined: Jul 25 2017 - 5:43am
Last seen: 5 years 4 months ago
Posted on November 2, 2017 at 4:01am
Hi Joe,
Class is java.util.Collection
in 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}))
Joined: May 24 2017 - 10:18pm
Last seen: 1 year 5 months ago
Posted on November 2, 2017 at 6:10am
Hi himanshu17sept,
have you tried to set the nested type of family_LOV parameter to string?
Joined: Jul 25 2017 - 5:43am
Last seen: 5 years 4 months ago
