How can add query with parameter inside report?

[subodhjoshi82]

 

Hi,

I am creating report with the help of ireport4.5.0 . I am newbie on Jasper reort. can anyone tell me how can create a report which contain query and we pass the parameter to report . And same report file will work with Java web application.

Thanks

[mgeise]

To reference a parameter in your query you would write your query in similar to the following:

Select x, y, z from table where col1 = $P{parameter_name}

Then, assuming that you are deploying to JasperReports Server, you would set up an input control with the same name as the parameter to allow your end users to set the value of the parameter.  

Here is some additional information on using parameters in reports: http://community.jaspersoft.com/wiki/using-report-parameters

[subodhjoshi82]

Thanks for your reply . Can it be possible control over query. i added query inside filename.jrxml or fileName.jasper but can it be possible with Java code that i will execute query of jasper or jrxml file and then set reult to Jasper page

[bafana710]

I tried the select statement mentioned here and I inserted it on my .jrxml file source code but its mnot working