NCHASHIM Posted November 14, 2019 Share Posted November 14, 2019 I am using TIBCO Jaspersoft® Studio - Visual Designer for JasperReports. 6.2.1 All of the reports that I've worked with earlier have either had no parameters (rare) or they have a query-generated parameter list from which the operator chooses one to many values.Is there any way to give the opertor a blank entry line? They want to enter the selection criteria as comma separated list of values. Meanwhile, I am also trying to verify that I can take that comman separated list of values, recreate it as an array and use it in $X{IN, field_name, array_name) statement.However, first I need to find out if the input control can be a blank line for operator-entered-data. Link to comment Share on other sites More sharing options...
trvpseudo Posted November 19, 2019 Share Posted November 19, 2019 hi pal!insert 'Yes you can! just do it!' meme lolfirst u have to query normally, fix data case like "select * from dual where dummy = 'X' " when initiate new reportsthen in the left bottom outline box, theres parameter.u can create ur parameter there and chose its type in the properties in right bottom.also dont forget to make it always prompt in the propertiesif done, lets say the param u create is "INPUT_TEXT"then right click the report and change the query to "select * from dual where dummy = $P{INPUT_TEXT}" ($P{} stands for parameters)the next time u execute the report there will be input type text asking an input before the report generate.use that knowledge anywhere u need and i hope that helps!*note : after change the query make sure to 'read fields' to make sure theres no error.regards, TV - noobie as well :D 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