Passing parameter from master report

[mhbashar1]

Could anybody pls tell me what parameter to set both in master report and sub-report for the following query which is in master report-

Code:

SELECT DISTINCT
     purchase_date
FROM
      purchase
WHERE MONTH(purchase_date)=$P!{month}	AND YEAR(purchase_date)=$P!{year}

The value for $P!{month} and $P!{year} will be passed from my java app.There are two other sub-reports which also need these month and year parameter.

 

I tried but failed,there is a little problem somewhere.

PLS HELP ME.

[andysusanto]

hai,

 

select properties of subreport then click subreport(other) put your parameter of subreport on the left side, the right side is master parameter

 

Regards,

[shalomd]

thanks! this was a great help

 

Shalom Dinur