santosh.audi19 Posted July 4, 2016 Share Posted July 4, 2016 Hello All,I'm Curious to know about this special Parameter $P!{}.I came to know that it is used :- "To send pieces of raw SQL or to pass the entire SQL string to execute" ,Could any one suggest me simple report with an example how to use it.Thanks. Link to comment Share on other sites More sharing options...
kkriplani Posted July 4, 2016 Share Posted July 4, 2016 Lets suppose I have the following query,Select L_name, age_1,$P!{check} as Characteristicfrom tableThis paramater allows me to view the various characteristics of the person I am refering above. It would be dependent on another parameter, let us call that parameter as $P{value}. In the default expression of the parameter "check", I could define the following;$P{value}==1 ? "Physical_strength" : $P{value}==2 ? "IQ": "Nature";Depending on the various values of $P{value}, the parameter "check" will input the values into the query and mind you, the above three stated characteristics are nothing but the table columns, so basically we are displaying different columns based on the parameter "value".For instance, the parameter "value" was entered as 2, so my running query would look like (which you can check in the logs); select L_name, age_1, IQ as characteristics from tableHope this explains all.Regards,KKriplani Link to comment Share on other sites More sharing options...
hozawa Posted July 5, 2016 Share Posted July 5, 2016 Check the following page. It contains explanation and a link to a sample.http://jasperreports.sourceforge.net/sample.reference/query/ 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