akash.sky96 Posted March 25, 2016 Share Posted March 25, 2016 I have two parameters 1. boolean 2. String so i have to change if type='k' then checkbox boolean parameter value to be true else false otherwise.Please let me know the answer . its urgent requirement.Thanks,Akash Link to comment Share on other sites More sharing options...
Sukanya Parisa Posted March 25, 2016 Share Posted March 25, 2016 write a query for your boolean paramter as select case when $P{StringTypeParameter}='k' then 'true' else 'false' end from dual then if you select 'k' in the first parameter then your second parameter will get true in that. Link to comment Share on other sites More sharing options...
akash.sky96 Posted March 25, 2016 Author Share Posted March 25, 2016 We are passing parameter value from jasper report URL, For example, Jasper report URL is http://<JasperServer>/JasperReportName&type=kand Parameter form contain input control (check box)so, when user hit the report URL with type=k then check box control should be checked, and if type=null then it won't. Link to comment Share on other sites More sharing options...
akash.sky96 Posted March 29, 2016 Author Share Posted March 29, 2016 Hello Parisalakshmi,There is no way to pass query to boolean parameter so how did you achieve this.Please help me .Thanks,Akash 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