AnsweredAssumed Answered

Jaspersoft Cascade Input control displays only one row

Question asked by vs00500773 on Jun 12, 2018
Latest reply on Jun 13, 2018 by vs00500773

Jaspersoft studio 6.4.2

 

I have two inputs controls.  Portfolio and Programs

 

I'm trying to create cascade input control so the display of second value is based on the first value selected.

 

I want to display the programs based on the portfolio I select.  I get only one program name when I select the portfolio whereas the portfolio has more than one programs

 

Any help/pointer is greatly appreciated

 

SELECT DISTINCT PFM.ID,pfm.code, pfm.name, prg.code Program_ID
, prg.name Program_Name
from inv_investments prg
LEFT OUTER JOIN inv_hierarchies ih
ON ih.parent_id = prg.id
LEFT OUTER JOIN inv_investments prj
ON prj.id = ih.child_id
LEFT OUTER JOIN srm_resources res
ON res.user_id = prj.manager_id
LEFT OUTER JOIN pfm_investments pinv
ON pinv.investment_id = NVL(prg.id, prj.id)
LEFT OUTER JOIN pfm_portfolios pfm
ON pfm.id = pinv.portfolio_id
WHERE  prj.id IS NOT NULL
AND prj.is_active = 1
AND $X{IN,PFM.ID ,portfolioKey_1}
ORDER BY pfm.code

 

Outcomes