how to select multiple value of a multi select list(checkbox) in jasper server

[kavita.negi]

I have a input control that shows checkboxs to select any particular value .By default one  value ( top most) is selected.

I want to select all the values of a  mutiselect check box by default on jasper server.

 

Kind regards,

Kavita

 

[ajinkya_c]

Hi,

Try optional prompt with input control so that if no values check then it takes all values of list by default.

Or

Use optional prompt with dynamic where condition i.e (where condition in parameter $P!{})

If no value select from list then where condition not involve in query hence all values get from list. 

Hope this helps.

Thanks,

Ajinkya

 

[kavita.negi]

would you specify the query syntax how to use where

[ajinkya_c]

Select *

From Table_name

Where F2=$P{P2}

$P!{P1}

P1 parameter expression== iif(($P{P1}==null? ' ' :  "AND F1=$P{P1}")

So if no values select from list then no parameter used in where condition.

When some value select from list then AND F1=$P{P1} part involved in query.

Thanks

Ajinkya

[kavita.negi]

Hi ajinkya_c

 

Thanks for answer .I read article but I am confused .How the things happen.

 

[kavita.negi]

I found a solution to my problem 

by modyfing the default parameter template file and setting the checked option true .It show all the values selected .

But while getting these parameters inside custom jre source java code they are empty. Will you explain why nothing is transfer even after puttting check mark on all check boxes.