Cannot pass parameter to nested dataset

[dching]

I'm using Jasper IReport builder 5.6.

I have a report with a query of below where I just return  record.

select 1 from dual;

On my detail band I aded a table componenet with query below and grouping of deptno

select * from emp

On the dept no group header I added a table component with query of

select * from dept where deptno >= $F{deptno}

Basically for the group heading I need to print 1 or many rows (this is a unique requirements of mine).

This works ok but I need to pass a parameter from the detail dataset to the dept dataset (dept group heading with table).

If I add the parameter below to my data set I get an error. Please Note Dataset ServiceMeter = Dept in my example above.

 

Error filling print... net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : 
    Source text : $P{pSID}
net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.fill.JRExpressionEvalException: Error evaluating expression : 
    Source text : $P{pSID} 
    at net.sf.jasperreports.engine.fill.JRFillSubreport.prepare(JRFillSubreport.java:809)

 

I did verify that the pSID parameter is on the dataset and all the queries including the main has parameter of pSID.

 

Thanks