[Re:How to use parameter in ireport]

 Thanx Augart   now problem is solved , i was mistaking in default value of parameter .

i was giving only xyz  and after ur reply i gave "xyz " now its working.

once again thanx for help 

 

[Re:How to use parameter in ireport]

sorry name of parameter are system1,system2 but   i am doing same thing as u said--

 

 

select .............

where   system_name in ($P!{system1},$P!{system2})

and.........

group by ..............

 

i found another link for this 

http://jasperreports.sourceforge.net/sample.reference/query/index.html

here method is different 

 

[Re:How to use parameter in ireport]

I have defined two parameter name system_name1,system_name2 as value expression text

and default value for system_name1 is xyz and for system_name2 is abc

 

where system_name in ($P!{system1},$P{system2!})

 

error-

sourcefile inline evaluation of : ''xyz:" illegal use of undefined variable class,or void literal

[Re:How to use parameter in ireport]

Thanx Augarte for reply,

              i have tried this but still i m not getting solution

Post Edited by shatad0101 at 06/23/2011 07:40

[Passing a parameter in IN clause of SQL]

iancr01
Wrote:

You can also use: select ... where $X{IN, colname, parameter name} "parameter name" is a parameter of type Collection or array.

 

 

Hi,

 

Today I was trying to  use parameter in where clause

such as--

 

select emp_salary,last_name

from employees

where emp_id in ($p{id1},$p{id2})

 

but i m getting error so how to

figure out this problem plz help me

 

Is it possible to do such a thing with iReport and JasperReport ?

[Re:How to use parameter in ireport]

   Hi,

 

 

I am sharad and i m new in ireport and currently i am using ireport 4.0.0 version

and i am getting some error

Code:

Today I was trying to  use parameter in where clausesuch as-- select emp_salary,last_namefrom employeeswhere emp_id in ($p{id1},$p{id2}) but i m getting error so how tofigure out this problem plz help me Is it possible to do such a thing with iReport and JasperReport ?

[How to dynamically hide columns into a table ?]

fchalmeau
Wrote:

Hi,   Today I was trying to  use parameter in where clause such as--   select emp_salary,last_name from employees where emp_id in ($p{id1},$p{id2})   but i m getting error so how to figure out this problem plz help me   Is it possible to do such a thing with iReport and JasperReport ?