parameter query

[mhbashar1]

I have the following query in my master report-

 

SELECT purchase_item,purchase_date

FROM purchase

Where MONTH(purchase_date)=$P{month} AND YEAR(purchase_date)=$P{year}

 

where $P{month}and $P{year} is parameter for month and year respectively.Now how should I provide this month and year from my java application with Map collection.Can I do the following-

Code:

static HashMap <String,String> map=new HashMap<String,String>();
map.put("month",12);
map.put("year",2008);
JasperFillManager.fillReport(reportFile, map, jdbcConnection);

[andysusanto]

hai,

 

yes you can do it just make sure the you already define the name of paremeter that you want.

 

if you want to check your parameter click View menu than

 

see the Parameter

 

 

Regards,