Parameterizing select parameters

[gkari]

Hi All,

We are evaluating Japser Reports as a potential reporting solution for our application.(Icefaces, JSF on Glassfish)

We've looked into creating templates, formatting ans exporting the report into different formats and understand that run time parameters can be passed for conditional query.

for eg.

<parameter name="city" class="java.lang.String"/>

select customername, age, address, telno from customer where city=$p{city}

Is  there a way to parametrise the selecte parameters so that the user can be given the option of choosing the details he wants to view in the report?

For e.g select $P!{options} from customer

As far as my understanding goes, this is not possible since we have to define all the selection fields in the report template and those cannot be provided at runtime. Please correct me if I am wrong.

Also, can Jasper Reports be easily integrate with JSF/Glassfish. Any pointers would be greatly appreciated.