Jump to content
Changes to the Jaspersoft community edition download ×

Cannot pass parameter to nested dataset


dching

Recommended Posts

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.

converted-file.png.3e2664902c2058fd4e879b105aeab1ef.png

 

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

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Posted Images

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...