snehilitech04 Posted August 15, 2017 Share Posted August 15, 2017 hiI have added few parameters in my report and one of those parameter need default value which values are present in one table how can i set these values in that parameter as default value expression. Link to comment Share on other sites More sharing options...
H Mendoza Posted August 15, 2017 Share Posted August 15, 2017 This is usually done via the properties of the parameter. There is a default expression field where you can supply a value of some sort. Link to comment Share on other sites More sharing options...
snehilitech04 Posted August 15, 2017 Author Share Posted August 15, 2017 I tried default expression field there i am able to pass some default value manually just like new 'ArrayList(Arrays.asList("abc","def"))' but not able to pass any query here. Link to comment Share on other sites More sharing options...
H Mendoza Posted August 15, 2017 Share Posted August 15, 2017 Just a suggestion:Have you tried using $P!{}Create another parameter, add your query, call that parameter from your other parameter using the $P!{} syntax. Link to comment Share on other sites More sharing options...
mlopez_1 Posted August 16, 2017 Share Posted August 16, 2017 I only use ' Arrays.asList("abc","def") ', the input control must be multiselect query, and parameter must be java.util.List exactly with the same ID.Finally, in the query I use AND $X{IN, FIELD, PARAMETER_ID}Mariano 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