[Parameters as Column Name on query]

 Thanks it work fine..

 

 

 

 

Regards

Javaiiispl.

[Date problem]

 I am new ireport..

can anyone help me how to pass date value from java to ireport(jasper).....

[iReport and parameters]

 can anyone help me how to pass date value from java to ireport(jasper).....

[How to use optional parameters]

 I got solution for above issue.

Just pass the query as

SELECT *  FROM admin WHERE ((age=$P{age} or $P{age} is null)  and (tnumber=$P{tno} or $P{tno} is null))

This will show necessary output.

[How to use optional parameters]

 Hi i am using IReport/Jasper Reports and the query for my situation is

 

SELECT *  FROM admin WHERE age=$P{age} and tnumber=$P{tno}

 

Now i am getting input for both fields ie age and tnumber from user.

In this case three possible condition occurs

cond1:- user may enter both age and tumber fields

cond2:-  user may enter only age

cond3:- user may enter only tnumber

 

Above query is executed only if user enters both values, if user enters value for a single field it shows document has no pages.

 

i want to satisfy all my condition(cond1,2,3) in a single query, Please help me by suggesting necessary query for above condition..

 

Thanks in advance..

 

[Optional Parameters in SQL]

 Hi i am using IReport/Jasper Reports and the query for my situation is

 

SELECT *  FROM admin WHERE age=$P{age} and tnumber=$P{tno}

 

Now i am getting input for both fields ie age and tnumber from user.

In this case three possible condition occurs

cond1:- user may enter both age and tumber fields

cond2:-  user may enter only age

cond3:- user may enter only tnumber

 

Above query is executed only if user enters both values, if user enters value for a single field it shows document has no pages.

 

i want to satisfy all my condition(cond1,2,3) in a single query, Please help me by suggesting necessary query for above condition..

 

Thanks in advance..

 

[Optional Parameters in SQL]

 Me too have same problem.

I dont know how to use optional parameter, please help me..

 

Thanks in advance..