dibyasagar Posted February 23, 2017 Share Posted February 23, 2017 i have a table named accounts which has two columns as shipping_address_country and shipping_address_city. so i made two parameters named:- country and city (both have data type as string). now i have two input controls. the first input control is named country which selects countries from the table accounts. the query is select shipping_address_country from accountsthe second input control is named city and its query is select shipping_address_city from accounts where $X{EQUALS,shipping_address_country,country} i want to populate country on the first control and then its city accordingly on the second control.for now i get error that says No clause function for id EQUALS found. Link to comment Share on other sites More sharing options...
Solution reportdev Posted February 23, 2017 Solution Share Posted February 23, 2017 There is No $X{EQUALS} condition in Jasper.as per documentationhttp://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v60/using-parameters-queriesuse $X{EQUAL, column_name, param_name}or $X{IN, column_name, param_name} Link to comment Share on other sites More sharing options...
dibyasagar Posted February 24, 2017 Author Share Posted February 24, 2017 using EQUAL actually worked. but the problem now i am facing is that i need to deselect already selected value on cityinput control. like say:- if i have selected usa as country it populates new york. it is fine till here. now i select uk as countrythen the city value selected is still new york and i have to choose deselect(---) first then only i can change value to london on second input control. i want to change value to london automatically if i choose country as uk. thanks Link to comment Share on other sites More sharing options...
reportdev Posted February 24, 2017 Share Posted February 24, 2017 Use $X{IN} condition. it changes dynamically 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