How can I use a parmeter to define the where clause of my report?

[tinagoepp]

Hello together,

 

I've got a question I'd like to create a report where I could type in the ID at first (Parameter) and then the report appears. All values of the report depend on the ID.  

 

Is this possible and how could I implement this?

 

Thank you for your help!

[hozawa]

Yes. Just create a parameter and use it in your dataset queries.

Refer to the following page for further details.

http://community.jaspersoft.com/documentation/tibco-jaspersoft-studio-user-guide/v610/using-parameters-queries-1#jss-user-parameters_221620694_1025261

[jo.jasmine]

Hi Tina,

below is the sample where clause that should like in your sql. Here ID is your database column, P_ID is the parameter name

where ID = $P{P_ID}. Then go to parameters tab, create a new parameter of data type either string or number and enable (check) the prompt button.

That's it. Run the report and see how it works now