2005 IR Help Posted September 2, 2006 Share Posted September 2, 2006 By: Alex - aartini How to use parameters for the WHERE clause 2005-08-03 15:08 I'd like to define more than one condition in a WHERE clause. So I've defined query with: where $P{where} "Where" parameter's defined as java.lang.String and "is for prompting". When I run report and I use: parameter.put ("where", condition") report returns: "the document has no page" but if I execute the complete query (also with where condition that I pass via parameter) I get data. It seems the report executes a query different from how I think it should do. Is it possible to pass a string to the report containing all where condition? Is it possible using where $P{cond} ? cond may be "test1 and test2 and test3.... I'd appreciate any comment or help. Alex By: neptune22 - neptune22 RE: How to use parameters for the WHERE claus 2005-08-03 22:44 SELECT * FROM TABLE $P!{WHERE} By: Marcia - marciapcp RE: How to use parameters for the WHERE claus 2005-08-04 04:55 SELECT FIELD1,FIELD2,FIELD3 FROM TABLE WHERE FIELDn = $P{PARAMETER} But if you are using the Wizard tool you must pass a value to this parameter and after, with the report on screen, you can access the select and change to take the parameter passed.(like the example) Remember that you must have this parameter at Parameters List and to test the report inside the software this one must be for prompt. By: Alex - aartini RE: How to use parameters for the WHERE claus 2005-08-05 11:56 Thanks for your help, I will try to do it. But someone can explain me the difference using $P{str} and $P!{str}? In which situations I have to use "!"? Thanks Alex By: armov - armov RE: How to use parameters for the WHERE claus 2005-08-05 23:47 The $P! use t when you have to evaluate the expression after the query... By: armov - armov RE: How to use parameters for the WHERE clause 2005-08-04 06:44 Why don't you just pass over the whole query? I think is better. inside iReport: write in the query: $P!{[query]}. Notice the ! sign. outside iReport: pm.put("[parameter name]",new String"[query]"); By: Burcu - naughty_girl RE: How to use parameters for the WHERE clause 2005-08-26 00:56 Where do you mean ouside iReport?Where should i write this?I will be grateful if you help me. 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